At a Glance
- Tasks: Build and optimise data pipelines for analytics and investment decisions.
- Company: Join Castleton Commodities International, a leader in energy commodities.
- Benefits: Gain hands-on experience in a dynamic environment with potential career growth.
- Other info: Work in a collaborative team and learn from industry experts.
- 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.
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 in 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, SQLAlchemy, 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) in London employer: Castleton Commodities International, LLC
Castleton Commodities International (CCI) is an exceptional employer that fosters a collaborative and innovative work culture, particularly for the Senior ETRM Application Developer role. With a strong focus on employee growth, CCI offers comprehensive benefits including competitive medical and retirement plans, tuition assistance, and wellness programs, all while providing opportunities to work on cutting-edge technology in a dynamic trading environment. Located in a vibrant area, employees enjoy a supportive atmosphere that encourages professional development and community engagement through volunteer initiatives.
Contact Details:
Castleton Commodities International, LLC Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineering Internship (Summer 2027) in London
✨Join Data-Science Meetups
Get yourself along to local data-science meetups or workshops. They're goldmines for networking, and you'll learn from industry pros who might just point you in the direction of internships. Plus, discussing the latest trends with like-minded individuals can really amp up your game.
✨Utilise University Career Services
Check in with your uni's career services since they often have connections with companies looking for interns. They might even organise information sessions with firms, which can be a great chance for you to learn more about potential internships and make some key contacts.
✨Show Off Your Stuff on GitHub
If you're into data science, having a GitHub profile with your projects is essential. Make sure your portfolio is public and showcases your best work! Recruiters love to see your coding skills and problem-solving approach, and it’s a brilliant way to stand out.
✨Apply Directly on Our Website
Don’t forget to check out the internships listed on our site! It's always a good idea to apply directly through our website because it makes your application easier for our team to find, and you might just catch the hiring manager’s eye by showcasing exactly what you're passionate about in data science.
We think you need these skills to ace Data Engineering Internship (Summer 2027) in London
Some tips for your application 🫡
Show Off Your Technical Skills:For a data science internship, we want to see those analytical skills shine! List your programming languages, like Python or R, and make sure to highlight any relevant projects or courses you've completed. If you've dabbled with tools like Pandas, NumPy, or machine learning algorithms, don’t hold back – include those in your CV!
Share Your Curiosity in Your Cover Letter:As an intern, your motivation and eagerness to learn are key! In your cover letter, talk about specific data science concepts that excite you and how this internship at Castleton Commodities International, LLC will help you grow. Share what you hope to achieve and how you plan to tackle real-world data problems - we love enthusiasm!
Include Any Relevant Certifications:If you've earned any certifications, such as from Coursera or DataCamp, make sure to include these in your application. They show us that you're proactive and committed to expanding your data science skillset. This could make a real difference in how we assess your application!
Keep It Relevant and Concise:Remember, as an intern, you don’t need to have decades of experience. Focus on showcasing relevant coursework, personal projects, or even related volunteer work in data science. Keep your CV and cover letter concise but impactful – we appreciate clear and straightforward communication!
How to prepare for a job interview at Castleton Commodities International, LLC
✨Brush Up on Your Coding Skills
As a data science intern, you might get grilled on your programming skills. Expect to tackle some coding challenges using languages like Python or R. We recommend practising basic algorithms or data manipulation tasks so you can show off your tech skills with confidence.
✨Show Off Your Projects
Prepare to discuss any projects you’ve done, whether in your studies or on your own time. Having a strong portfolio of data analyses or machine learning models will really set you apart. We can use platforms like GitHub to showcase your work to impress Castleton Commodities International, LLC.
✨Know Your Stats and ML Basics
Brush up on your statistics and machine learning concepts because interviewers love to dig into this! Be ready to explain your understanding of algorithms or how you would approach a given data problem. This will highlight your theoretical background alongside your practical skills.
✨Be Eager to Learn and Adapt
Internships are all about potential and growth. Make sure you convey your eagerness to learn and adapt to new tools or methodologies. Show Castleton Commodities International, LLC that you’re not just looking for experience, but that you're keen to contribute and grow within the team.
