The ideal candidate is a technical expert with a passion for building scalable, high-quality data solutions. You will own the design and implementation of data models in our modern data stack (Redshift, dbt Cloud, Atlan, Monte Carlo) and act as the technical authority for the team, guiding and managing another Data Engineer to ensure technical excellence and successful project delivery.
Responsibilities:
- Design, develop, and maintain a scalable and performant analytical data layer within AWS Redshift.
- Lead the development of robust, well-tested, and documented data models using dbt Cloud, setting the standard for best practices in data engineering and code quality.
- Act as the senior technical expert for enterprise finance data. Mentor a Data Engineer through expert guidance, collaborative problem-solving, and rigorous code reviews to ensure high-quality output and foster their technical growth.
- Partner closely with the head of Finance Data and Analytics to translate complex business requirements into reliable, high-impact data products.
- Take ownership of the data platform's stability and governance. Ensure new data products are fully documented and tested for quality in the data pipeline models.
- Stay current with modern data engineering trends and continuously identify opportunities to improve our platform, processes, and technical standards.
Qualifications:
8+ years of progressive, hands-on data engineering experience, delivering scalable data solutions in production environments.
Expert-level proficiency in SQL and data modeling, with a strong ability to design and optimize complex data structures.
Extensive, practical experience with dbt (Cloud or Core)—this is a core requirement for the role.
Deep experience working with modern cloud data warehouse technologies, such as Amazon Redshift or Snowflake.
Industry experience in financial services, energy, or commodity trading is strongly preferred.
Familiarity with data governance platforms (e.g., Atlan) and data observability tools (e.g., Monte Carlo).
Experience working within Agile/Scrum development frameworks.
Proven leadership in driving complex data initiatives, including managing and mentoring small engineering teams.
Exceptional communication and collaboration skills, with a track record of elevating team technical capabilities.
Demonstrated success partnering across technical and business teams to deliver data solutions aligned with organizational goals.
Must be able to work effectively in a fast-paced, dynamic and high-intensity environment including open-floor plan if applicable to the position, with timely responsiveness and the ability to work beyond normal business hours when required.
Employee Programs & Benefits:
CCI offers competitive benefits and programs to support our employees, their families and local communities. These include:
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
Visit https://www.cci.com/careers/life-at-cci/# to learn more!
#LI-CD1
Top Skills
What We Do
Castleton Commodities International is an independent global energy commodity merchant and infrastructure asset investor. As a trader, CCI deploys capital on a proprietary basis in the physical and financial commodity markets, providing the Company with market insights and access. As a strategic investor and developer, CCI leverages its market expertise, operations capabilities, and industry knowledge to invest in, and develop, select commodity infrastructure assets.
.png){kind=logo}
