Data Engineering Intern: Build Scalable Cloud Pipelines

Castleton Commodities International, LLC; Stamford (CT); On-site; USD 27,552 - 41,328; Part time

Job summary

Castleton Commodities International is hiring a Data Engineering Intern to join the Global Data Science & Technology team across Houston, Stamford, and New York City offices. You will build and optimize data pipelines powering analytics, forecasting, and investment decisions inside a hands-on, real-world data environment.

The role emphasizes ingesting, scraping, and managing large commodity datasets, with exposure to Python, SQL, and Snowflake, and collaboration with data science and commercial

Qualifications

• Pursuing a Bachelor’s or higher degree in CS, Engineering, MIS or related field.
• Expected graduation Winter 2027 or Spring/Summer 2028.
• Strong programming experience in Python (pandas, NumPy, SQLAlchemy).
• Strong understanding of SQL and relational databases (Snowflake a plus).
• Exposure to cloud platforms (AWS, Azure) for data storage/compute.
• Familiarity with web scraping frameworks and large-scale data sources.

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.

Skills

Python

SQL

Cloud platforms

Web scraping

Education

Bachelor's degree in Computer Science, Engineering, MIS or related field

Tools

pandas

NumPy

SQLAlchemy

Snowflake

Airflow

Job description

Castleton Commodities International is hiring a Data Engineering Intern to join the Global Data Science & Technology team across Houston, Stamford, and New York City offices. You will build and optimize data pipelines powering analytics, forecasting, and investment decisions inside a hands-on, real-world data environment.

The role emphasizes ingesting, scraping, and managing large commodity datasets, with exposure to Python, SQL, and Snowflake, and collaboration with data science and commercial