At a Glance
- Tasks: Build and optimise data pipelines for analytics and investment decisions.
- Company: Join Castleton Commodities International, a leader in global energy commodities.
- Benefits: Gain hands-on experience, mentorship, and exposure to cutting-edge data technologies.
- Other info: Dynamic internship with opportunities for growth and learning in a collaborative environment.
- Why this job: Tackle real-world data challenges and make an impact in the energy sector.
- Qualifications: Pursuing a degree in Computer Science or related field; strong Python and SQL skills required.
The predicted salary is between 63000 - 77000 £ per year.
- Application Deadline: September 1st, 11:59m EST
- Program Summary - Data Science & Technology Internship
Company Overview
Castleton Commodities International is a leading global energy commodities merchant and infrastructure asset investor.
As a trader, CCI deploys capital on a proprietary basis in the physical and financial commodity markets, providing the Company with market insights and access.
As a strategic investor and developer, CCI leverages its 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.
Position Overview
CCI is developing a leading-edge Data Science platform, as staying at the forefront of data management and analytics is essential to our investment strategy.
We are looking for motivated and detail-oriented Data Engineering Interns to join our Global Data Science & Technology team in our London office.
The Data Engineering Intern will work closely with our Data Science, Data Engineering and Commercial teams to build and optimize data pipelines that power our analytics, forecasting, and investment decision-making processes.
This is a hands-on technical internship ideal for someone who enjoys solving real-world data challenges, especially around ingesting, scraping, and managing large datasets across the commodity markets.
Responsibilities
- Develop and maintain robust data ingestion pipelines from various internal and external sources, including APIs, FTP endpoints, and cloud data providers.
- Develop data ingestion and transformation pipelines using Python and SQL, publishing 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 use by commercial trading and analytics teams.
- Automate data workflows using Python, SQL, and orchestration tools (e. g., 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.
Qualifications
- Currently pursuing a Bachelor’s or higher degree in Computer Science, Engineering, Management Information Systems, or related technical field.
- Expected graduation date of Winter 2027 or Spring/Summer 2028.
- Strong programming experience in Python (preferred libraries: pandas, Num Py, SQL alchemy, etc.).
- Strong understanding of SQL and experience querying relational databases (Snowflake a plus).
- Exposure to or interest in cloud platforms (e. g., AWS, Azure), particularly with cloud data storage and compute.
- Familiarity with web scraping frameworks and handling large-scale structured and unstructured data sources.
- #J-18808-Ljbffr
Data Engineering Internship (Summer 2027) employer: Castleton Commodities International
As a Contract Negotiator at our company, you will thrive in a dynamic work environment that values collaboration and innovation within the energy sector. We offer competitive benefits, a supportive culture that encourages professional growth, and opportunities to engage with industry-leading experts. Located in a vibrant area, our workplace fosters a sense of community and commitment to excellence, making it an ideal place for those seeking meaningful and rewarding employment.
Contact Details:
Castleton Commodities International Recruitment Team
