Data Engineer – Python & Azure

Contract type: Permanent
Hours: 37.5

Salary: Circa £60,000, depending on experience

Location: Leeds City Centre

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 advertisement before the advertised deadline if there are 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 diagrams, Data dictionaries, 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

About Low Carbon Contracts Company

The Low Carbon Contracts Company (LCCC) exists to help decarbonise the generation of electricity and make it more affordable for the future. Our work is central to the delivery of the government’s objective to achieve the Net Zero target by 2050.

Discover more about LCCC and what it’s like to work with us by watching this video: https://vimeo.com/1046713265

Please take the time to answer the optional diversity questions
At LCCC, we are dedicated to fostering a diverse and inclusive workplace where everyone can be their authentic selves and contribute to our mission of advancing a flexible energy future. Our aim is to be reflective of the environments where we operate and truly benefit from a rich tapestry of backgrounds and experiences where everyone thrives, which of course makes us stronger together. Your diversity data is valuable to us; it helps us understand whether we are effectively connecting with under-represented groups and realising our diversity aims. Please note that your diversity data will remain anonymised to us as it only feeds into high-level reports not connected to the candidates.