Teams at Castleton Commodities International

Two-year rotational leadership program based in Houston offering four six-month rotations across operations and finance (settlements, trading operations, treasury, credit, tax, enterprise improvement, product control) with training, special projects, and potential conversion to a full-time role.

Design, build, and maintain end-to-end data ingestion pipelines and data architecture. Transition datasets to a new stack, map/standardize/normalize data, monitor data quality, manage vendor data inputs, and partner with commercial trading teams to gather requirements and support analytics and investing use cases.

Support building and optimizing data ingestion, ETL, and transformation pipelines using Python and SQL. Work with Snowflake and cloud platforms to store and validate structured and semi-structured data, automate workflows (Airflow), conduct data quality checks, and document pipeline architecture for use by trading and analytics teams.