Reporting & Data Analyst - D365 (F&O)

Morgan Philips Group; City Of London; On-site; GBP 70,000 - 96,000; Full time

Job summary

Morgan Philips Group is seeking a Reporting & Data Analyst for a 6‑month contract in London. You will help migrate and reconcile data across finance systems, focusing on D365 F&O, Excel and unstructured sources to deliver accurate reporting.

You will work at the intersection of finance, data and systems, ensuring data integrity during transitions and supporting evidence-based decision-making across the business.

Qualifications

• Proven experience in data migration and reconciliation.
• Ability to extract, transform and analyse data from multiple sources.
• Experience with Dynamics 365 Finance & Operations (D365 F&O).
• Strong Excel skills including PivotTables and Power Pivot.
• Familiarity with data validation, cleansing and data lineage.

Responsibilities

• Extract data from D365 F&O, Excel apps and core systems using DMF, OData, BYOD.
• Support data migration by mapping, validating and transferring legacy datasets into D365 F&O.
• Perform data reconciliation across systems to ensure data integrity and resolve variances.
• Transform data from unstructured sources using Power Query.
• Develop and maintain Excel-based reporting with advanced formulas.

Skills

Data migration

Data reconciliation

D365 F&O

Excel

Power Query

PivotTables

Power Pivot

Data cleansing

Data lineage

DMF

OData

BYOD

Tools

D365 F&O

DMF

OData

Power Query

PivotTables

Power Pivot

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