Snowflake Data Engineer

• Required Skill Advanced SQL;
  Amazon Web Service (AWS);
  Python;
  Snowflake;
  Snowflake Champion (Certified)
• Number of Positions 1
• City Mansion House
• Province Greater London
• Postal Code EC4
• Country United Kingdom
• Job Type NA

Thank you for taking the time to view this vacancy. Our Talent Team are on annual leave until Monday 5th January and will be reviewing applications upon their return. Who we are Kubrick is a next-generation Data and AI consultancy, designed to accelerate delivery and build amazing teams for our clients. We deliver services across data, AI, and cloud and we’re building the next generation of tech leaders. Since

2017 we have established a market leading position supporting our clients build their data and technology teams and deliver enduring solutions. As part of our Data Engineering team, you will be joining a tight knit team of motivated technology professionals where ongoing learning and development are central to our ethos and internal culture. You will work closely with our wider technical delivery function, our sales team, and our partner management team.

Role Description We are seeking a Snowflake Data Engineer to lead the design, development and deployment of cloud data platforms and analytics solutions using Snowflake. This combines hands‑on engineering, solution architecture and technical leadership. You will translate business requirements into scalable Snowflake solutions, guide project teams on best practices for data modelling and ELT design, and ensure that outcomes deliver measurable value for our clients.

• Lead technical delivery within Kubrick’s squad deployed on client project engagements, ensuring that Kubrick is recognized for the quality and scalability of its solutions.
• Translate complex business and data requirements into robust Snowflake designs, including data ingestion, transformation, and consumption layers.
• Design and implement secure, performant Snowflake environments including RBAC, data masking, and policies/entitlement understanding.
• Build and optimise ELT pipelines (using tools such as dbt, Airflow, Fivetran, or native Snowflake tasks) to support batch and real‑time use cases.
• Collaborate with Kubrick and client stakeholders to inform delivery planning, data strategy, and architecture decisions.
• Promote engineering excellence through code reviews, reusable patterns, and contribution to Kubrick’s internal knowledge base.
• Line‑manage and mentor developers within the team, supporting their professional growth and certifications (including Snow Pro).
• Troubleshoot and tune query performance, storage usage, and cost efficiency across Snowflake accounts.
• Act as a subject matter expert during consulting engagements, providing advice on best practices for data sharing, and integration with other technology (e.g. Databricks, Starburst, Tableau, Power BI).
• Ensure solutions meet both functional and non‑functional requirements such as scalability, security, reliability and cost optimization.

• Experienced in data engineering or analytics, including designing and delivering enterprise grade data solutions.
• Strong hands‑on experience with Snowflake (or comparable cloud data warehouses like Big Query, Red Shift, Synapse) including data modelling, performance tuning and cost management.
• Familiarity with SQL best practices, ELT patterns, and modern data transformation frameworks such as dbt.
• Competence in at least one programming language (Python preferred) for automation.
• Experience with cloud platforms (AWS, Azure, or GCP), including security, IAM, and storage services.
• Experience deploying and maintaining production pipelines using tools such as Airflow or Dagster.
• Understanding of CI/CD principles, version control (Git) and software development lifecycle.
• Strong communication and stakeholder‑management skills with the ability to influence technical and business decision makers.
• Experience in delivery leadership and mentoring junior engineers.
• Proven ability to troubleshoot complex data issues, optimise pipelines and ensure data quality and governance are maintained.

Role Details Contract type:
Permanen…