32482 - Junior Data Engineer
| Posting date: | 05 December 2025 |
|---|---|
| Salary: | £43,198 per year |
| Hours: | Full time |
| Closing date: | 24 December 2025 |
| Location: | UK |
| Remote working: | Hybrid - work remotely up to 5 days per week |
| Company: | Environment Agency |
| Job type: | Permanent |
| Job reference: | 32482 |
Summary
The Environment Agency are fully committed to having an inclusive workforce to reflect the communities we serve. We don't just talk about diversity; we seek it, embrace it, and live it, for the benefit of our staff, our communities, and our environment.
The Environment Agency is undergoing modernisation of systems and IT infrastructure and moving towards Microsoft Azure cloud computing and Microsoft analytics tooling and technology such as Synapse Analytics, Fabric and PowerBI. 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. To prepare for this challenge 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 and, in turn, better inform business insights and drive effective policy changes.
The team
This is an exciting opportunity to join the Digital Services team within National Evidence and Business (E&B). We focus on building innovative products that improve origination efficiency and enhance our ability to transform data into meaningful insights for effective decision-making.
We’re a dispersed team and work with teams across the country. We promote a positive, inclusive, and supportive culture where everyone feels valued. We use evidence, expertise, engagement, and innovation to enhance delivery.
Experience/skills required
Applicant must have:
• 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.
• 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.
The Environment Agency is undergoing modernisation of systems and IT infrastructure and moving towards Microsoft Azure cloud computing and Microsoft analytics tooling and technology such as Synapse Analytics, Fabric and PowerBI. 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. To prepare for this challenge 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 and, in turn, better inform business insights and drive effective policy changes.
The team
This is an exciting opportunity to join the Digital Services team within National Evidence and Business (E&B). We focus on building innovative products that improve origination efficiency and enhance our ability to transform data into meaningful insights for effective decision-making.
We’re a dispersed team and work with teams across the country. We promote a positive, inclusive, and supportive culture where everyone feels valued. We use evidence, expertise, engagement, and innovation to enhance delivery.
Experience/skills required
Applicant must have:
• 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.
• 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.