описание
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.
задачи
- 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.
требования
- 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.
- Будет плюсом: 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
условия
- 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.