Data & BI Engineer — Commodity Markets Analytics (CTRM Platform)
Role Overview
Own the data and BI layer of a developing CTRM platform, from data ingestion and modelling to trader, analyst, and management decision-support.
Combine third-party commodity-market intelligence with the company's trading and operations data across crude oil and refined products.
Work directly with traders, operations, commercial staff, a senior data scientist, and founders; make architecture and tooling decisions.
Key Skills for This Role
Full Job Posting
Role overview
Own the data and BI layer of a developing CTRM platform, from data ingestion and modelling to trader, analyst, and management decision-support.
Combine third-party commodity-market intelligence with the company's trading and operations data across crude oil and refined products.
Work directly with traders, operations, commercial staff, a senior data scientist, and founders; make architecture and tooling decisions.
Scope and responsibilities
- Build ingestion pipelines from internal systems and providers including Kpler, Platts/S&P Global, OPIS, Argus, and Bloomberg; handle scheduling, retries, backfills, and schema changes.
- Model prices, curves, cargoes, flows, deals, positions, and costs with consistent units, calendars, pricing periods, and reference data.
- Deliver dashboards and reports for price analysis, spreads, cargo flows, crack spreads, cargo tracking, refinery margins, and storage economics.
- Implement data quality, lineage, freshness checks, gap and duplicate detection, and reconciliation against trusted sources.
- Agree definitions across trading, operations, and finance; document calculations for reproducibility.
- Translate trader requirements into analytics, iterate with users, and evaluate new data sources, tools, and integrations.
Requirements
- 4+ years in data engineering, BI development, analytics engineering, or a comparable role, owning production pipelines and reporting.
- Strong SQL and Python for pipelines, automation, and analysis; pandas, SQLAlchemy, or similar are cited.
- Practical data modelling experience, including dimensional modelling, star schemas, dbt, or equivalent.
- Hands-on BI tool experience taking dashboards from requirements to delivery; examples include Power BI, Tableau, Metabase, and Superset.
- Commodity-markets exposure is required; crude oil and refined-products knowledge is ideal. Strong demonstrable interest can partly compensate, but zero exposure will not.
- Work seriously with coding agents and verify output using row-count and freshness checks, trusted-number reconciliation, and tests on important transformations.
- Comfortable working with traders and commercial staff and explaining data issues in their terms.
- English sufficient to present work and defend design decisions; professional Russian proficiency.
Advantageous experience
- Market-data provider and API experience; cloud warehouses such as Snowflake, BigQuery, or Databricks; orchestration such as Airflow, Prefect, or Dagster.
- Experience in an energy trading company, commodity house, or data-heavy financial environment, including CTRM/ETRM exposure.
What the employer offers
- Ownership of the data and BI layer and room to shape architecture and tooling.
- Direct access to experienced commodity traders, founders, and decision-makers, with short feedback loops.
- Licences and access to market-data platforms including Kpler, Platts, and OPIS; an AI tooling budget.
- Competitive compensation discussed individually.
Application
- Applicants should submit a CV and answer one of the listed questions; applications without an answer are not reviewed.
About Raw Ventures
Investing in and supporting early-stage technology startups.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Raw Ventures
Data Analyst — Energy Retail (Oil & Gas)
London, GBR
Raw Ventures is seeking a hands-on analyst to own customer and commercial analysis for a pay-as-you-go LPG business. You’ll work from raw transactional and operational data to explain customer behaviour, pricing, unit ec
Executive & Project Assistant to the Head of Talent
London, GBR
Data & BI Engineer — Commodity Markets Analytics (CTRM Platform)
Dubai, UAE
Data Analyst — Energy Retail (Oil & Gas)
London, GBR
QA Engineer — CTRM Platform
Dubai, UAE
Senior Data Scientist — Energy (Oil & Gas)
Dubai, UAE
Executive & Project Assistant to the Head of Talent
London, GBR
QA Engineer — CTRM Platform
Dubai, UAE
Data & BI Engineer — Commodity Markets Analytics (CTRM Platform)
Dubai, UAE
Data Analyst — Energy Retail (Oil & Gas)
London, GBR
