Reporting and Data Analyst

Axis Europe; Greater London; On-site; GBP 65,000 - 75,000; Full time

Job summary

A national property maintenance partner in Greater London seeks a Reporting & Data Analyst to enhance financial reporting and support decision-making. In this role, you will extract data from Dynamics 365, develop Excel reports, and create Power BI dashboards. The position requires 3-5 years of experience in data analytics, strong SQL skills, and a capability to present insights to stakeholders. The company offers a competitive salary and benefits including 25 days holiday and a pension scheme.

Benefits

Pension scheme and life assurance

25 days’ holiday plus bank holidays

£2,000 refer-a-friend bonus

Qualifications

• 3-5 years’ experience in a data, reporting or analytics role.
• Practical experience with Dynamics 365 and core finance modules.
• Proven ability to analyze large and unstructured datasets.

Responsibilities

• Extract and analyze data from D365 Finance & Operations.
• Develop and maintain Excel-based financial reporting.
• Build and maintain Power BI dashboards for performance indicators.

Skills

Data extraction and analysis

Advanced Excel capabilities

SQL skills

Power BI dashboard development

Effective communication

Tools

Dynamics 365 Finance & Operations

Power Query

Power Automate

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.

We are looking for a Reporting & Data Analyst 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 be responsible for extracting, transforming and analysing data from Dynamics 365 Finance & Operations (D365 F&O) and a range of 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, improving data quality and supporting evidence‑based decision‑making across the business.

Key Responsibilities

You’ll:

• Extract financial and operational data from D365 Finance & Operations using appropriate tools and methods, including DMF, OData and BYOD
• Transform and structure data from unstructured sources such as spreadsheets, CSV files, PDFs and text‑based reports using Power Query
• Develop, maintain and improve Excel‑based reporting, including PivotTables, Power Pivot models and advanced formulas
• Build and maintain Power BI dashboards to support reporting of key performance indicators, including AR/AP, cash flow and project accounting
• Perform data validation and cleansing activities, identifying root causes of data quality issues and implementing sustainable solutions
• Work closely with finance and operational stakeholders to understand reporting requirements and translate technical outputs into clear business insight
• Support the automation and standardisation of reporting processes to improve efficiency, consistency and control
• Contribute to continuous improvement initiatives relating to finance systems, data governance and reporting frameworks

Skills, Knowledge & Experience

Essential

• 3-5 years’ experience in a data, reporting or analytics role, ideally within a finance or ERP environment
• Practical experience working with Dynamics 365 Finance & Operations, with an understanding of core finance modules (GL, AP, AR)
• Advanced Excel capability, including Power Query, Power Pivot and complex formulas
• Strong SQL skills, with experience writing queries involving joins and aggregations
• Proven ability to work with large, inconsistent or unstructured datasets
• Strong analytical skills with the ability to present clear, meaningful insight to non‑technical stakeholders

Desirable

• Experience using Power BI for dashboard development and reporting
• Exposure to Power Automate, Azure Data Lake or Microsoft Fabric
• Experience supporting finance or reporting transformation initiatives
• Relevant Microsoft certifications (e.g. D365 Fundamentals MB-920 or PL-300)

What We Offer

• Salary £65,000 - £75,000 per annum (dependent on experience)
• A competitive salary package with a performance‑related bonus
• Pension scheme and life assurance
• 25 days’ holiday plus bank holidays
• Perkbox (discounts, perks and wellbeing offers)
• 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 insight, quality and evidence‑based decision‑making, and offer roles where your work directly influences business performance and long‑term growth.

Our Commitment to Inclusion

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