Junior Data Engineer

Job Description The Environment Agency is fully committed to having an inclusive workforce that reflects the communities it serves. We do not just talk about diversity; we seek, embrace, and live it for the benefit of our staff, communities, and the environment. The Agency is modernising its systems and IT infrastructure, moving towards Microsoft Azure cloud computing and analytics tools such as Synapse Analytics, Fabric and PowerBI. This creates an exciting opportunity for the Water Quality Digital Services team to deliver innovative reporting and analytics. We are recruiting a Junior Analytics Engineer to support the development and deployment of data products and analytics tools, enabling the Water Quality user community to efficiently leverage data from various sources and better inform business insights and policy changes. Team This role is part of the Digital Services team within National Evidence and Business (E&B). We build innovative products that improve origination efficiency and transform data into meaningful insights for decision‑making. We work as a dispersed team with partners across the country, promoting a positive, inclusive culture and using evidence, expertise, engagement and innovation to enhance delivery. 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 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, 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. Appropriate training will be provided. Join us at an EA Office base; as this is a national role, the working location is flexible/hybrid, and occasional travel and overnight stays may be required. Please read the Candidate / Additional Information Pack for further details. Any queries, 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 hold your details for six months and may offer you an alternative post. Competence 1 – Focuses on Efficiency, Innovation and Quality Describe a time when you implemented a new innovative approach to satisfy a specific data reporting requirement. Describe 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 that involved 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 have undertaken. Explain how you approached it and give details on the data, tools and techniques used. Other Information If you are applying from the Civil Service please note that the Environment Agency is not a part of HM Civil Service and you will not be a Crown Servant in the event of being appointed. For applicants working in local government or other bodies listed in the Redundancy Payments (Continuity of Employment in Local Government etc) (Modification) Order 1999, you may be eligible for continuous service for the purpose of calculating any future redundancy payment. If you are unsure of your status, contact your own HR team. We welcome flexible working patterns for all our vacancies, including job share. Please include any information regarding your preferred working arrangements on your application. We also have a Guaranteed Interview Policy to support those with a disability who are seeking employment. We guarantee an interview to anyone with a disability whose application meets the minimum criteria for the post. We are committed to providing value for money and utilising Central Government frameworks and contracts for all external recruitment needs. For more information on supplier frameworks, visit our supplier information page. Artificial Intelligence Statement Artificial intelligence can be a useful tool to support your application, however, all examples and statements provided must be truthful, factually accurate and taken directly from your own experience. Where plagiarism has been identified (presenting the ideas and experiences of others, or generated by AI, as your own) applications may be withdrawn and internal candidates may face disciplinary action. The Environment Agency is a non‑departmental public body sponsored by Defra and aligns with the candidate guidance on the use of artificial intelligence found on the Civil Service Careers website. #J-18808-Ljbffr