Vice President, Lead Data Engineer

Castleton Commodities International; Heanor; On-site; GBP 70,000 - 90,000; Full time

Job summary

A leading energy and commodities firm in the United Kingdom is seeking a Lead Data Engineer to optimize our enterprise finance data platform. The successful candidate will design and build high-quality data solutions using modern technologies like AWS Redshift and dbt Cloud. With at least 8 years of experience, strong leadership skills, and technical expertise, the role offers competitive benefits including educational support and community engagement programs.

Benefits

Comprehensive medical and dental benefits

Wellness programs

Tuition assistance

Employee discount program

Qualifications

• 8+ years of data engineering experience in production environments.
• Expert proficiency in SQL and complex data structures.
• Extensive experience with dbt (Cloud or Core).
• Experience with modern cloud data warehouse technologies.

Responsibilities

• Design and maintain a technical data layer within AWS Redshift.
• Lead the development of data models using dbt Cloud.
• Mentor a Data Engineer through expert guidance and reviews.
• Translate business requirements into reliable data products.
• Ensure platform stability and governance for data products.

Skills

SQL proficiency

Data modeling

Leadership

Agile/Scrum

Communication skills

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