Reporting & Data Analyst - 6 month (Internal)

Axis CLC Group; London Borough of Newham; On-site; GBP 63,000 - 77,000; Full time

Benefits offered by this job

Pension

Medical scheme

Life assurance

Perkbox

Job summary

Axis CLC is seeking a Reporting & Data Analyst to join the Finance team at our Head Office in Stratford, East London, on a fixed-term contract. You will extract, validate and reconcile financial and operational data from D365 F&O, Excel-based apps and legacy sources, translating complex datasets into clear insights for stakeholders.

You will map data, support migrations, build robust validations and develop Excel reporting models.

Qualifications

• Experience in migrating and validating data across systems.
• Ability to map legacy data to target models and verify data lineage.
• Strong reconciliation controls and data quality focus.
• Proficiency with D365 F&O, DMF, OData and BYOD.
• Advanced Excel skills for reporting and data modelling.

Responsibilities

• Extract data from D365 F&O and core systems for reporting.
• Support data migration by mapping and validating legacy datasets.
• Perform data reconciliation and resolve variances across platforms.
• Transform unstructured data using Power Query and create models for analysis.
• Develop and maintain Excel-based reporting (PivotTables, Power Pivot).
• Collaborate with Finance, IT and operations to ensure data integrity.

Skills

Data migration

Data mapping

Data reconciliation

Power Query

Excel reporting

Tools

D365 F&O

DMF

OData

BYOD

Power Query

Job description

Axis CLC is a national property maintenance and compliance partner, backed by over 110 years of combined experience. We employ more than 2,500 people and support over 400 clients across the UK, delivering essential repairs, refurbishment and building safety services that keep homes and public buildings operating at their best. Each year we complete over 400,000 repairs, helping to keep tenants safe, properties performing and owners fully compliant.

An exciting opportunity has arisen for a Reporting & Data Analyst to join the Finance team at the Head Office in Stratford, East London, on a fixed-term contract. The successful candidate will play a key role in supporting data migration, validation and reconciliation activities, ensuring the delivery of accurate and reliable financial and operational reporting. Working closely with Finance, IT and operational stakeholders, the role will help maintain data integrity, enhance reporting capabilities and provide valuable insights to support business performance and informed decision-making across the Group.

Reporting to the Finance Systems Reporting Lead, this role sits at the intersection of finance, data and systems. The Reporting & Data Analyst will play a vital role in ensuring data integrity during system transitions, managing data migration pipelines, and executing robust financial reconciliations. It will also 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.

What You’ll Do

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

About You

• Proven experience in data migration, data mapping, validation and reconciliation across multiple systems.
• Strong understanding of financial data structures, reporting requirements and reconciliation controls.
• Experience working with Microsoft Dynamics 365 Finance & Operations (D365 F&O), including DMF, OData and BYOD.
• Advanced Microsoft Excel skills, including PivotTables, Power Pivot, Power Query, complex formulas and data modelling.
• Strong data analysis skills with the ability to extract meaningful insights from large and complex datasets.
• Experience transforming and cleansing data from legacy systems, spreadsheets, CSV files and other unstructured data sources.
• Excellent attention to detail with a focus on data accuracy, integrity and quality assurance.
• Ability to identify, investigate and resolve data discrepancies and reconciliation issues.
• Understanding of data governance, data lineage and data quality management principles.
• Strong problem-solving skills with the ability to analyse root causes and implement sustainable improvements.
• Experience producing clear, concise and meaningful financial and operational reports for a range of stakeholders.
• Ability to communicate complex technical and data-related information to non-technical audiences.
• Strong stakeholder management skills with experience collaborating across Finance, IT and operational teams.
• Knowledge of reporting and business intelligence tools would be advantageous.

What We Offer

• Salary up to £70,000 depending on experience
• Pension, medical scheme options and life assurance
• 25 days’ holiday (Pro Rata) + bank holidays
• Perkbox benefits worth up to £350 per year, including discounts, perks and wellbeing support
• 24/7 GP referral and wellbeing support service
• 1 paid volunteer day
• £2,000 refer-a-friend bonus after the referee passes probation
• Opportunities for development and progression across Axis CLC

Why Axis CLC

Joining Axis CLC means being part of a national team delivering essential services across housing, education, healthcare, defence and commercial property. We value reliability, quality and social impact, and offer meaningful work with real opportunities to grow.

Our Commitment to Inclusion

Many faces, one Axis CLC. We value diversity and are proud to be an equal-opportunity employer. If you need any adjustments during the hiring process, please let us know.