Principal Data Engineer (Data Warehouse)

Location: London, United Kingdom; full-time role based in the London office.

Company

hirify.global is a diversified commodities trading company using quantitative research, risk management, and proprietary technology to support energy trading and renewable-power optimisation.

What you will do

• Own the intraday and end-of-day data serving layer between the CTRM platform and Market Risk, Credit Risk, Treasury, Finance, Reporting, and desk-tool consumers.
• Design and maintain data schemas and serving contracts using SQL, APIs, Kafka, and schema registry tooling.
• Define versioning and reproducibility patterns for position and P&L data, including as-of timestamps, run IDs, snapshots, and incremental updates.
• Own the CTRM-to-warehouse pipeline covering ingestion, transformation, validation, and delivery.
• Turn the current data warehouse proof of concept into a production-ready platform using ClickHouse, S3, Kafka, and related technologies.
• Set engineering standards and provide technical leadership across modelling, schema evolution, quality, observability, testing, operational support, and stakeholder collaboration.

Requirements

• Demonstrable experience designing and building data warehouses is mandatory.
• Hands-on production experience with ClickHouse is mandatory.
• Experience delivering a columnar OLAP data platform in production, with strong analytical query performance and data-modelling knowledge.
• Practical experience with Kafka and event-driven or streaming data architectures.
• Strong Python engineering skills and sufficient C# literacy to work with C# systems and codebases.
• Experience modelling versioned position and P&L data, including point-in-time or as-of views and reproducible runs.
• Experience in a trading or other time-sensitive, data-intensive business environment.
• Previous technical leadership, including setting standards and guiding engineering decisions.
• Strong stakeholder management, communication, solution-oriented thinking, and the ability to balance multiple downstream teams while maintaining coherent platform standards.

Nice to have

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

Culture & Benefits

• Collaborative, inclusive culture based on Performance, Agility, Collaboration, and Entrepreneurship.
• Competitive compensation and participation in a discretionary bonus plan.
• 25 days of annual holiday entitlement excluding UK public holidays.
• Medical, dental, life insurance, pension contributions, and partially subsidised supplemental benefits.
• Access to internal and external training under the Training & Development Policy.