Senior Data Engineer

1w1 week ago

Lancashire County Council

Preston, GB · Full-time · £46,142 – £51,356

About this role

Data has the power to transform how public services are delivered, and at Lancashire County Council, we’re investing in modern data engineering to make that transformation real. We’re looking for a Senior Data Engineer to play a key technical leadership role in modernising data platforms, automating data flows, and enabling high-quality analytics.

This hands-on role involves designing, building, and deploying scalable, automated ETL/ELT pipelines. Re-engineer manual data processes into robust, repeatable data flows and optimise platforms to support analytics, reporting, and statutory returns. Develop solutions using Microsoft Azure technologies including OneLake, Fabric, Azure SQL, and SQL Server.

Create dimensional data models and assured datasets to support insight and decision-making. Take technical ownership of solution designs aligned to the Council’s target data architecture. Work in an Agile, DevOps-led environment using Azure DevOps and CI/CD practices while mentoring less experienced engineers.

Engage stakeholders to propose innovative, value-driven solutions and support data quality, master data management, and cataloguing. Be part of a forward-thinking digital and data community influencing modern data architecture. Enjoy strong commitment to learning, development, progression, and flexible hybrid working.

Requirements

Strong experience in data engineering within cloud-based platforms (Azure preferred)
Proven experience delivering end-to-end data solutions
Excellent SQL skills including performance optimisation
Experience with ETL, data integration and analytics platforms
Experience with Python, Java or Scala
Knowledge of DevOps and Agile delivery
Ability to communicate complex technical concepts clearly
Experience mentoring or supporting other engineers

Responsibilities

Design, build and deploy scalable, automated ETL/ELT pipelines
Re-engineer manual data processes into robust, repeatable data flows
Optimise data platforms to support analytics, reporting and statutory returns
Develop and maintain solutions using Microsoft Azure technologies, including Microsoft OneLake, Fabric, Azure SQL and SQL Server
Create dimensional data models and assured datasets that support insight and decision-making
Support data quality, master data management and data cataloguing
Take technical ownership of solution designs aligned to the Council’s target data architecture
Mentor and support less experienced engineers