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.