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
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.