Data Engineer

OFWAT; Birmingham; Hybrid; GBP 40,000 - 60,000; Full time

Job summary

Ofwat is seeking a Data Engineer to join their emerging Data Platform Team in Birmingham. This role involves integrating legacy and new data systems, utilizing skills in Python and SQL to support a significant data modernization programme, Programme Ocean. Candidates will work to enhance data integrity and develop solutions that positively impact water resilience.

Benefits

Meaningful Impact

Innovative Work Environment

Development Opportunities

Work-Life Balance

Pension contribution of nearly 30%

25 days annual leave

Access to exclusive discounts

Membership fees covered

Up to 3 volunteering days

Generous parental leave

Qualifications

• Proficient in Python for data manipulation and automation.
• Experience with data warehouse methods and ETL.
• Strong skills in relational databases and SQL.

Responsibilities

• Work on legacy and new data platforms, ensuring integrity.
• Develop solutions and pipelines for data transformation.
• Support migration to new data platforms.

Skills

Python

SQL

ETL processes

Linux

Microsoft Fabric/Azure

CI/CD tooling

Job description

Join Ofwat’s IT Team as a Data Engineer

*OfficeLocation: Birmingham (B5 4UA) with hybrid working*

About Us

We are Ofwat, the Water Services Regulation Authority, a non-ministerial government department responsible for regulating the water sector in England and Wales. Our work has genuine significance – no other organisation does the work we do. It’s unique and meaningful: keeping our water flowing; ensuring water bills don’t cost a penny more than needed; holding water companies to account. Come and work at the source of everyday life.

The Role

We are offering an opportunity for a talented Data Engineer to join our emerging Data Platform Team. This team is expanding as part of our plans to upgrade and modernise our data platform through Ofwat's dedicated programme – Programme Ocean. Programme Ocean is an ambitious data modernisation programme using cutting edge and evolving technology as we look to maximise the data and bring value added insights to Ofwat. The platform has been built using Microsoft tools – Fabric, Purview and Power Bi.

As Data Engineer, you'll work on both our legacy data platform (Fountain) as well as the new Data Platform, blending the old and new and making sure that there is integrity and the right framework of pipelines and processes to be able to move to the new data platform. Whilst a key part of the role will be to ensure that we continue to support the business on the Fountain platform, the role will be key in helping to migrate to the new platform.

There will be opportunities to work on a range of technologies not just those supporting the Ocean Data Platform but will expand to other Microsoft 365 tools and software that supports other data services across Ofwat, be it those in operation or on new innovation and experimentation initiatives.

You'll work in a small team of Data Engineers, alongside other Digital and IT roles, to bridge the gap between data producers and data users, developing solutions, pipelines, and self-service tools to acquire and transform data, making it available in our new data ecosystem. You will work alongside the Programme Ocean and Data Strategy team to ensure we are delivering on our programme outcomes to migrate to a modern data platform to support our regulatory duties.

To find more details about the role and deliverables please click Apply.

About You

Below are some of the key essential experience, skills & knowledge required for this post:

1. Software Development Skills: Strong proficiency in Python for data manipulation, scripting, and automation tasks.
2. Experience in data warehouse methods and techniques, including ETL processes, data modelling and design.
3. Linux: strong experience with Linux command line and scripting.
4. Software development experience with data-processing platforms including experience with Microsoft Fabric/Azure Synapse Analytics/Databricks.
5. Relational Databases/SQL: Deep understanding and hands-on experience with relational databases, including proficiency in SQL for data querying and management.
6. CI/CD tooling: Practical knowledge of using and configuring deployment tools, such as Azure DevOps (ADO), GitHub, ARM/Bicep.

Why You Should Join Us:

• Meaningful Impact:You will be joining a team with a sense of mission at its core aiming to build a lasting legacy for future generations by securing our long-term water resilience.
• Innovative Work Environment:We embrace agile and new ways of working and have a culture build on trust, flexibility, and collaboration.
• Development Opportunities:Gain valuable experience and develop your skills in a supportive and dynamic setting.
• Work-Life Balance:Enjoy the flexibility of working from home combined with the benefits of in person collaboration in our London or Birmingham offices.
• Fantastic employer pension contributionof nearly 30%.
• 25 days’ annual leave,increasing to 30 with each year of service, plus bank holidays and an extra 2.5 days of privilege leave.
• Access to exclusive discountson a variety of goods and services, including retail outlets, theatre tickets, holidays, insurance, and a gym membership.
• Fees paid for membershipof relevant professional bodies.
• Up to 3 volunteering daysper year.
• Recognition vouchers scheme rewarding your hard work.
• Generous shared parental leave and paysupporting your family life.

Follow the link to Apply for full details about the role, please ensure you have submitted your Applications in full before the below deadline.

Closing date:23.55 on 15 June 2025.