Principal Data Engineer, Data Warehouse (TPL)

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 a…