SNOWFLAKE INFRASTRUCTURE ENGINEER - Outside IR35

A leading London insurance company is looking for a Snowflake Infrastructure Engineer to join a small, high-performing contractor team on a critical platform delivery programme.

This is a pure infrastructure role. You will be working directly on the Snowflake platform estate - owning RBAC operations and refactoring, Terraform-managed object provisioning, and CI pipeline automation. There is no data ingestion, no ETL, and no dbt work involved - that sits with a separate team., You will take ownership of an active RBAC refactoring workstream, working within and extending a mature Snowflake implementation. Day-to-day you will be:

• Managing and refactoring the Snowflake RBAC framework - roles, grants, privileges, and least-privilege access patterns
• Provisioning and managing Snowflake objects (databases, schemas, warehouses, network policies, resource monitors) exclusively through Terraform
• Maintaining and improving CI/CD pipelines for infrastructure delivery and environment promotion
• Supporting Terraform Snowflake provider upgrades and state management
• Working closely with two existing Snowflake contractors and a broader platform engineering team

• Proven experience operating within an existing Snowflake RBAC implementation - not just designing one from scratch
• Hands-on Terraform experience with the Snowflake provider - writing and maintaining IaC for Snowflake objects, roles, and grants
• CI/CD pipeline experience for infrastructure delivery (GitLab, GitHub Actions, or similar)
• Multiple Snowflake implementations across different employers

Highly desirable:

• SnowPro Core or SnowPro Advanced: Administrator certification
• Experience with Terraform Snowflake provider version upgrades and breaking change management
• Dynamic data masking, row-level security, or network policy experience
• Financial services or insurance sector background
• Familiarity with Snowflake security features - SSO/SCIM integration, PrivateLink, audit logging
• AWS or Azure infrastructure experience

THE ENVIRONMENT

• This is a regulated, fast-paced Lloyd's market environment where contractors are expected to operate independently, communicate clearly with technical and non-technical stakeholders, and contribute from day one. The team values calm delivery under pressure, technical credibility, and a practical, solutions-first mindset.