# Principal Data Engineer, Data Warehouse (TPL)

[Engelhart](https://gurify.com/jobs?q=Engelhart) · London, United Kingdom · Posted 2 days ago

Principal

[Data](https://gurify.com/jobs/data)

[Apply on the original posting → (opens in a new tab)](https://job-boards.greenhouse.io/engelhart/jobs/8352352)

## Job description

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

**Live in Engelhart’s hiring system.** Read from the company's own applicant tracking system, not reposted from a job board — so it's a real, open requisition rather than an ad that outlived the role.

We remove it as soon as it disappears at source.

## More jobs like this

- YL [Principal Data Engineer (Data Practice Lead)](https://gurify.com/job/principal-data-engineer-data-practice-lead-at-yld-296cb3850f72) Yld · London · 3 weeks ago
- YL [Principal Data Engineer (Data Practice Lead)](https://gurify.com/job/principal-data-engineer-data-practice-lead-at-yld-c3fec7e9ab4c) Yld · London · 3 weeks ago
- AR [Data Engineer](https://gurify.com/job/data-engineer-at-ariesglobal-c4b9a0b8a330) Ariesglobal · London · 4 days ago
- AC [Senior Data Engineer](https://gurify.com/job/senior-data-engineer-at-accurx-e409abbae8c9) Accurx · London (Shoreditch) · 3 days ago
- LA [Senior Data Engineer](https://gurify.com/job/senior-data-engineer-at-lawhive-275d1f2ab711) Lawhive · London · yesterday
- FU [Principal Data Engineer](https://gurify.com/job/principal-data-engineer-at-fundingcircle-f344226930b4) Fundingcircle · London · 4 weeks ago

```json
{"@context":"https://schema.org/","@type":"JobPosting","title":"Principal Data Engineer, Data Warehouse (TPL)","description":"\u003Ch3\u003EAbout Us\u003C/h3\u003E\u003Cp\u003EEngelhart was founded in 2013 by BTG Pactual Group as a commodities trading company. Our business model is \u201Casset light\u201D and highly diversified \u2013 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.\u003C/p\u003E\u003Cp\u003EIn 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\u2019 renewable power. The acquisition also expanded Engelhart\u2019s capabilities into physical natural gas across North America, a critical fuel to support the energy transition.\u003C/p\u003E\u003Cp\u003EOur talented and experienced individuals work together according to its four company values: Performance, Agility, Collaboration, Entrepreneurship.\u003C/p\u003E\u003Ch3\u003EAbout the Role\u003C/h3\u003E\u003Cp\u003EAs 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.\u003C/p\u003E\u003Cp\u003EThis will be a full-time role, based in our London office, owning the following responsibilities:\u003C/p\u003E\u003Cul\u003E\u003Cli\u003EOwn 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.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EDesign and maintain robust data schemas and serving contracts, including SQL, APIs and Kafka-based distribution.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EDefine data versioning and reproducibility patterns, including as-of timestamps and run IDs, snapshots and incremental updates, with appropriate treatment of position and P\u0026amp;L data.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EOwn the CTRM-to-warehouse data pipeline, ensuring reliable ingestion, transformation, validation and delivery to downstream consumers.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003ELead 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.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003ESet engineering standards for data modelling, schema evolution, data quality, observability, testing and operational support.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EBuild and operate solutions using relevant platform technologies, including ClickHouse, S3, Kafka and schema registry tooling.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EWork closely with stakeholder teams to understand their needs, propose solutions, explain trade-offs and establish clear, dependable data contracts.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EProvide technical leadership to the data engineering team, raising the quality of design and implementation while encouraging collaboration, constructive challenge and continuous improvement.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EHelp shape the longer-term data architecture and engineering approach as the business and its data requirements evolve.\u003C/li\u003E\u003C/ul\u003E\u003Ch3\u003EAbout You\u003C/h3\u003E\u003Cp\u003EYou 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.\u003C/p\u003E\u003Cp\u003EAs a result, we believe the following experiences and skills are essential for this role:\u003C/p\u003E\u003Cul\u003E\u003Cli\u003EDemonstrable experience designing and building data warehouses; this is a non-negotiable requirement.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EHands-on production experience with ClickHouse; this is a non-negotiable requirement.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EExperience delivering a columnar OLAP data platform in production, with a strong understanding of analytical query performance and data modelling.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EPractical experience with Kafka and event-driven or streaming data architectures.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EStrong Python engineering skills and sufficient C# literacy to work effectively with systems and codebases that use C#.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EExperience modelling versioned position and P\u0026amp;L data, including point-in-time or as-of views and reproducible runs.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EExperience working in a trading or other time-sensitive, data-intensive business environment.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EPrevious technical leadership, including setting standards and guiding engineering decisions.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EStrong stakeholder management and communication skills, with the confidence to put forward solutions, bring ideas into discussions and engage positively with challenge.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EA solution-oriented mindset and the ability to balance the needs of multiple downstream teams while maintaining coherent platform standards.\u003C/li\u003E\u003C/ul\u003E\u003Cp\u003EThe following experience is not required, but highly desirable for this role:\u003C/p\u003E\u003Cul\u003E\u003Cli\u003EExperience in commodities trading or energy markets.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EExposure to a Commodity Trading and Risk Management (CTRM) system, such as Orchestrade or Endur.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EFamiliarity with dbt and/or data quality frameworks.\u003C/li\u003E\u003C/ul\u003E\u003Ch3\u003EWhat we offer\u003C/h3\u003E\u003Cul\u003E\u003Cli\u003ECompetitive compensation and participation in Engelhart\u2019s discretionary bonus plan.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003E25 days of annual holiday entitlement, excluding UK public holidays.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003ERobust benefits package such as medical, dental, life insurance, generous pension contribution, and supplemental benefits partially subsidised by the Company.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EEligibility to receive external and internal training in accordance with our Training \u0026amp; Development Policy.\u003C/li\u003E\u003C/ul\u003E\u003Cp\u003EWe believe in inclusivity and are therefore dedicated to ensuring all employees \u2013 across gender identity, race, ethnicity, sexual orientation, religion, life experience, background and more \u2013 feel welcome and included in the company. We promote diversity because we believe it is essential to our ability to think holistically.\u003C/p\u003E","identifier":{"@type":"PropertyValue","name":"Gurify","value":"principal-data-engineer-data-warehouse-tpl-at-engelhart-c81b95268da1"},"url":"https://gurify.com/job/principal-data-engineer-data-warehouse-tpl-at-engelhart-c81b95268da1","datePosted":"2026-11-04","validThrough":"2026-12-21T23:59:59Z","hiringOrganization":{"@type":"Organization","name":"Engelhart","sameAs":"https://job-boards.greenhouse.io/engelhart"},"directApply":false,"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressCountry":"GB","addressLocality":"London"}}}
```

```json
{"@context":"https://schema.org/","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Jobs","item":"https://gurify.com/jobs"},{"@type":"ListItem","position":2,"name":"United Kingdom","item":"https://gurify.com/jobs/united-kingdom"},{"@type":"ListItem","position":3,"name":"Principal Data Engineer, Data Warehouse (TPL)","item":"https://gurify.com/job/principal-data-engineer-data-warehouse-tpl-at-engelhart-c81b95268da1"}]}
```