SNOWFLAKE INFRASTRUCTURE ENGINEER - Outside IR35 at Perfect People Recruitment Solutions Ltd, England, £550-£700 per day

SNOWFLAKE INFRASTRUCTURE ENGINEER

Contract | Outside IR35 | £550-£700/day

Fully remote or London Hybrid | 6 months + Extension

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.

THE ROLE

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

WHAT YOU NEED

Mandatory:

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

DETAILS

• Rate: £550-£700 per day (outside IR35)
• Location: Fully remote orLondon hybrid
• Duration: 6+ months with strong likelihood of extension
• Start: ASAP
• Right to work in the UK required

To apply, please submit your CV detailing your specific Snowflake infrastructure experience, including the Terraform resources you have worked with and the RBAC frameworks you have operated within.