Vice President, Lead Data Engineer

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

Job summary

A leading financial services company in the UK is seeking a highly skilled Lead Data Engineer to architect and develop their enterprise finance data platform. The ideal candidate will have over 8 years of hands-on experience in data engineering, expert proficiency in SQL, and a strong background in building scalable data solutions. Responsibilities include mentoring a Data Engineer and ensuring the technical excellence of data initiatives. Competitive benefits package includes health insurance, family leave, and tuition assistance.

Benefits

Comprehensive medical and dental benefits

Employee wellness programs

Parental and family leave policies

Tuition assistance

Competitive paid time off

Qualifications

• 8+ years of hands-on data engineering experience with scalable solutions.
• Expert-level proficiency in SQL and complex data structures.
• Deep experience with cloud data warehousing like Redshift.

Responsibilities

• Design and maintain a scalable analytical data layer in AWS Redshift.
• Lead development of robust data models using dbt Cloud.
• Act as senior technical expert, mentoring another Data Engineer.

Skills

SQL

Data modeling

Data governance

Agile/Scrum frameworks

Mentoring

Data observability tools

Tools

Redshift

dbt Cloud

Atlan

Monte Carlo

Snowflake

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

• 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!