Reporting & Data Analyst FTC)
-
IT/Tech
Job Description & How to Apply Below
Location: London Borough of Newham
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.
WhatYou’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 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.
- 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 Pivot Tables, 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…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction