Back to jobs

Principal Data Engineer, Data Warehouse (TPL)

London, United Kingdom

Live, first seen by us 8 days ago
Pay
Pay not listed
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting

As Principal Data Engineer, you will own the intraday and end-of-day data serving layer between the CTRM platform and its downstream consumers.

This will be a full-time role, based in our London office, owning the following responsibilities:

  • Own the CTRM-to-warehouse pipeline for ingestion, validation and delivery

  • Take the ClickHouse warehouse from proof of concept to production

  • Design data schemas and serving contracts across SQL, APIs and Kafka

  • Set engineering standards for modelling, data quality, testing and observability

  • Lead the data engineering team's design and implementation quality

From the employer’s posting
As Principal Data Engineer, you will own the intraday and end-of-day data serving layer between the CTRM platform and its downstream consumers. You will shape the architecture, standards and engineering practices that enable teams across the business to access trusted, timely and well-defined data. This is a hands-on technical leadership role with the opportunity to influence how the business builds and uses its data platform.
This will be a full-time role, based in our London office, owning the following responsibilities:
Own the CTRM-to-warehouse data pipeline, ensuring reliable ingestion, transformation, validation and delivery to downstream consumers.
Lead the implementation and production use of the data warehouse serving layer, closing out the current proof of concept and turning it into a production-ready platform.
Design and maintain robust data schemas and serving contracts, including SQL, APIs and Kafka-based distribution.
Set engineering standards for data modelling, schema evolution, data quality, observability, testing and operational support.
Provide technical leadership to the data engineering team, raising the quality of design and implementation

What you’ll bring

All qualifications

Core experience

  • Experience delivering a columnar OLAP data platform in production, with a strong understanding of analytical query performance and data modelling.
  • Practical experience with Kafka and event-driven or streaming data architectures.
  • Strong Python engineering skills and sufficient C# literacy to work effectively with systems and codebases that use C#.
  • Experience modelling versioned position and P&L data, including point-in-time or as-of views and reproducible runs.
  • Experience working in a trading or other time-sensitive, data-intensive business environment.
  • Experience in commodities trading or energy markets.
Qualification wording
Experience delivering a columnar OLAP data platform in production, with a strong understanding of analytical query performance and data modelling.
Practical experience with Kafka and event-driven or streaming data architectures.
Strong Python engineering skills and sufficient C# literacy to work effectively with systems and codebases that use C#.
Experience modelling versioned position and P&L data, including point-in-time or as-of views and reproducible runs.
Experience working in a trading or other time-sensitive, data-intensive business environment.
Experience in commodities trading or energy markets.

Benefits in the posting

Full benefits wording
  • Competitive compensation and participation in Engelhart’s discretionary bonus plan.
  • 25 days of annual holiday entitlement, excluding UK public holidays.
  • Robust benefits package such as medical, dental, life insurance, generous pension contribution, and supplemental benefits partially subsidised by the Company.
  • Eligibility to receive external and internal training in accordance with our Training & Development Policy.

From the employer’s posting.

About Engelhart

Engelhart was founded in 2013 by BTG Pactual Group as a commodities trading company.

In the employer’s words · Read in context

Apply at Engelhart

Posting record

Report an error
Status in our records
Live
First seen by us
Nov 11, 20268 days ago
Recorded sightings
9
Last seen by us
Nov 19, 2026
Reposted
once since Nov 4, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications. We count a repost when the same title and location comes back as a new listing within 60 days of the last one coming down. Some hiring systems expire listings on a schedule, so repost rates vary by system.

How this job compares

Time since we first saw it

Day 8

Similar jobs usually come down between day 6 and day 56.

At Engelhart, jobs usually come down by about day 8.

From 14,166 similar postings that came down, and 11 of Engelhart’s. Coming down is not always a hire.

Engelhart is hiring

2 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Data Engineer hiring is picking up
  • Takes jobs down quickly
  • 50% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • C#
  • Python
  • SQL
  • ClickHouse
  • dbt
  • Kafka
  • S3
Where the posting names them
- Practical experience with Kafka and event-driven or streaming data architectures. - Strong Python engineering skills and sufficient C# literacy to work effectively with systems and codebases that use C#. - Experience modelling versioned position and P&L data, including point-in-time or as-of views and reproducible runs.
- Own the intraday and EOD data serving layer between the CTRM platform and its consumers, including Market Risk, Credit Risk, Treasury, Finance, Reporting and desk tools. - Design and maintain robust data schemas and serving contracts, including SQL, APIs and Kafka-based distribution. - Define data versioning and reproducibility patterns, including as-of timestamps and run IDs, snapshots and incremental updates, with appropriate treatment of position and P&L data.
- Set engineering standards for data modelling, schema evolution, data quality, observability, testing and operational support. - Build and operate solutions using relevant platform technologies, including ClickHouse, S3, Kafka and schema registry tooling. - Work closely with stakeholder teams to understand their needs, propose solutions, explain trade-offs and establish clear, dependable data contracts.
- Demonstrable experience designing and building data warehouses; this is a non-negotiable requirement. - Hands-on production experience with ClickHouse; this is a non-negotiable requirement. - Experience delivering a columnar OLAP data platform in production, with a strong understanding of analytical query performance and data modelling.
- Exposure to a Commodity Trading and Risk Management (CTRM) system, such as Orchestrade or Endur. - Familiarity with dbt and/or data quality frameworks. What we offer
- Experience delivering a columnar OLAP data platform in production, with a strong understanding of analytical query performance and data modelling. - Practical experience with Kafka and event-driven or streaming data architectures. - Strong Python engineering skills and sufficient C# literacy to work effectively with systems and codebases that use C#.

