Senior Data Engineer

CFP Energy; England; On-site; GBP 60,000 - 80,000; Full time

Job summary

An innovative energy firm in the UK is seeking a Senior Data Engineer to design, build, and scale their data infrastructure. In this mid-senior level role, you'll work closely with developers and analysts to enhance data reliability and analytics. The ideal candidate will have extensive experience in Python and SQL, along with a collaborative mindset. This full-time opportunity provides a chance to contribute to pioneering energy and sustainability solutions.

Qualifications

• Understanding of application databases and data warehouses.
• Proven expertise in Python, familiarity with C# is beneficial.
• Comfortable writing complex SQL queries.
• Experience with containerized environments.
• Experience with cloud ecosystems, especially Azure.

Responsibilities

• Design, build, and maintain robust data pipelines.
• Participate in architectural discussions.
• Build and optimize ETL/ELT processes.
• Develop structured data models.
• Collaborate with teams to deliver data solutions.

Skills

Collaborative mindset

Analytical thinking

Problem-solving ability

Clear communication

Tools

Python

SQL

Containers

Cloud platforms (Azure)

Job description

Join to apply for the Senior Data Engineer role at CFP Energy

We’re looking for a Senior Data Engineer to help design, build, and scale the data infrastructure that powers our products and decision-making. You’ll play a key role in shaping how data flows across the organisation, from ingestion and processing to analytics and insights.

You’ll collaborate with developers, analysts, and the trading teams to make sure our data is reliable, accessible, and built for the future. This role combines hands‑on engineering with architectural thinking; where you’ll contribute to design discussions, improve data pipelines, and help set technical direction.

We want someone who’s comfortable taking ownership, enjoys solving complex problems, and can work across multiple systems and teams to deliver real impact.

Key Responsibilities

• Design, build, and maintain robust data pipelines that support analytics, BI reporting, and product use cases.
• Participate in architectural discussions and contribute to the long‑term technical roadmap.
• Build and optimise ETL/ELT processes to handle small to large‑scale data processing needs.
• Develop well‑structured data models and maintain clear documentation to support data discovery and self‑service analytics.
• Collaborate closely with software developers, analysts, and trading teams to understand requirements and deliver reliable, well‑designed data solutions.
• Identify opportunities to improve performance, automate manual processes, and enhance data quality and reliability across systems.

Core Skillset

• Collaborative mindset: We value people who are not only skilled but genuinely enjoyable to work with. You foster a positive, respectful team culture and communicate openly to get things done together.
• Analytical thinking: Performance and accuracy are central to what we do. You bring curiosity, structure, and a strong attention to detail to every challenge.
• Problem‑solving ability: You’re comfortable tracing issues through multiple systems and services to uncover root causes. You stay calm under pressure and take pride in finding elegant, lasting solutions.
• Clear communication: You can explain complex technical concepts clearly and confidently, bridging the gap between technical and non‑technical teams to keep everyone aligned.

Required Skills & Experiences

• Data warehousing: You should be able to understand the difference between application databases and analytical warehouses and can design data models that make sense for both. You should know when to use which technology, and why.
• Python: Proven expertise in Python. Familiarity with C# is beneficial, but not essential.
• SQL: You should be comfortable writing complex queries, tuning for performance, and working with both relational & analytical databases such as PostgreSQL or ClickHouse.
• Containers: You know your way around containerised environments and understand how to build, run, and deploy services both locally and in production.
• Cloud platforms: Experience with cloud ecosystems, particularly Azure, and a strong understanding of distributed systems will serve you well.

Nice to have

• Kubernetes & Helm: Experience deploying and managing containerised applications in production environments. Familiarity with scalability, fault tolerance, and parallel workloads in distributed clusters is highly valued.
• Kafka (Confluent): Exposure to event‑driven architectures, ideally with Kafka, is a strong plus. Knowledge of Flink or KSQL for stream processing is even better.
• Airflow: Experience setting up, configuring, maintaining, and optimising Airflow DAGs beyond simple usage will help you hit the ground running.
• Energy Industry Experience: A working understanding of the energy/commodity trading landscape or the unique data challenges in this space will make your contributions even more impactful.
• Trading Domain Knowledge: Familiarity with how traders think and operate, especially around real‑time decision making and data flows is a bonus.

About us

CFP Energy is an award‑winning energy trading and sustainability firm, accelerating the transition to a low‑carbon economy through innovative financial and energy solutions. We began by helping organisations make sense of carbon credit markets — optimising how emissions are priced, traded, and offset across global ecosystems. Today, our work spans across the full range of energy and sustainability solutions. From designing supply and hedging strategies, and securing renewable energy certificates, to sourcing and delivering biofuels, biogas, and transitional fuels.

We’re a progressive, forward‑thinking group at the forefront of environmental innovation. Our clients range from small businesses to major corporates, all seeking to reach net zero, manage energy risk, and secure reliable access to power and gas resources. Beyond our current ventures, we’re constantly exploring new business models and energy investment opportunities, because for us, it’s not just about keeping pace with change, but leading it.

Our Technology team is a cross‑functional mix of friendly, talented people. United by curiosity and a passion for data, we design the systems and pipelines that power smarter decisions across the business, turning complex energy data into meaningful insight that drives real‑world impact.

Seniority level: Mid‑Senior level

Employment type: Full‑time

Job function: Information Technology

Industries: Services for Renewable Energy