Junior Data Engineer

Join to apply for the Junior Data Engineer - 32482 role at Environment Agency Job Description The Environment Agency is fully committed to building 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. The Agency is modernising its systems and IT infrastructure, moving to Microsoft Azure cloud computing and Microsoft analytics tooling such as Synapse Analytics, Fabric and PowerBI. This transition offers an exciting opportunity within the Water Quality Digital Services team to pioneer new reporting and analytics solutions. As a Junior Analytics Engineer you will support the development and deployment of data products and analytics tools that enable the Water Quality user community to leverage data efficiently, driving business insights and policy changes. The Digital Services team operates across the country as a dispersed group, promoting a positive, inclusive, and supportive culture. We use evidence, expertise, engagement and innovation to enhance delivery and transform data into meaningful insights for decision‑making. Experience / Skills Required Extensive experience managing and analysing large datasets from multiple sources to support varied reporting and analytics needs. Experience organising data in STAR schema data models that 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. Contact and Additional Information You’ll have an inclusive incident management objective in your development plan. We’ll help you find a role to suit your needs and provide appropriate training. As a national role headquartered at EA Office, the working location is flexible/hybrid. Some travel and overnight stays may be required. Please read the Candidate/Additional Information Pack for details. Contact: andrew.chiverton@environment-agency.gov.uk Applications are “blind” assessed purely using your answers to the 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 retain your details for six months and may offer you an alternative post. Competencies Competence 1 – Focus on Efficiency, Innovation and Quality Describe a time when you implemented a new innovative approach to satisfy a specific data reporting requirement. Explain the approach and what you did to ensure the process was resilient, repeatable and quality‑assured. Competence 2 – Takes Decisions and Solves Problems Give an example of when you had to solve a complex data analysis problem involving diverse data sources. What data did you use? What was the problem and what decisions did you take to solve it? Competence 3 – Data and Information Management Provide an example of a complex data management task you undertook. Explain how you approached it and detail the data, tools and techniques used. Additional Information If you are applying from the Civil Service please note that the Environment Agency is not part of HM Civil Service and you will not be a Crown Servant. Continuous service is not applicable. Eligibility for continuity of employment for certain local government employees is outlined in the relevant statutory orders. We welcome flexible working patterns, including job share, for all vacancies. We also offer a Guaranteed Interview Policy to support applicants with a disability. The Agency is committed to providing value for money and uses Central Government frameworks for all external recruitment. Artificial intelligence can support your application, but all examples and statements must be truthful and directly from your own experience. Plagiarism or use of AI-generated content as your own may result in withdrawal of the application. Seniority Level Associate Employment Type Full-time Job Function Information Technology #J-18808-Ljbffr