Job Summary:
Castleton Commodities International (CCI) is redefining how data and technology shape the future of energy trading. They are seeking a Data Engineer to ensure seamless ingestion and management of data across platforms, implementing new data management systems and creating data ingestion pipelines.
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.
Qualifications:
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.
• Experience in mapping, standardizing, and normalizing data.
• Experience with ETL/ELT frameworks to write pipelines to load millions/billions of records.
• Advanced skills in writing highly optimized SQL code.
• Experience with relational databases; Snowflake highly preferred.
• 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.
Company:
Castleton Commodities International is an independent global commodities merchant. Founded in 2001, the company is headquartered in Stamford, USA, with a team of 201-500 employees. The company is currently Growth Stage.