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 teamMust be British or have ILR - NO SPONSORSHIP AVAILABLE
Summary of the role/what actually we need a contractor to do:
The data structure work is central, but the platform is Microsoft Fabric rather than a standalone SQL Server build. Strong SQL (T-SQL or Spark SQL) is needed, but we are not looking for a database administrator.
What matters most:
Hands-on knowledge of how D365 Finance & Operations holds its data: the general ledger, financial dimensions, and project transactions through to GL detail. They should be able to trace a project invoice to its ledger lines themselves.
Building the translation layer: mapping our current custom single-company structures to the new group-wide multi-company F&O structures, in a bronze, silver and gold (medallion) model with star schemas in Fabric.
Reconciliation: tying migrated and reported data back to the GL, and building checks into the pipeline.
Finance judgement: categorising revenue, accruals and cost with accountants, and iterating on the results with the business.Useful extras: experience taking F&O data into Fabric or Synapse (for example via Fabric Link), D365 data entities, and migrating existing Power BI reports onto a new platform.
F&O finance or project data work on an implementation or migration, not only report building.
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
