Junior Data Engineer

Junior Data Engineer - 32482 Environment Agency Job Description The Environment Agency is fully committed to an inclusive workforce that reflects the communities we serve. We do not only talk about diversity; we actively seek, embrace, and live it for the benefit of our staff, our communities, and our environment. The Agency is modernising its systems and IT infrastructure and moving towards Microsoft Azure cloud computing and Microsoft analytics tooling, including Synapse Analytics, Fabric and PowerBI. This creates an exciting opportunity for the Water Quality Digital Services team to pioneer new ways of reporting and analytics. As a Junior Data Engineer you will support the development and deployment of data products and analytics tools to enable the Water Quality user community to leverage data from various sources, inform business insights, and drive effective policy changes. The Team The Digital Services team, part of National Evidence and Business (E&B), focuses on building innovative products that improve origination efficiency and help transform data into meaningful insights for effective decision‑making. We are a dispersed team that works with colleagues across the country and promotes a positive, inclusive, and supportive culture. 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 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, innovative solutions using sound data management and analysis practices. Ability to work effectively with people from diverse backgrounds while promoting inclusion and collaboration. Contact & Additional Information Your development plan will include an inclusive incident management objective. Appropriate training will be provided. The role is national; the working location is flexible / hybrid, but some travel and overnights may be required. Read the Candidate / Additional Information Pack for more information. For any queries, contact andrew.chiverton@environment‑agency.gov.uk. Application Process 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 will hold your details for six months and may offer you an alternative post. Competency Questions 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. Detail how 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 this and provide details on the data, tools and techniques used. Civil Service 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. Therefore you will not be eligible for continuous service. For applicants currently working in local government or other bodies covered by the Redundancy Payments (Continuity of Employment in Local Government etc) 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 HR team. EEO Statement We are fully committed to having a diverse and inclusive workforce to reflect the communities we serve. Flexible working patterns are available for all vacancies, including job share. Specialist support and a Guaranteed Interview Policy are in place for those with a disability. AI Guidance Artificial intelligence may support your application. All examples and statements must be truthful, factually accurate and taken directly from your own experience. Plagiarism or AI‑generated content presented as your own may lead to application withdrawal or disciplinary action. #J-18808-Ljbffr