Reporting & Data Analyst - D365 (F&O)

Reporting & Data Analyst - Contract - 6 months - D365 (F&O)

• Day rate is negotiable - more details provided on application.
• Outside IR35 - (3 days a week in East London) - that will fall back to one or two once you are established within the team.

Must be British or have ILR - NO SPONSORSHIP AVAILABLE
START IN OCTOBER OR FIRST WEEK OF NOVEMBER IS ESSENTIAL
We are looking for a Reporting & Data Analyst with proven data migration and reconciliation experience to join our Finance function, supporting the delivery of accurate, insightful financial and operational reporting across the Group.
Reporting to the Finance Systems / Reporting Lead (or relevant manager), this role sits at the intersection of finance, data and systems. You will play a vital role in ensuring data integrity during system transitions, managing data migration pipelines, and executing robust financial reconciliations.
You will be responsible for extracting, transforming and analysing data from Dynamics 365 Finance & Operations (D365 F&O), frontline operational systems, and a range of Excel sheets, legacy, and unstructured sources, translating complex datasets into clear, actionable insight for finance and operational stakeholders.
This role plays a key part in strengthening reporting capability, executing seamless data migrations, maintaining tight reconciliation controls, and supporting evidence-based decision-making across the business.
Key Responsibilities
Extract financial and operational data from D365 Finance & Operations, Excel-based applications, and core operational systems using appropriate tools and methods, including DMF, OData, and BYOD
Support data migration activities by mapping, validating, and transferring legacy financial and operational datasets into D365 F&O
Perform comprehensive data reconciliation across systems to ensure complete data integrity, identifying, investigating, and resolving any variances between legacy records, core operational platforms, and target environments
Transform and structure data from unstructured sources such as spreadsheets or CSV files using Power Query
Develop, maintain and improve Excel-based reporting, including PivotTables, Power Pivot models and advanced formulas
Perform data validation and cleansing activities, identifying root causes of data quality issues and implementing sustainable solutions
Work closely with finance, IT, and operational stakeholders to map out data lineage, document migration business rules, and deliver trusted financial reporting

Please note you will receive an automated response advising you that we have received your CV.

Morgan Philips Group is a global talent solutions business that disrupts conventional thinking in executive search, recruitment and talent consulting. We operate in over 18 markets in Europe, North & South America, Asia, and the Middle East & Africa. We understand that the future is digital and social, so we embrace the latest technology, including video ads and CVs, as well as social recruiting. Our innovative services are tailored to the new world of work yet we do not lose sight of the fact that employees be they existing and potential are ultimately human beings.

We are committed to ensuring that all job applicants are treated equally, without discrimination because of gender, sexual orientation, marital or civil partner status, gender reassignment, race, colour, nationality, ethnic or national origin, religion or belief, disability or age.