Principal Data Engineer, Data Warehouse (TPL)

Engelhart, a diversified commodities trading company founded in 2013 by BTG Pactual Group, is seeking a Principal Data Engineer to lead the development and maintenance of their data serving layer between the Commodity Trading and Risk Management (CTRM) platform and its downstream consumers. This role is based in London and offers the opportunity to influence the company's data architecture and engineering practices.

The Principal Data Engineer will be responsible for designing and maintaining robust data schemas and serving contracts, including SQL, APIs, and Kafka-based distribution. They will define data versioning and reproducibility patterns, manage the CTRM-to-warehouse data pipeline, and lead the implementation of the data warehouse serving layer. Additionally, the role involves setting engineering standards for data modeling, schema evolution, data quality, observability, testing, and operational support.

Candidates should have demonstrable experience designing and building data warehouses, with hands-on production experience using ClickHouse. A strong understanding of analytical query performance and data modeling is essential, along with practical experience with Kafka and event-driven or streaming data architectures. Proficiency in Python and sufficient C# literacy to work effectively with systems and codebases that use C# are required. Experience modeling versioned position and P&L data, including point-in-time or as-of views and reproducible runs, is also necessary.

While specific compensation details are not listed, Engelhart offers a competitive salary and benefits package, including participation in the discretionary bonus plan, 25 days of annual holiday entitlement, medical, dental, and life insurance, generous pension contributions, and supplemental benefits partially subsidized by the company.

Engelhart fosters a collaborative culture across products and competencies, emphasizing performance, agility, collaboration, and entrepreneurship. The acquisition of Trailstone in 2024 has expanded the company's capabilities into physical natural gas across North America, supporting the energy transition. This role provides an opportunity to shape the future data architecture of the business and work with a diverse team of professionals.