Snowflake Data Architect (Wembley)

Snowflake Data Architect

Location: Wembley (Fully on-site)

Salary: £100,000 + Permanent Benefits

The Opportunity

We are seeking an experienced Snowflake Data Architect to play a key role in shaping and evolving a modern enterprise data platform. This is an opportunity to define architecture standards, drive best practice across data engineering teams, and build scalable solutions that support analytics, automation, and emerging AI capabilities.

The successful candidate will be responsible for establishing data modelling standards, designing robust integration architectures, driving platform optimisation, and ensuring the delivery of high-quality, trusted data products across the business.

Key Responsibilities

Define and own enterprise-wide data architecture standards, including Data Vault, semantic layer frameworks, star schema modelling patterns, and Snowflake design conventions.

Design scalable integration patterns for legacy and modern data sources, ensuring strong governance, reconciliation, auditability, and data quality.

Architect cloud-based data pipelines leveraging Snowflake and modern orchestration technologies, ensuring reliability, scalability, and operational excellence.

Establish security and access frameworks, including role-based access control, data masking, row-level security, and environment separation best practices.

Lead initiatives to optimise platform performance and cost management, identifying efficiencies in data processing, storage, and query execution.

Design data structures and architectures that enable AI, GenAI, and advanced analytics use cases, including semantic and metadata-driven solutions.

Partner closely with data engineering teams, business stakeholders, and analysts to define data contracts and maintain a consistent, trusted data ecosystem.

Promote a Data-as-Code culture, driving engineering standards, automation, governance, and CI/CD best practices.

About You

You will be a highly experienced Data Architect with a strong track record of modernising enterprise data environments and delivering scalable cloud-based solutions.

Required Experience

10+ years' experience within Data Engineering, Data Architecture, or a related field.

At least 4 years of hands-on Snowflake architecture and design experience.

Proven expertise in Data Vault 2.0 and dimensional modelling methodologies, including Star Schema design.

Strong knowledge of dbt and source control practices using GitHub.

Experience integrating enterprise data platforms with AWS services and broader cloud ecosystems.

Strong understanding of data governance, security, CI/CD, and engineering best practices.

Experience transforming legacy data environments into modern, automated cloud-based architectures.

Desirable

Experience with Kestra or other modern orchestration platforms.

Exposure to AI, GenAI, vector search, embeddings, or semantic data architectures.

Retail, wholesale, supply chain, or large enterprise data platform experience