{bc}
linkedin

Data & BI Engineer — Commodity Markets Analytics (CTRM Platform)

Raw Ventures
Dubai, UAE
Full-time
Mid-Senior
Onsite
Discovered 4 days ago
SQLPythonData modellingDimensional modelling / star schemasBI dashboard developmentCommodity markets

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.

Apply 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.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Raw Ventures