Enterprise Data Engineer

Circa £42k, salary dependant on skills and experience

Base location in either Lincoln or Huntingdon (depending on your location) with hybrid working

Permanent

Full time, 37 hours per week

Do you enjoy building scalable data pipelines and analytical datasets that enable meaningful insight?

Are you experienced in data engineering and dimensional modelling, and interested in working with modern Azure data technologies?

If you’re a collaborative engineer who enjoys solving complex data challenges and continuously improving how data platforms operate, we have an exciting opportunity to join our data engineering team.

Our Data and Digital Services team delivers enterprise data and analytics capabilities across Anglian Water. Working on our Azure-based Lakehouse platform, you will help design and deliver scalable data solutions that support reporting, analytics, and insight across the organisation.

You will join an established Azure data platform team working in an Agile environment, collaborating closely with architects, product owners, analysts, and platform engineers.

You will work on a modern Azure Lakehouse data platform built using standardised engineering practices and reusable platform components.

The platform includes a bespoke engineering framework that provides reusable patterns, automation, and tooling to support the consistent development of data pipelines, dimensional models, and analytical datasets. This enables engineers to focus on solving data challenges while maintaining high standards for reliability, governance, testing, and deployment.

As a Data Engineer, you will design, build, and maintain data pipelines and analytical datasets on our Azure data platform. You will work across the lifecycle of data solution delivery, from understanding requirements through to implementing robust data models that support reporting and analytics.

This is a T-shaped role, where you will have core expertise in data engineering while contributing across multiple aspects of data solution delivery.

Key responsibilities include:

• Designing, developing, and maintaining scalable data pipelines that ingest and transform data from enterprise systems into the data platform.

• Designing and implementing dimensional data models using Kimball methodologies, including developing star schemas and analytical datasets to support reporting and analytics.

• Developing and maintaining Power BI semantic models to enable consistent and performant enterprise reporting.

• Supporting the end-to-end delivery of data and analytics solutions in collaboration with architects, analysts, and other engineers.

• Working within an Agile/Scrum delivery model, contributing to estimation, planning, and continuous improvement.

• Contributing to and extending automated testing frameworks to improve data reliability and test coverage across pipelines.

• Applying platform standards and engineering practices to ensure solutions are robust, maintainable, and secure.

• Collaborating with team members to maintain high standards for data quality, governance, and documentation.

• Sharing knowledge and supporting team members to maintain strong engineering practices across the platform.

While the primary focus of the role is data engineering and semantic modelling, engineers may occasionally support the development of Power BI reports and dashboards where required.

• Experience building data solutions using the Azure data platform

• Strong SQL skills and experience with Python and/or Spark

• Experience with
  Azure Databricks

• Practical experience designing dimensional data models (Kimball methodology)

• Experience delivering data and analytics solutions end-to-end

• Experience working within Agile/Scrum delivery teams

• Familiarity with Power BI semantic models

• Experience with
  Azure Data Factory and Unity Catalog

• Experience working with Delta Lake / Lakehouse architectures

• Experience with
  CI/CD and Dev Ops practices, including Git-based version control

• Exposure to Power BI report development

• Strong analytical and problem-solving skills

• Ability to work collaboratively within cross-functional teams

• C…