Snowflake Data Architect (Wembley)

Data Science Jobs UK; Wembley; On-site; GBP 90,000 - 110,000; Full time

Benefits offered by this job

Permanent benefits

Job summary

Data Science Jobs UK is seeking an experienced Snowflake Data Architect to shape a modern, enterprise data platform in Wembley. This on-site role offers a £90,000–£110,000 package and permanent benefits.

You will define architecture standards, drive governance and best-practice across data engineering teams, design scalable Snowflake pipelines, and deliver trusted data products that empower analytics, automation, and AI capabilities across the business.

Qualifications

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

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.

Skills

Data architecture

Data modelling

Data governance

CI/CD

Cloud & analytics

Snowflake design

Tools

Snowflake

dbt

GitHub

AWS

Kestra

Job description

Snowflake Data Architect

Location: Wembley (Fully on-site)

Salary

£90,000 – £110,000 pa

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