Data Engineer – Data Science & Technology

Salary: £34,000 - 57,000 per year

Requirements:

• Bachelors degree in Computer Science, Mathematics, Physics, Business Intelligence, or a related field of study.
• 3+ years of data engineering experience specializing in SQL programming, data architecture, and dimension modeling.
• Experience in mapping, standardizing, and normalizing data.
• Experience with ETL/ELT frameworks to write pipelines that load millions or billions of records.
• Advanced skills in writing highly optimized SQL code.
• Experience with relational databases; Snowflake is highly preferred.
• Hands-on experience developing data solutions in Python, Pandas, Numpy, and similar tools.
• Ability to communicate and interact with a wide range of data users, from very technical to non-technical.
• Team player who is execution focused, able to handle rapidly changing projects and priorities while maintaining a strong professional presence.
• Ability to work effectively in a fast-paced, dynamic, high-intensity environment, including an open-floor plan, with timely responsiveness and the ability to work beyond normal business hours when required.

Responsibilities:

• Execute data architecture and data management projects for both new and existing data sources.
• Help transition existing data sets, databases, and code to a new technology stack.
• Manage the end-to-end data ingestion process and publishing to investing teams.
• Own the process of mapping, standardizing, and normalizing data.
• Conduct ad hoc research on topics such as vendor trends, usage best practices, big data trends, artificial intelligence, and vendors.
• Assess data loads for tactical errors, build appropriate workflows, and create data quality analysis to identify larger issues in data.
• Actively manage vendors and proactively capture changes in data input.
• Prioritize and resolve data issues based on business usage.
• Assist with managing strategic initiatives around big data projects for the commercial trading business.
• Partner with commercial teams to understand current data flow, data architecture, and investment processes, and to gather functional requirements.
• Assess gaps in current datasets and remediate them.

Technologies:

• Big Data
• Business Intelligence
• Cloud
• ETL
• Flow
• Machine Learning
• Python
• SQL
• Snowflake
• numpy
• pandas
• Support

More:

We are Castleton Commodities International (CCI), and our Data Science & Technology team is redefining how data and technology shape the future of energy trading. We develop systems and innovative tools that help our front-office teams better understand market dynamics, forecast prices, and manage risk. Our modern, open-source technology stack spans cloud-native infrastructure, machine learning platforms, real-time analytics, and proprietary libraries and APIs, enabling us to solve complex, high-impact challenges at scale. This role sits within our Data Engineering team and offers direct exposure to our commercial investment teams globally, with the opportunity to see how cutting-edge technology drives strategy and performance in energy markets. We also offer competitive benefits and programs, including comprehensive medical, dental, retirement and life insurance, employee assistance and wellness programs, parental and family leave, charity and volunteer opportunities, charitable contribution matching, tuition assistance and reimbursement, innovation and collaboration awards, an employee discount program with fitness facility access, competitive paid time off, and continued learning opportunities. The role is based in London, UK and is full time.

last updated 36 week of 2026