Data & BI Engineer – Commodity Markets Analytics, CTRM Platform

This is a fully remote position, open to applicants in United Arab Emirates (UAE).

📋 Description

• Take full responsibility for the data and BI layer of the CTRM platform from start to finish.

• Develop ingestion pipelines utilizing both internal systems and external market data providers, which includes scheduling, retries, backfilling, and handling vendor schema modifications.

• Create models for commodity data that encompass prices and curves, cargoes and flows, deals, positions, costs, units, calendars, pricing periods, and reference data.

• Design dashboards and reports for price analysis, spreads, cargo flows, and margins, including crack spread monitoring, cargo tracking, refinery margin analysis, and storage economics.

• Implement data quality measures, lineage tracking, and reconciliation processes, including freshness checks, price-series gap detection, duplicate cargo detection, and trusted-source reconciliation.

• Establish common definitions across trading, operations, and finance, and document repeatable calculations.

• Convert trader requests into functional analytics and iterate based on user feedback.

• Assess and suggest new data sources, tools, and integrations as the platform evolves.

• Collaborate directly with traders, operations staff, commercial personnel, the senior data scientist, and founders.

⛳️ Requirements

• A minimum of 4 years of experience as a Data Engineer, BI Developer, Analytics Engineer, or in a similar role, with responsibility for production pipelines and reporting.

• Proficiency in SQL.

• Experience with Python for building pipelines, automation, and analysis, including libraries such as pandas and SQLAlchemy or similar.

• Practical experience in data modeling, including dimensional modeling, star schemas, and dbt or equivalent tools.

• Hands-on experience with a BI tool like Power BI, Tableau, Metabase, or Superset, from requirements gathering to deployment of a relied-upon dashboard.

• Experience in commodity markets, preferably with crude oil and refined products; understanding of price assessments, forward curves, crack spreads, and cargo nominations.

• A strong and demonstrable interest in commodity markets may partially compensate for lack of experience; no exposure will not be acceptable.

• Experience working diligently with coding agents and maintaining strong verification practices, including row-count and freshness checks, reconciliation, and transformation tests.

• Ability to engage directly with traders and commercial staff, articulating data issues in familiar terms.

• Proficient in English to present work and justify design choices.

• Professional proficiency in Russian.

• Preferred: Experience with market data providers and APIs like Kpler, Platts, OPIS, Argus, or Bloomberg.

• Preferred: Familiarity with cloud data warehouses such as Snowflake, BigQuery, or Databricks.

• Preferred: Experience in workflow orchestration using tools like Airflow, Prefect, Dagster, or similar.

• Preferred: Background in an energy trading company, commodity house, or a data-intensive financial setting, including CTRM/ETRM exposure.

🏝️ Benefits

• Full ownership of the data and BI layer, with the opportunity to influence the architecture and tools used.

• Direct interaction with seasoned commodity traders, founders, and key decision-makers; quick feedback cycles.

• Access to leading market data platforms, including Kpler, Platts, and OPIS.

• Generous budget for AI tools — pioneering models are considered operational expenses, not perks.

• Competitive compensation, tailored to individual discussions.