Overview
The Data Analyst role focuses on hands-on data investigation and foundation-building, working to resolve data quality issues and supporting Power BI reporting for business decision-making. The contractor will engage with various business systems, collaborating with both technical and business stakeholders to enhance data integrity and analytical insights. This position requires strong SQL and Power BI skills, aimed at delivering actionable findings and reliable data frameworks.
Responsibilities
- Audit and reconcile data across multiple business systems to identify mismatches and inconsistencies.
- Perform root cause analysis on data discrepancies, tracing issues back to business processes, system configurations, or integration issues.
- Analyse and cleanse customer, product, and transactional data to resolve duplicates, incomplete records, and inconsistencies.
- Develop complex SQL queries to investigate, validate, and reconcile data across multiple data sources.
- Map data flows between systems and document where data quality issues occur.
- Identify process and governance gaps that contribute to poor data quality.
- Build and deliver Power BI dashboards using a clean and validated data layer.
- Produce clear documentation including data mappings, business definitions, and data quality findings.
Requirements
- Advanced SQL skills including complex joins, CTEs, window functions, and performance optimisation.
- Proven experience in Power BI development including data modelling, DAX, and report creation.
- Strong analytical skills with a focus on investigating and resolving data quality issues.
- Experience analyzing large, complex datasets and conducting root cause analysis.
- Ability to communicate effectively with both technical and non-technical stakeholders.
- Experience with CRM platforms like Salesforce or Microsoft Dynamics is beneficial.
- Familiarity with ERP systems such as SAP or Oracle is a plus.
- Understanding of Master Data Management (MDM) and data governance principles.