Vice President, Lead Data Engineer

Castleton Commodities International; Greater London; On-site; GBP 80,000 - 100,000; Full time

Job summary

A leading financial services firm in Greater London is seeking a highly skilled Lead Data Engineer to shape their finance data platform. You'll design and implement data models within a modern stack including dbt Cloud and AWS Redshift, while mentoring another Data Engineer. The ideal candidate has over 8 years of experience, strong SQL skills, and expertise in cloud technologies. Benefits include comprehensive medical and wellness programs, volunteer opportunities, and competitive paid time off.

Benefits

Competitive medical and dental benefits

Employee wellness programs

Parental leave policies

Tuition assistance

Competitive paid time off

Qualifications

• 8+ years of hands-on data engineering experience delivering scalable solutions.
• Expert proficiency in SQL and data modeling with complex structures.
• Deep experience with cloud data warehouse technologies.

Responsibilities

• Design and maintain a scalable analytical data layer in AWS Redshift.
• Lead development of data models using dbt Cloud, maintaining best practices.
• Mentor a Data Engineer for technical growth and project success.
• Partner with Finance Data to translate business needs into data products.
• Ensure stability and governance of the data platform.

Skills

SQL

Data modeling

dbt (Cloud)

AWS Redshift

Agile/Scrum

Communication

Collaboration

Tools

Amazon Redshift

dbt Cloud

Atlan

Monte Carlo

Job description

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 mentoring 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

• 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