Data Engineer - Commodities

Millennium; Greater London; On-site; GBP 70,000 - 110,000; Full time

Job summary

Millennium is seeking a data engineer to design and maintain end-to-end ETL pipelines for commodities data, using Python and SQL. You will build scalable data models, ensure data quality, and collaborate with portfolio managers and researchers to refine datasets according to evolving business needs.

The role emphasizes automated testing, Git-based deployments, and orchestration with Airflow, with a focus on accuracy, lineage, and documentation.

Qualifications

• 5+ years of experience in data engineering or analytics engineering building and maintaining ETL pipelines.
• Strong Python and SQL skills with large datasets and complex transformations.
• Hands-on experience with Airflow or comparable workflow orchestration tools.

Responsibilities

• Design, implement, and maintain end-to-end ETL workflows in Python and SQL for commodities data.
• Build and maintain standardized data models, schemas, and metadata.
• Schedule, monitor, and manage data pipelines using Airflow to ensure timely delivery.

Skills

Python

SQL

Airflow

Git

CI/CD

Tools

GitHub Actions

Job description

About Millennium

Millennium is a global, diversified alternative investment firm, founded in 1989. Defined by evolution, innovation and focus, Millennium’s mission is to deliver results for our investors.

Our people are empowered with both independence and support: the autonomy to pursue ideas with conviction and the backing of a global network committed to collaboration, disciplined risk management and continuous learning. With opportunities to deepen expertise and accelerate development, talent at Millennium is equipped to adapt, evolve and build lasting impact over time. Discover how transformative growth accelerates impact.

Meet the Team

The Commodities Technology team builds and operates a data platform that aggregates and curates critical commodities data, including weather, supply and demand, storage, transportation, and other fundamental and alternative datasets. The team’s curated content layer supports Portfolio Managers and researchers in understanding markets and constructing trades. As part of Millennium’s Information Technology organization, the team develops flexible, scalable technology and proprietary systems that support advanced analytical and trading capabilities.

What You'll Do

• Design, implement, and maintain end-to-end ETL workflows in Python and SQL to ingest and transform commodities data from multiple vendor and internal sources.
• Build and maintain standardized data models, schemas, and metadata that make commodities datasets easy to understand, discover, and reuse.
• Schedule, monitor, and manage data pipelines using Airflow or similar workflow orchestration tools to ensure reliable, timely data delivery.
• Implement validation, reconciliation, and anomaly-detection controls to maintain data completeness, accuracy, and consistency.
• Apply AI to automate schema inference across structured and semi-structured data sources, manage schema drift, and accelerate scalable ingestion development.
• Use AI-driven data-quality, observability, and documentation capabilities to detect anomalies, monitor data health, and produce clear lineage and technical documentation.
• Maintain high-quality, production-ready code and repeatable deployments through Git, GitHub Actions, PyTest, and automated testing practices.
• Partner with commodities Portfolio Managers, researchers, data analysts, and data strategists to refine datasets, definitions, and documentation based on evolving business needs.

What You Bring

• 5+ years of experience in data engineering, analytics engineering, or a similar role building and maintaining ETL pipelines.
• Strong Python and SQL skills, including experience working with large datasets and complex data transformations.
• Hands-on experience with Airflow or comparable workflow orchestration tools.
• Experience with Git, CI/CD pipelines such as GitHub Actions, and automated testing frameworks such as PyTest.
• Strong attention to detail, data quality, and documentation, with the ability to identify edge cases and protect data integrity.
• Ability to work independently, communicate effectively with technical and non-technical stakeholders, and manage multiple concurrent initiatives.
• Knowledge of commodities markets and data, including weather, supply and demand, storage, freight, or flows, is preferred.
• Experience with data warehousing, columnar storage formats, analytic databases, data catalog or governance tools, or financial services, trading, or research-driven environments is preferred.