Junior Data Engineer – 32482
Environment Agency
The Environment Agency is modernising systems and IT infrastructure, moving towards Microsoft Azure cloud computing and analytics tools such as Synapse Analytics, Fabric and PowerBI. This offers a new opportunity for the Water Quality Digital Services team to deliver next‑generation reporting and analytics. We are recruiting a Junior Analytics Engineer to support the development and deployment of data products and analytics tools that enable the Water Quality user community to efficiently leverage data from various sources, improve business insights and drive effective policy changes.
Team
Join the Digital Services team within National Evidence and Business. We focus on building innovative products that improve efficiency and transform data into meaningful insights for effective decision‑making. The team is dispersed and works across the country in an inclusive, supportive culture.
Key Responsibilities
* Manage and analyse large datasets from multiple sources to support reporting and analytics needs.
* Design and organise data in STAR schema data models for efficient querying.
* Build and maintain reliable ETL pipelines to integrate diverse data sources.
* Develop clean, reusable Python functions and object‑oriented code for production‑quality solutions.
* Apply solid SQL Server and data warehousing best practices.
* Transform raw data into actionable insights using analytical tools and programming languages.
* Solve complex problems and formulate efficient, innovative solutions using sound data management practices.
* Collaborate with people from diverse backgrounds, promoting inclusion and collaboration.
Qualifications and Skills
* Extensive experience managing and analysing large datasets.
* Experience in organising data in STAR schema models.
* Experience building and maintaining ETL pipelines.
* Strong Python development skills.
* Solid knowledge of SQL Server, database management, and data warehousing best practices.
* Proficiency with analytical tools and programming languages.
* Strong problem‑solving skills.
* Excellent communication and collaboration skills.
Additional Information
Applications are “blind” assessed purely using responses to competency questions. Interviews will be held via MS Teams within four weeks of the closing date. If you consent to being held on a reserve list, we’ll hold your details for six months and may offer you an alternative post.
Contact: andrew.chiverton@environment-agency.gov.uk
EEO Statement
We are fully committed to having a diverse and inclusive workforce that reflects the communities we serve. We welcome flexible working patterns for all vacancies.
#J-18808-Ljbffr