A strong Data Analyst is required to work on a Data Transformation workstream within a complex, end-to-end service delivery environment. The role supports a programme focused on modernising and transforming a large-scale national service through modern, data-driven digital capabilities.

Working as part of a small team of data specialists, you will analyse existing datasets distributed across multiple system instances to identify and resolve data quality issues, and to help define and shape future target datasets and data structures.

• Assess data completeness, validity, consistency, and uniqueness, and interpret what issues mean operationally

• Contribute to defining core entities, relationships, and a minimum viable dataset aligned to a target schema

• Map legacy data fields to target data dictionary definitions, identifying ambiguous usage and proposing standardised definitions

• Analyse duplicates, conflicts, and missing data, proposing resolution options and documenting trade-offs

• Work closely with subject matter experts and operational stakeholders to agree approaches to handling anomalies and confirm business meaning

• Produce clear, decision-ready outputs such as issue summaries, dashboards, reconciliation lists, and sign-off packs

• Experience using tools such as Power BI (or similar) for reporting and visualisation of analytical findings

• Create clear and readable analytical documentation detailing methods, assumptions, business rules, and limitations to enable review and repeatability

• Strong SQL skills for data analysis and validation, including the ability to validate engineering outputs and verify transformation results

Soft skills are just as important as technical capability for this role. You will need to demonstrate:

• Strong communication and collaboration skills, with the ability to build effective working relationships

• A collaborative, team-oriented mindset, working well with a wide range of internal and external stakeholders

• An enthusiastic, engaged, and positive attitude

• A proactive approach, with the drive to progress work independently without constant direction

• The ability to handle ambiguity and adapt to change in a fast-moving environment

• Proven experience working with geospatial data, including spatial formats (e.g. vector, raster, GeoJSON, shapefiles), coordinate reference systems, and spatial analysis workflows

• Strong ability to interpret and apply geographical context within data processing pipelines

• Demonstrated experience identifying local or regional geospatial insights and integrating them into broader national or regional-level datasets and analytical outputs

• Experience working with publicly available official datasets, particularly open data products such as census boundaries, geographic lookups, deprivation indices, or population estimates