Data Engineer - Data Science & Technology

Job Summary
:
Castleton Commodities International (CCI) is redefining how data and technology shape the future of energy trading. The Data Engineer will be integral to the Data Science & Technology team, responsible for managing data ingestion processes, implementing new data management platforms, and ensuring data architecture is optimized for commercial investment teams.

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.

• 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 relational databases;
Snowflake highly preferred.

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.