Data Engineer - Data Science & Technology

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.
• Assess data loads for tactical errors and build out appropriate workflows, as well as create data quality analysis that identifies larger issues in data.
• Proactively manage vendors and capture changes in data input.
• 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

• 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 energy commodities or financial services is nice to have but not required.
• 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.

Employee Programs & Benefits

• Competitive comprehensive medical, dental, retirement and life insurance benefits.
• Employee assistance & wellness programs.
• Parental and family leave policies.
• Credit for community service.
• Tuition assistance & reimbursement.
• Quarterly Innovation & Collaboration Awards.
• Employee discount program, including access to fitness facilities.
• Competitive paid time off.
• Continued learning opportunities.

Career at CCI

Visit https://www.cci.com/careers/life-at-cci/ to learn more!