Castleton Commodities International (CCI) is looking for a highly skilled Lead Data Engineer to take a pivotal, hands‑on role in shaping our enterprise finance data platform. This is a senior, technical position where you will be the primary architect and builder of our most critical data assets.
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 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
#J-18808-Ljbffr