Snowflake Engineer

Snowflake Engineer

Posted Today by twentyAI

Negotiable
Inside
Hybrid
London Area, United Kingdom

Summary: The Snowflake Engineer role involves driving the architecture and implementation of a greenfield Snowflake project for a leading commodities trading client. The position requires hands-on expertise in deploying and automating Snowflake, along with collaboration with various teams to integrate Snowflake with existing systems. The role is hybrid, requiring a minimum of three days onsite in Westminster, London, and is expected to last for six months with a strong likelihood of extension. The position is classified as inside IR35 due to PAYE provisions.

Key Responsibilities:

  • Design, build, and manage CI/CD pipelines for Snowflake deployments using GitLab CI/CD.
  • Automate infrastructure provisioning with Terraform, ensuring secure, repeatable environments.
  • Collaborate with platform and data teams to integrate Snowflake with on-prem SQL Server and Kafka pipelines.
  • Implement identity and access management via Active Directory and other identity providers (e.g., SSO, SAML, Okta).
  • Enforce security and access control across Snowflake and DevOps workflows.
  • Monitor, troubleshoot, and optimize Snowflake platform performance and stability.
  • Contribute to documentation, runbooks, and the development of internal DevOps standards.

Key Skills:

  • Proven experience deploying and automating Snowflake in production environments.
  • Hands-on expertise with GitLab CI/CD, Terraform, and infrastructure as code principles.
  • Comfortable working in hybrid data environments with on-prem SQL Server and Kafka integration.
  • Deep understanding of identity integration technologies (SSO, SAML, Active Directory, Okta, Azure AD).
  • Strong scripting and automation skills, particularly with Bash and Python.
  • Experience operating in secure, high-volume data environments, ideally in trading, finance, or energy sectors.
  • Capable of working autonomously while shaping strategic DevOps direction in a greenfield setting.

Salary (Rate): undetermined

City: London

Country: United Kingdom

Working Arrangements: hybrid

IR35 Status: inside IR35

Seniority Level: undetermined

Industry: Other

Detailed Description From Employer:

Snowflake Engineer

Location : Westminster, London

Hybrid : 3 days per week onsite (minimum)

Duration : 6 months initial contract (strong likelihood of extension)

Start : ASAP (realistic mid-August)

Client sector : Commodities trading

IR35 : Inside (PAYE provided by twentyAI or 3rd party)

About Mercuria

twentyAI's customer is one of the world’s largest independent energy and commodities groups, operating across the entire value chain — from sourcing and trading physical commodities to investing in energy infrastructure and low-carbon initiatives.

The project

With innovation at its core, twentyAI's customer is rapidly modernising its data architecture to support high-volume trading, analytics, and risk management systems. This Snowflake project is a strategic part of that transformation as they embark on a greenfield Snowflake implementation and so are seeking a hands-on Snowflake Architect. You will drive the architecture of the build, provide deep strategic understanding, and provide thought leadership around the integration of Snowflake.

Key Responsibilities

  • Design, build, and manage CI/CD pipelines for Snowflake deployments using GitLab CI/CD.
  • Automate infrastructure provisioning with Terraform, ensuring secure, repeatable environments.
  • Collaborate with platform and data teams to integrate Snowflake with on-prem SQL Server and Kafka pipelines.
  • Implement identity and access management via Active Directory and other identity providers (e.g., SSO, SAML, Okta).
  • Enforce security and access control across Snowflake and DevOps workflows.
  • Monitor, troubleshoot, and optimize Snowflake platform performance and stability.
  • Contribute to documentation, runbooks, and the development of internal DevOps standards.

Key Skills & Experience

  • Proven experience deploying and automating Snowflake in production environments.
  • Hands-on expertise with GitLab CI/CD, Terraform, and infrastructure as code principles.
  • Comfortable working in hybrid data environments with on-prem SQL Server and Kafka integration.
  • Deep understanding of identity integration technologies (SSO, SAML, Active Directory, Okta, Azure AD).
  • Strong scripting and automation skills, particularly with Bash and Python.
  • Experience operating in secure, high-volume data environments, ideally in trading, finance, or energy sectors.
  • Capable of working autonomously while shaping strategic DevOps direction in a greenfield setting.