Data Engineer

Environment Agency; Waterlooville; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A governmental agency for environmental management is seeking a Junior Analytics Engineer to join their Water Quality Digital Services team. This role entails supporting the development and deployment of data products and analytics tools, enhancing the user community's ability to leverage data effectively. Candidates should have strong skills in managing large datasets, Python programming, and SQL Server. The position supports flexible and hybrid working arrangements, with occasional travel required.

Benefits

Flexible working patterns

Diversity and inclusion commitment

Guaranteed Interview Policy for disabled applicants

Qualifications

• Extensive experience managing and analyzing large datasets from multiple sources.
• Experience in organizing data in STAR schema data models.
• Strong Python expertise and knowledge of SQL Server.

Responsibilities

• Support the development of data products and analytics tools.
• Enable the Water Quality user community to leverage data.
• Drive business insights and policy changes.

Skills

Data analysis

Python

SQL Server

ETL pipeline development

Data modeling

Problem-solving

Job description

Overview

The Environment Agency is modernising systems and IT infrastructure and moving toward Microsoft Azure cloud computing and analytics tooling such as Synapse Analytics, Fabric and PowerBI. This represents a new and exciting opportunity for the Water Quality Digital Services team to deliver new reporting and analytics. 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.

Team and Role

The Digital Services team within National Evidence and Business (E&B) focuses on building innovative products that improve origination efficiency and transform data into meaningful insights for effective decision-making. We are a dispersed team and work with teams across the country. We promote a positive, inclusive, and supportive culture where everyone feels valued. The role is based at an EA Office location; as a national role the working location is flexible / hybrid. Some travel and overnight stays may be required.

Responsibilities

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 drive business insights and policy changes.

Qualifications

• 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.

Additional information

We welcome flexible working patterns for all our vacancies, including job share, and have a Guaranteed Interview Policy to support those with a disability. If you are unsure of your status, please contact your HR Team. The Environment Agency is committed to having a diverse and inclusive workforce to reflect the communities we serve, and uses Central Government frameworks for external recruitment needs. For those interested in becoming a supplier on these frameworks, please visit the Crown Commercial Service information page. This role may reference guidance on the use of artificial intelligence; ensure all examples come from your own experience and are truthful.