Junior Data Engineer - 32482 at Environment Agency in East Markham, England, United Kingdom | Kablio

Role

Description

problem solving

data management

data analysis

solution design

Solve complex problems and formulate efficient and innovative solutions using sound data management and data analysis practices.

Requirements

python

sql server

etl

star schema

data analysis

inclusion

Proficiency with analytical tools and programming languages to transform raw data into actionable insights.
Ability to work effectively with people from diverse backgrounds while promoting inclusion and collaboration.
Experience building and maintaining reliable ETL pipelines to integrate data from diverse sources.
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.
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.
Extensive experience managing and analysing large datasets from multiple sources to support varied reporting and analytics needs.

Benefits

Information not given or found

Training + Development

Information not given or found

Interview process

blind assessment of competency questions.
initial sift may be conducted if a large number of applications are received.
successful candidates proceed to a full sift or directly to assessment/interview.
interviews held via ms teams within four weeks of the closing date.

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

Established to regulate and protect the environment, the agency plays a pivotal role in safeguarding natural resources.
With a mission to create a cleaner, healthier environment, it ensures proper management of water, waste, and air quality.
The agency works on diverse projects, from flood defense systems to energy-efficient infrastructure, enhancing public safety.
Key areas of specialization include water resources, marine protection, waste management, and sustainability in transport and utilities.
It operates across a broad spectrum of sectors, coordinating with governments and private entities to drive environmental improvements.
Notably, it manages complex flood risk programs and pollution control measures, often taking innovative approaches to problem-solving.
The agency is a cornerstone of the UK's environmental policies, ensuring compliance and setting benchmarks for future generations.

Culture + Values

We put the environment first in everything we do.
We work in partnership with others to achieve common goals.
We are innovative, using data and technology to drive change.
We are committed to protecting and improving the environment for future generations.
We are passionate about sustainability and resilience.
We support people to thrive, learn, and grow.

Environment + Sustainability

21% decrease

Carbon Footprint Reduction

Between 2019 and 2021, actively reducing greenhouse gas emissions.

1.3M properties

Flood Risk Reduction

Engaged in initiatives to mitigate flood hazards.

10,000 hectares

Land Restored

Committed to protecting and enhancing natural habitats.

Net Zero target by 2050.
Invested in sustainable infrastructure, such as flood defences and biodiversity improvements.
Promoting a green recovery from the COVID-19 pandemic by supporting sustainable development.

Inclusion & Diversity

6.6% gender pay gap

Reduced Gender Pay Gap

The company has successfully reduced its gender pay gap to 6.6% in 2021, reflecting progress toward pay equity.

34% female leaders

Women in Senior Roles

34% of senior leadership positions are held by women, showcasing increased representation at executive levels.

Action plan in place to increase diversity across the workforce.
Launched an initiative to increase the representation of ethnic minorities within leadership positions.
Annual diversity and inclusion training for all staff.

Articles

Careers at the Environment Agency

Environment Agency News

Company

Overview

Established to regulate and protect the environment, the agency plays a pivotal role in safeguarding natural resources.
With a mission to create a cleaner, healthier environment, it ensures proper management of water, waste, and air quality.
The agency works on diverse projects, from flood defense systems to energy-efficient infrastructure, enhancing public safety.
Key areas of specialization include water resources, marine protection, waste management, and sustainability in transport and utilities.
It operates across a broad spectrum of sectors, coordinating with governments and private entities to drive environmental improvements.
Notably, it manages complex flood risk programs and pollution control measures, often taking innovative approaches to problem-solving.
The agency is a cornerstone of the UK's environmental policies, ensuring compliance and setting benchmarks for future generations.

Culture + Values

We put the environment first in everything we do.
We work in partnership with others to achieve common goals.
We are innovative, using data and technology to drive change.
We are committed to protecting and improving the environment for future generations.
We are passionate about sustainability and resilience.
We support people to thrive, learn, and grow.

Environment + Sustainability

21% decrease

Carbon Footprint Reduction

Between 2019 and 2021, actively reducing greenhouse gas emissions.

1.3M properties

Flood Risk Reduction

Engaged in initiatives to mitigate flood hazards.

10,000 hectares

Land Restored

Committed to protecting and enhancing natural habitats.

Net Zero target by 2050.
Invested in sustainable infrastructure, such as flood defences and biodiversity improvements.
Promoting a green recovery from the COVID-19 pandemic by supporting sustainable development.

Inclusion & Diversity

6.6% gender pay gap

Reduced Gender Pay Gap

The company has successfully reduced its gender pay gap to 6.6% in 2021, reflecting progress toward pay equity.

34% female leaders

Women in Senior Roles

34% of senior leadership positions are held by women, showcasing increased representation at executive levels.

Action plan in place to increase diversity across the workforce.
Launched an initiative to increase the representation of ethnic minorities within leadership positions.
Annual diversity and inclusion training for all staff.

Articles

Careers at the Environment Agency

Environment Agency News