Reporting & Data Analyst - D365 (F & O)

Morgan Philips Group; London Borough of Newham; On-site; GBP 65,000 - 101,000; Full time

Job summary

Morgan Philips Group is seeking a Reporting & Data Analyst on a 6-month contract in East London to support the finance function with data migration, reconciliation and reporting from D365 F&O.

You will extract, transform and analyze data from D365 F&O, Excel, and legacy sources, perform data validation, and deliver clear, actionable financial insights to business stakeholders. Start in October or early November.

Qualifications

• Experience in data migration and reconciliation within finance systems.
• Ability to extract, transform and analyse data from multiple sources.
• Strong data validation and integrity controls.

Responsibilities

• Extract financial and operational data from D365 F&O and Excel sources.
• Support data migration by mapping and validating legacy datasets.
• Perform data reconciliation across systems to ensure data integrity.
• Transform data from unstructured sources using Power Query.
• Develop and maintain Excel-based reporting with advanced formulas.

Skills

Data migration

Data reconciliation

Data analysis

Data validation

D365 F&O

Excel

Power Query

Tools

D365 F&O

PivotTables

Power Query

Excel

Job description

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 operative 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.

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.