Data Engineer - Python & Azure

Low Carbon Contracts Company; Birmingham, Leeds; Hybrid; GBP 60,000 - 61,000; Full time

Job summary

An established industry player is seeking a Data Engineer to enhance its data ecosystems. In this role, you'll collaborate with developers and data scientists to build robust ETL/ELT pipelines, ensuring data integrity and reliability. With a focus on the Azure Data ecosystem, you'll utilize tools like Azure Databricks and Data Factory to transform data from various sources. This position offers a chance to drive data governance and support a data-driven culture while enjoying a comprehensive benefits package, including flexible working arrangements and a performance-based bonus. If you're passionate about data and eager to make a difference, this opportunity is for you.

Benefits

Annual performance-based bonus

25 days annual leave

Up to 8% pension contribution

Financial support for study

Employee referral scheme

Enhanced maternity leave

Free employee assistance

Three paid volunteering days

Season ticket loan

Gym discounts

Qualifications

• At least 1 year of data engineering experience in building data platforms.
• Hands-on experience with Azure Data ecosystem and Python.

Responsibilities

• Build and maintain ETL/ELT pipelines for data accuracy.
• Analyze data to identify patterns and ensure data flow.

Skills

Data Engineering

Azure Data Ecosystem

Python

SQL

ETL/ELT Pipelines

DevOps Pipelines

Process Optimisation

Tools

Azure Databricks

Azure Data Factory

Azure Data Lake

Azure Synapse

Job description

Data Engineer - Python & Azure

Application Deadline: 11 May 2025

Department: Tech Hub

Employment Type: Full Time

Location: Birmingham/Leeds

Reporting To: Data Engineer Manager

Compensation: Circa £60,000 depending on experience

Description

Contract type: Permanent
Hours: 37.5

Salary: Circa £61,000, depending on experience

Location: Leeds or Birmingham

WFH policy: Employees are required to attend the office 2 days/week
Travel: You will be required to travel to the London office once a month (this is expensed by the business)

Flexible working: Variety of flexible work patterns subject to line manager discretion e.g. Compressed 9-day fortnight.

Reports to: Data Engineer Manager
Deadline Note: We reserve the right to close the advert before the advertised deadline if there is a high volume of applications.

Role Summary:

As the Data Engineer, you will own LCCC’s data ecosystems and will work with developers, solution architects, technical BAs, analysts, data scientists, and other SMEs to define the optimum data platform for the business. You will build the required ETL/ELT pipelines for the ingesting, processing and storing of data and ensure data integrity, accuracy, and reliability throughout the data lifecycle.

You will have a specific focus on developing the data inputs that are utilised by the organisation’s internal forecasting model of the GB power markets and operations; designing a framework that scales effectively along with the source data.

Key Responsibilities

• Build and maintain ETL/ELT pipelines to make data accurate and easy to use
• Work to ingest and transform data sets from a variety of data sources including APIs, web scraping, backup databases and third-party services
• Analyze data to identify patterns, anomalies, and structure in preparation for Extract, Transform, and Load (ETL) processes
• Ensure efficient data synchronization and flow between various platforms and systems
• Explore ways to enhance data quality and reliability
• Assist with the establishment of a data culture across the organisation
• Drive better data governance through the creation and embedding of principles and processes e.g. Flow Diagram, Data Dictionary, Data Semantic Layers
• Set service level indicators and monitor execution of data workflows and configure alerts Identify data quality issues through data profiling, analysis and stakeholder engagement

Skills Knowledge and Expertise

Essential:

• At least 1 year of data engineering experience - building data platforms and supporting modelling and data analytics
• Hands on experience within the Azure Data ecosystem, with Azure Databricks, Data Factory, Data Lake, and Synapse. Certifications are a plus.
• Strong competence in Python, ideally with PySpark experience
• Strong competence in SQL
• Experience building and maintaining data pipelines
• Experience managing DevOps Pipelines
• Strong experience in process optimisation, performance tuning, data modelling and SQL/database design skills.

Desirable:

• Experience in data architecture

Employee Benefits

As if contributing to and supporting work that makes life better for millions wasn’t rewarding enough, we offer a full range of benefits too. Key benefits that may be available depending on the role include:

• Annual performance based bonus, up to 10%
• 25 days annual leave, plus eight bank holidays
• Up to 8% pension contribution
• Financial support and time off for study relevant to your role, plus a professional membership subscription
• Employee referral scheme (up to £1500), and colleague recognition scheme
• Family friendly policies, including enhanced maternity leave and shared parental leave
• Free, confidential employee assistance, including financial management, family care, mental health, and on-call GP service
• Three paid volunteering days a year
• Season ticket loan and cycle to work schemes
• Family savings on days out and English Heritage, gym discounts, cash back and discounts at selected retailers
• Employee resource groups