Data Engineering Internship

Salary: £17,000 - 28,500 per year

Requirements:

• Currently pursuing a Bachelors or higher degree in Computer Science, Engineering, Management Information Systems, or a related technical field
• Expected graduation date of Winter 2027 or Spring/Summer 2028
• Strong programming experience in Python, with preferred libraries such as pandas, NumPy, and SQLAlchemy
• Strong understanding of SQL and experience querying relational databases, with Snowflake experience a plus
• Exposure to or interest in cloud platforms such as AWS or Azure, particularly cloud data storage and compute
• Familiarity with web scraping frameworks and handling large-scale structured and unstructured data sources

Responsibilities:

• Develop and maintain robust data ingestion pipelines from internal and external sources, including APIs, FTP endpoints, and cloud data providers
• Develop data ingestion and transformation pipelines using Python and SQL, publishing data to Snowflake for downstream use in analytics and forecasting tools
• Work on data architecture and data management projects for both new and existing data sources
• Design and implement ETL processes to clean, normalize, and store structured and semi-structured data in Snowflake, our core relational data warehouse
• Analyze data pipeline performance and implement optimizations to improve efficiency and reliability
• Conduct data quality checks and build validation logic to identify anomalies and ensure data integrity for commercial trading and analytics teams
• Automate data workflows using Python, SQL, and orchestration tools such as Airflow or similar
• Assist in transitioning legacy datasets and codebases into scalable, cloud-native workflows aligned with our modern data architecture
• Document data sources, pipeline logic, and data models to ensure maintainability and knowledge transfer

Technologies:

• Airflow
• AWS
• Azure
• Cloud
• Data Warehouse
• ETL
• Python
• SQL
• Snowflake
• Spring
• Web
• numpy
• pandas

More:

Castleton Commodities International is a leading global energy commodities merchant and infrastructure asset investor. We deploy capital on a proprietary basis in the physical and financial commodity markets, and as a strategic investor and developer, we leverage our market expertise, operations capabilities, and industry knowledge to invest in and develop select commodity infrastructure assets. Our strategically integrated platform has generated strong risk-adjusted returns for our investors since our formation. We are building a leading-edge data science platform and are seeking motivated and detail-oriented Data Engineering Interns to join our Global Data Science & Technology team in our London office. This is a hands-on technical internship focused on solving real-world data challenges across the commodity markets.

last updated 34 week of 2026