Snowflake Engineer

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.