Data Engineer

Environment Agency; Birmingham; On-site; GBP 30,000 - 40,000; Full time

Job summary

A governmental organization in Birmingham is seeking a Junior Analytics Engineer to support their innovative Water Quality Digital Services team. The role includes developing and deploying data products and analytics tools while managing large datasets and ensuring effective reporting. Candidates should possess strong skills in Python and SQL Server, along with experience in data organization and ETL pipelines. The team promotes a positive and inclusive culture that values collaboration.

Benefits

Flexible working arrangements

Guaranteed interview policy for disabled candidates

Qualifications

• Extensive experience managing and analysing large datasets from multiple sources.
• Experience in organizing data in star-schema data models.
• Strong Python expertise for production-quality solutions.

Responsibilities

• Support the development and deployment of data products and analytics tools.
• Enable the Water Quality user community to leverage data effectively.
• Transform raw data into actionable insights.

Skills

Managing and analysing large datasets

Data organization in star-schema models

Building ETL pipelines

Python programming

SQL Server expertise

Analytical tools proficiency

Problem-solving and innovative solutions

Collaborative work with diverse teams

Job description

Job Description

The Environment Agency is undergoing modernisation of systems and IT infrastructure, moving towards Microsoft Azure cloud computing and analytics tooling such as Synapse Analytics, Fabric and Power BI. This represents a new and exciting opportunity for the Water Quality Digital Services team to become a pioneering group delivering new ways to do reporting and analytics. We are recruiting a Junior Analytics Engineer to support the development and deployment of data products and analytics tools to enable the Water Quality user community to efficiently leverage data from various sources, inform business insights, and drive policy changes.

This role is a Crown Servant position; continuous service is not applicable. If you are currently employed in local government or listed bodies, you may be eligible for continuous service for redundancy calculation.

Team

We focus on building innovative products that improve origination efficiency and enhance our ability to transform data into meaningful insights for effective decision‑making. Our dispersed team works across the country, promoting a positive, inclusive, and supportive culture.

Qualifications

• Extensive experience managing and analysing large datasets from multiple sources to support varied reporting and analytics needs.
• Experience in organising data in star‑schema data models that effectively represent business entities and relationships and support efficient querying and analysis from relational data warehouses.
• Experience building and maintaining reliable ETL pipelines to integrate data from diverse sources.
• 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 efficient and innovative solutions using sound data management and data analysis practices.
• Ability to work effectively with people from diverse backgrounds while promoting inclusion and collaboration.

Flexible Working

We welcome flexible working patterns for all our vacancies, including job share. Please include your preferred working arrangements on your application.

Guaranteed Interview

If you have a disability, the Agency has a Guaranteed Interview Policy to support you. A guaranteed interview will be offered if your application meets the minimum criteria for the post.

EEO Statement

The Environment Agency is a non‑departmental public body committed to providing value for money and utilises central government frameworks for all external recruitment needs. We seek a diverse and inclusive workforce and reflect the communities we serve.