Snowflake Data Architect

Location: Hybrid (onsite 1 Day Per Week)
Clearance: SC Cleared (DV advantageous)
Contract Type: Contract
Contract Length: 6 Months (Plus possibility of extension)
Rate/Salary: 600-700 (Based on Experience)
Start Date: ASAP
ACTIVE SECURITY NEEDED

About the Role

We’re supporting a major UK public sector organisation undergoing a large scale data modernisation programme. As a Snowflake Architect, you will play a key role in designing, developing, and optimising a secure, scalable Snowflake data platform that underpins important services delivered to the public.

You’ll work closely with data engineering teams, security teams, and senior stakeholders to ensure the platform meets public sector standards around governance, compliance, and performance.

Key Responsibilities

• Lead the end to end architectural design of the Snowflake data platform, including schema design, modelling, ingestion patterns and workload orchestration.
• Define and implement best practices around Snowflake performance tuning, cost optimisation, and data governance.
• Oversee integration of Snowflake with wider cloud ecosystems (Azure / AWS / GCP depending on programme).
• Work with data engineers to modernise existing legacy pipelines into secure, scalable Snowflake based solutions.
• Create architectural documentation, patterns, standards, and reference designs suitable for public sector environments.
• Ensure all data solutions meet security, compliance, and audit requirements aligned to SC/DV cleared environments.
• Provide technical leadership, coaching, and support across multidisciplinary delivery teams.

Essential Skills & Experience

• Demonstrable experience as a Snowflake Architect on complex, enterprise-scale programmes.
• Strong background in data modelling, Cloud Data Warehousing, and ELT frameworks.
• Hands-on experience with:
  • Snowflake configuration & security
  • Snowpipe, Streams, Tasks, Stages
  • Performance optimisation & cost control
  • SQL, Python, dbt (advantageous)
• Experience working in public sector or other highly regulated environments.
• Good knowledge of cloud ecosystems such as Azure, AWS, or GCP.
• Active SC Clearance.

Desirable

• DV Clearance
• Experience with Databricks, Spark, or broader data platform tooling
• CICD experience with Terraform, GitHub Actions, Azure DevOps, or similar
• Strong stakeholder engagement and technical leadership skills

What’s on Offer

• Opportunity to drive a high-impact, nationally significant public sector data transformation
• Long-term pipeline of work
• Flexible hybrid working
• Cooperative, mission-driven environment

How to Apply

If you’re an experienced Snowflake Architect with public sector or secure cleared project experience, please get in touch.
Send your CV or reach out directly to discuss the role further.