Data Engineer

Environment Agency; Greater London; Hybrid; GBP 30,000 - 40,000; Full time

Job summary

A governmental agency in the UK is seeking a Junior Analytics Engineer to support the development of data products for the Water Quality sector. In this role, you will design analytics tools and build ETL pipelines to convert diverse data sources into impactful insights. Candidates should possess strong skills in data management, particularly with Python and SQL Server. This role offers flexible hybrid working arrangements and opportunities for training and development.

Benefits

Flexible hybrid working arrangements

Training and development support

Qualifications

• Extensive experience managing and analyzing large datasets from multiple sources.
• Strong Python expertise for developing clean, reusable functions.
• Solid knowledge of SQL Server and data warehousing best practices.

Responsibilities

• Design, develop, and deploy data products and analytics tools.
• Build and maintain reliable ETL pipelines from diverse sources.
• Collaborate with cross-functional teams for scalable data solutions.

Skills

Managing and analyzing large datasets

Python expertise

SQL Server knowledge

ETL pipelines

Analytical tools proficiency

Job description

About the Environment Agency

We are fully committed to an inclusive workforce that reflects the communities we serve. We actively seek, embrace, and live diversity for the benefit of our staff, communities, and the environment.

Role Overview

We are recruiting a Junior Analytics Engineer to support the development and deployment of data products and analytics tools. In this role you will enable the Water Quality user community to efficiently leverage data from various sources, thereby informing business insights and driving effective policy changes within the Agency.

Key Responsibilities

• Design, develop, and deploy data products and analytics tools for the Water Quality domain.
• Build and maintain reliable ETL pipelines to integrate data from diverse sources.
• Analyse and transform raw data into actionable insights using Python, SQL Server and analytical tools.
• Collaborate with cross‑functional teams to ensure scalable and resilient data solutions.
• Support the adoption of Microsoft Azure cloud computing, Synapse Analytics, Fabric and PowerBI within the Water Quality Digital Services team.
• Document data models, design decisions, and best practices to promote knowledge sharing and repeatability.

Qualifications

• Extensive experience managing and analysing large datasets from multiple sources.
• Experience organising data in STAR schema data models that support efficient querying and analysis from relational data warehouses.
• Proven track record building and maintaining reliable ETL pipelines.
• Strong Python expertise, including development of clean, reusable functions and object‑oriented code for production quality solutions.
• Solid knowledge of SQL Server, database management and data warehousing best practices.
• Proficiency with analytical tools and programming languages to transform raw data into actionable insights.
• Ability to solve complex problems and formulate innovative solutions using sound data management and analysis practices.
• Ability to work effectively with people from diverse backgrounds while promoting inclusion and collaboration.

Working Conditions & Support

This is a national role based at the EA Office, with flexible hybrid working arrangements. Some travel and overnight stays may be required. We provide appropriate training, an inclusive incident‑management objective in your development plan, and support to help you find a role that suits your needs.

Application & Selection

Applications are blind assessed using competency‑based questions delivered via MS Teams within four weeks of the closing date. If you consent, we may keep you on a reserve list for up to six months. For more information, please read the Candidate / Additional Information Pack. For queries, contact [e-mail].