Reporting & Data Analyst
Role details
Job location
Tech stack
Job description
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., You will:
- 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
Requirements
- 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)
Benefits & conditions
- 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.
