Analytics Engineer
Description
Location: Oxford (2 days per week onsite)
Contract Length: 3 Months
Rate: £300 per day (Inside IR35)
Start Date: ASAP
We are looking for an experienced Data Analyst to support a finance reporting function built on Microsoft Fabric. The reporting environment and data model are already in place, and the focus of this role will be ensuring the accuracy, integrity and reconciliation of data feeding into business reports.
You will work across multiple source systems that load data at different frequencies, investigating discrepancies, validating data quality and making changes to data models, transformations and connections where required. This role is ideal for someone who enjoys getting into the detail of data and ensuring figures stand up to scrutiny.
Responsibilities- Reconcile financial data across multiple source systems.
- Investigate and resolve data quality and data integrity issues.
- Validate data loads arriving daily and monthly into Microsoft Fabric.
- Review data transformations and Power Query logic to identify issues.
- Analyse and troubleshoot Power BI semantic models and datasets.
- Use SQL to investigate anomalies and validate reporting outputs.
- Work with Finance stakeholders to understand and resolve discrepancies.
- Identify root causes of data mismatches and implement permanent fixes.
- Support ongoing maintenance and optimisation of reporting data structures.
- Ensure consistent, accurate and trusted reporting data across the organisation.
- Strong Power BI experience, particularly around data models and datasets.
- Advanced DAX skills.
- Strong SQL querying and troubleshooting experience.
- Experience with Power Query (M).
- Proven background in data reconciliation and data validation.
- Experience investigating complex data issues across multiple systems.
- Strong understanding of data modelling principles.
- Experience working with finance or accounting data.
- Excellent analytical and problem-solving skills.
- Experience with Microsoft Fabric.
- Experience supporting finance reporting environments.
- Understanding of ETL and data integration processes.
- Experience working with multiple source systems feeding a central reporting platform.
The ideal candidate will be a hands-on data professional who can quickly understand how data moves through an organisation, identify where figures do not reconcile and make the necessary changes to ensure reporting accuracy. This role is not focused on building dashboards but instead on ensuring the underlying data feeding reports is correct, complete and trusted.
Skills
Sign in to read and join the discussion.