Reporting & Data Analyst
Axis CLC
- Stratford, England, United Kingdom
- Stratford, England, United Kingdom
About
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 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
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
Languages
- English
Notice for Users
This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.