Data Engineer (Geospatial & Data Pipelines) - NHS

You'll design, build, and maintain data pipelines that transform raw data into consistent, high-quality outputs. Working closely with analysts and stakeholders, you will ensure datasets are accurate, well-documented, and geospatially contextualised., * Establish import/export patterns, handle data extracts, schema discovery, incremental loads, and multiple source instances.

• Build transformation-heavy pipelines, including profiling, cleansing, standardisation, conformance, and publishing.
• Apply advanced SQL for joins, deduplication, anomaly detection, profiling, and performance tuning.
• Develop Python scripts for automation, parsing, rules engines, and data quality checks using packages like Pandas, Polars, scikit-learn, and matplotlib.
• Work with modern data tooling (Spark, Azure Data Factory, or code equivalents).
• Handle geospatial data, including vector, raster, GeoJSON, and shapefiles, applying coordinate reference systems and spatial analysis workflows.
• Aggregate and translate local/regional geospatial insights into national or regional datasets.
• Work with public datasets, including ONS products such as census boundaries, geographic lookups, deprivation indices, and mid-year population estimates.
• Implement rules for data completeness, validity, and consistency, including exception handling.

• Proven experience as a Data Engineer building robust, transformation-heavy pipelines.
• Advanced SQL and Python skills for data processing and automation.
• Experience with geospatial data and public datasets (ONS).
• Familiarity with modern data tooling or equivalent coding solutions.
• Ability to interpret and apply geographical context in pipelines.
• Strong communication and collaboration skills.
• Must hold or be eligible for BPSS clearance.

Desirable

• Experience with NHS or public-sector datasets.
• Knowledge of geospatial data modelling and analytical workflows.