Associate Director Fire Engineer

Environment Agency; Greater London; On-site; GBP 100,000 - 125,000; Full time

Job summary

A public agency in the UK is seeking a Junior Analytics Engineer to support the development of data products and analytics tools for Water Quality services. The role requires managing large datasets, building ETL pipelines, and using Python for production-quality solutions. Ideal candidates will have a strong background in SQL Server and data analysis. The agency promotes diversity and welcomes flexible working arrangements, ensuring an inclusive environment for all applicants.

Qualifications

• Extensive experience managing and analysing large datasets.
• Experience in organising data in STAR schema data models.
• Experience building and maintaining reliable ETL pipelines.
• Strong Python expertise for production-quality solutions.
• Solid knowledge of SQL Server and data warehousing best practices.
• Proficiency with analytical tools for actionable insights.
• Ability to solve complex problems using sound data management.

Skills

Managing and analysing large datasets

Organising data in STAR schema

Building and maintaining ETL pipelines

Strong Python expertise

SQL Server knowledge

Transforming raw data into insights

Problem-solving skills

Promoting inclusion and collaboration

Job description

Job Description

Job Description The Environment Agency are fully committed to having an inclusive workforce to reflect the communities we serve. We don't just talk about diversity; we seek it, embrace it, and live it, for the benefit of our staff, our communities, and our environment. The Environment Agency is undergoing modernisation of systems and IT infrastructure and moving towards Microsoft Azure cloud computing and Microsoft analytics tooling and technology such as Synapse Analytics, Fabric and PowerBI. This represents a new and exciting opportunity for the Water Quality Digital Services team to become a pioneering group delivering new ways to do reporting and analytics. To prepare for this challenge 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., a Crown Servant in the event of being appointed. Therefore, you will not be eligible for continuous service.

For applicants who currently work 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 then you should contact your own HR Team.

We are fully committed to having a diverse and inclusive workforce to reflect the communities we serve. We welcome flexible working patterns for all our vacancies, including job share, so please include clearly 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 have committed to guaranteeing an interview to anyone with a disability whose application meets the minimum criteria for the post.

Experience/skills Required

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