Data Engineer

Role:  
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:  

We understand that not everyone knows all the tools or technology, but there are a few key areas where we’ll rely on your expertise: 
 

• 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, as several of our services in other teams are built in it. 

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

While the skills above are essential, the following will help you stand out. 

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