Reporting & Data Analyst - D365 (F & O)

Reporting & Data Analyst - D365 (F & O)

Temporary 40500 - 49500 £ / year (est.) Hybrid
M

At a Glance

  • Tasks: Extract, transform, and analyse data to support financial reporting and data migration.
  • Company: Join a dynamic finance team in East London with a focus on data integrity.
  • Benefits: Negotiable day rate, flexible working, and opportunities for professional growth.
  • Other info: Contract role with potential for career advancement in a collaborative environment.
  • Why this job: Make an impact by ensuring accurate financial insights and seamless data transitions.
  • Qualifications: Experience in data migration, reconciliation, and proficiency in D365 F&O and Excel.

The predicted salary is between 40500 - 49500 £ per year.

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 Pivot Tables, 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.

Reporting & Data Analyst - D365 (F & O) employer: Morgan Philips Group

As a leading independent oil and gas exploration and production company, we pride ourselves on fostering a collaborative and innovative work culture in our London office. Employees benefit from competitive remuneration, comprehensive professional development opportunities, and the chance to work alongside industry experts in a dynamic environment that encourages growth and creativity. Join us to be part of a forward-thinking team that is shaping the future of energy.

M

Contact Details:

Morgan Philips Group Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Reporting & Data Analyst - D365 (F & O)

✨Tap into Online Data Science Communities

Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like Morgan Philips Group before they're even advertised!

✨Show Off Your Skills With Projects

Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.

✨Check Out Specialist Job Boards

For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like Morgan Philips Group.

✨Leverage University Resources

If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like Morgan Philips Group.

We think you need these skills to ace Reporting & Data Analyst - D365 (F & O)

Data Migration
Data Reconciliation
Dynamics 365 Finance & Operations (D365 F&O)
Data Extraction
Data Transformation
Power Query
Excel Reporting

Some tips for your application 🫡

Highlight Your Data Projects:When applying for a temporary data science role at Morgan Philips Group, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.

Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!

Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to Morgan Philips Group, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.

Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab Morgan Philips Group’s attention and show the tangible impact of your work.

How to prepare for a job interview at Morgan Philips Group

✨Showcase Your Analytical Skills

For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at Morgan Philips Group.

✨Brush Up on Technical Skills

You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.

✨Highlight Your Adaptability

Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at Morgan Philips Group.

✨Prepare a Portfolio of Your Work

Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at Morgan Philips Group.