Enterprise Data Engineer

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.

Our Data Platform

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.

What will my role involve?

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., * 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

Desirable experience

• Experience with Azure Data Factory and Unity Catalog
• Experience working with Delta Lake / Lakehouse architectures
• Experience with CI/CD and DevOps practices, including Git-based version control
• Exposure to Power BI report development

Key behaviours and qualities

• Strong analytical and problem-solving skills
• Ability to work collaboratively within cross-functional teams
• Comfortable contributing across multiple areas of data solution delivery
• Strong communication and documentation skills
• Commitment to continuous learning and improving engineering practices, * Previous strong experience in data engineering ideally using Azure Databricks, Azure Data Factory, Spark, Python, SQL, Power BI
• Strong data engineering experience at least 3-5 years
• Dimensional data modelling
• Experience in delivering end to end BI solution from requirements, design to delivery
• Experience of working within an Agile/Scrum environment
• Experience/understanding of Product lifecycle management
• Knowledge of Azure DevOps or similar tools

• 26 days annual leave - rising with length of service
• Flexible working
• Pension scheme - Anglian Water double-matches your contributions up to 6%
• Bonus scheme
• Flexible benefits to support your wellbeing and lifestyle.

Why Anglian Water?

Anglian Water is not your typical water company. What we do really matters. Water is the lifeblood of our world and we're proud of the difference we make. We put people at the heart of our business, and we truly love what we do! If you're passionate about what you do and would like to make a difference, then we'd love to hear from you.

Inclusion at Anglian Water: Join us and make a difference. Our customers come from a wide range of backgrounds, and we think our workplace should reflect that. We are committed to making sure all our colleagues feel they belong and are supported to succeed. Together with our fellow water companies, we are committed to the Social Mobility Pledge; we are also a signatory to Business in the Community's Race at Work charter; we hold the Armed Forces Gold Covenant for Employers; we are an accredited Disability Confident employer and we play a leading part in the Women's Utility Network.