Lead Analytics Engineer (Contract)

Harnham is partnering with a growing team focused on stabilising and maturing their Snowflake data platform. They are seeking a skilled Analytics Engineer to join a hands-on, delivery-focused team responsible for building and maintaining centralised data warehouse assets used across the business. The Team The team is part of a broader Analytics Engineering function, aligned to business pillars but operating centrally to provide high-quality, reusable data assets. You'll work closely with other Analytics Engineers and domain teams to ensure data models are performant, scalable, and widely adopted. What You'll Be Doing • Hands-on development using SQL, DBT, and Snowflake • Implementing, refactoring, and optimising Snowflake data models • Creating and maintaining data assets, ensuring performance, quality, and reliability • Updating consumers and reviewing code to maintain standards • Working within structured project tracking tools (Asana / Jira) • Delivering approximately 50 refactorings/migrations and creating at least 5 new assets during the contract Who We're Looking For • Strong experience in SQL, DBT, and Snowflake • Familiarity with dimensional modelling (Kimball methodology preferred) • Understanding of building models for large stakeholder groups • Experience with performance optimisation, data quality, and query/resource efficiency • Comfortable working in a collaborative, fast-moving environment with a growth mindset • Experience with startups or SaaS companies is a plus Why This Role • Work on a centralised data platform with high visibility and impact • Remote, contractor-friendly environment outside IR35 • Opportunity to work on large-scale data models, refactorings, and new asset creation • Collaborate with a supportive and experienced Analytics Engineering team Interview Process • Case study (essential - candidates complete a provided template) • Technical / market conversation focusing on: • Dimensional modelling experience • Snowflake model design for multiple stakeholders • Performance optimisation and data quality • Refactoring and migrations Availability: Interviews scheduled across Thursday 26th