Castleton Commodities International · 2 hours ago
Data Engineer
Houston, TX
Full-time
Onsite
Mid, Senior Level
3+ years expCastleton Commodities International is a global leader in energy commodity trading and asset investment. The Data Engineer role involves executing data architecture and management projects, transitioning data sets to a new technology stack, and managing the end-to-end data ingestion process to support commercial decision-making.
Oil and Gas
Responsibilities
Execute data architecture and data management projects for both new and existing data sources
Help transition existing data sets, databases, and code to a new technology stack
Manage end to end data ingestion process and publishing to investing teams
Own the process of mapping, standardizing, and normalizing data
Ad hoc research on project topics such as vendor trends, usage best practices, big data trends, artificial intelligence, vendors, etc
Help transition existing data sets, databases, and code to a new technology stack
Assess data loads for tactical errors and build out appropriate workflows, as well as create data quality analysis that identifies larger issues in data
Actively manage vendors and capture changes in data input proactively
Properly prioritize and resolve data issues based on business usage
Assist with managing strategic initiatives around big data projects for the commercial (trading) business
Partner with commercial teams to gain understanding of current data flow, data architecture, investment process as well as gather functional requirements
Assess gaps in current datasets and remediate
Qualification
Required
Bachelor's degree in Computer Science, Mathematics, Physics, Business Intelligence, or related field of study
3+ years of Data Engineering experience specializing in SQL programming, data architecture, and dimension modeling
Prior experience as a Technical Lead, managing a team of Data Engineers, overseeing project execution and ensuring the delivery of high-quality data solutions
Experience in mapping, standardizing, and normalizing data
Extensive work experience with ETL/ELT frameworks to write pipelines to load millions/billions of records
Advanced skills in writing highly optimized SQL code
Hands-on experience developing data solutions in Python, Pandas, Numpy, etc
Ability to communicate and interact with a wide range of data users – from very technical to non-technical
Team player who is execution focused, with the ability to handle a rapidly changing set of projects and priorities, while maintaining strong professional presence
Ability to work effectively in a fast-paced, dynamic and high-intensity environment including an open-floor plan, with timely responsiveness and the ability to work beyond normal business hours when required
Preferred
Experience in energy commodities or financial services is nice to have but not required
Experience with data integration platforms is preferred, and SnapLogic experience is highly preferred
Experience with relational databases Snowflake or Oracle is preferred
Experience with PowerBI visualization tools
Benefits
Competitive comprehensive medical, dental, retirement and life insurance benefits
Employee assistance & wellness programs
Parental and family leave policies
CCI in the Community: Each office has a Charity Committee and as a part of this program employees are allocated 2 days annually to volunteer at the selected charities.
Charitable contribution match program
Tuition assistance & reimbursement
Quarterly Innovation & Collaboration Awards
Employee discount program, including access to fitness facilities
Competitive paid time off
Continued learning opportunities
Company
Castleton Commodities International
Castleton Commodities International is an independent global commodities merchant.
201-500 employees
H1B Sponsorship
Castleton Commodities International has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (14)
2024 (9)
2023 (6)
2022 (11)
2021 (17)
2020 (11)
Funding
Current Stage
Growth StageTotal Funding
$4.18B2025-11-18Debt Financing· $2.11B
2023-11-15Debt Financing· $2.08B
Leadership Team
Lauren Haymond
Managing Director, Global Head of Talent Strateg
Recent News
2025-04-03
Company data provided by crunchbase