Your next step

Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.

Applying through Greenhouse

  • No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
  • Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.

Already applied? Track this application

Job description

View original posting ↗

About Us

Engelhart was founded in 2013 by BTG Pactual Group as a commodities trading company. Our business model is “asset light” and highly diversified – giving us the ability to adapt effectively and nimbly to changing market conditions. We have assembled successful multidisciplinary teams, leveraging advanced fundamental analysis with deep quantitative and weather research capabilities.  Our activities are underpinned by strong risk management practices and by powerful technology and operational excellence. We have exceptional teams with diverse global backgrounds and decades of experience, and are driven by a highly collaborative culture, across products and competencies.

In 2024, Engelhart acquired Trailstone, a global energy trading and technology company. The acquisition provides us with new expertise, analytics and proprietary technology which is being used to provide risk management and optimisation services to help maximise the value of our clients’ renewable power. The acquisition also expanded Engelhart’s capabilities into physical natural gas across North America, a critical fuel to support the energy transition.

Our talented and experienced individuals work together according to its four company values: Performance, Agility, Collaboration, Entrepreneurship.

About the Role 

As Principal Data Engineer, you will own the intraday and end-of-day data serving layer between the CTRM platform and its downstream consumers. You will shape the architecture, standards and engineering practices that enable teams across the business to access trusted, timely and well-defined data. This is a hands-on technical leadership role with the opportunity to influence how the business builds and uses its data platform. 

This will be a full-time role, based in our London office, owning the following responsibilities: 

  • Own the intraday and EOD data serving layer between the CTRM platform and its consumers, including Market Risk, Credit Risk, Treasury, Finance, Reporting and desk tools. 
  • Design and maintain robust data schemas and serving contracts, including SQL, APIs and Kafka-based distribution. 
  • Define data versioning and reproducibility patterns, including as-of timestamps and run IDs, snapshots and incremental updates, with appropriate treatment of position and P&L data. 
  • Own the CTRM-to-warehouse data pipeline, ensuring reliable ingestion, transformation, validation and delivery to downstream consumers. 
  • Lead the implementation and production use of the data warehouse serving layer, closing out the current proof of concept and turning it into a production-ready platform. 
  • Set engineering standards for data modelling, schema evolution, data quality, observability, testing and operational support. 
  • Build and operate solutions using relevant platform technologies, including ClickHouse, S3, Kafka and schema registry tooling. 
  • Work closely with stakeholder teams to understand their needs, propose solutions, explain trade-offs and establish clear, dependable data contracts. 
  • Provide technical leadership to the data engineering team, raising the quality of design and implementation while encouraging collaboration, constructive challenge and continuous improvement. 
  • Help shape the longer-term data architecture and engineering approach as the business and its data requirements evolve.

 

About You 

You will be a technically strong and proactive data engineering leader who can turn complex business requirements into robust, scalable data products. You are comfortable supporting multiple teams, bringing forward clear recommendations and new ideas, and engaging constructively when your designs are challenged. You want to help shape the future data architecture of the business, not simply deliver against a predefined specification. 

As a result, we believe the following experiences and skills are essential for this role: 

  • Demonstrable experience designing and building data warehouses; this is a non-negotiable requirement. 
  • Hands-on production experience with ClickHouse; this is a non-negotiable requirement. 
  • Experience delivering a columnar OLAP data platform in production, with a strong understanding of analytical query performance and data modelling. 
  • Practical experience with Kafka and event-driven or streaming data architectures. 
  • Strong Python engineering skills and sufficient C# literacy to work effectively with systems and codebases that use C#. 
  • Experience modelling versioned position and P&L data, including point-in-time or as-of views and reproducible runs. 
  • Experience working in a trading or other time-sensitive, data-intensive business environment. 
  • Previous technical leadership, including setting standards and guiding engineering decisions. 
  • Strong stakeholder management and communication skills, with the confidence to put forward solutions, bring ideas into discussions and engage positively with challenge. 
  • A solution-oriented mindset and the ability to balance the needs of multiple downstream teams while maintaining coherent platform standards. 

The following experience is not required, but highly desirable for this role: 

  • Experience in commodities trading or energy markets. 
  • Exposure to a Commodity Trading and Risk Management (CTRM) system, such as Orchestrade or Endur. 
  • Familiarity with dbt and/or data quality frameworks. 

 

What we offer 

  • Competitive compensation and participation in Engelhart’s discretionary bonus plan.  
  • 25 days of annual holiday entitlement, excluding UK public holidays. 
  • Robust benefits package such as medical, dental, life insurance, generous pension contribution, and supplemental benefits partially subsidised by the Company.   
  • Eligibility to receive external and internal training in accordance with our Training & Development Policy. 

We believe in inclusivity and are therefore dedicated to ensuring all employees – across gender identity, race, ethnicity, sexual orientation, religion, life experience, background and more – feel welcome and included in the company. We promote diversity because we believe it is essential to our ability to think holistically.

 

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 14% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 860, the most 1,353, and the latest week had 1,020.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

London, United Kingdom

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.