Snowflake Data Architect

Snowflake Data Architect

Location: Wembley, London - FULLY ON-SITE

Salary: Up to £95,000 + Benefits

We are seeking an experienced Snowflake Data Architect to play a pivotal role in shaping and delivering a modern enterprise data platform. This is an opportunity to join a business undergoing significant data transformation, moving from legacy systems and manual processes to a scalable, automated, cloud-first architecture.

You will be responsible for defining architectural standards, driving best practices, and enabling engineering teams to deliver high-quality, trusted data products that support analytics, reporting, and emerging AI initiatives.

Key Responsibilities

Define and own enterprise-wide data modelling standards, including Data Vault, semantic layers, Star Schema patterns, Snowflake object hierarchies, and governance frameworks.

Design scalable integration architectures for legacy platforms, including AS400, iSeries, and SQL-based systems, ensuring robust reconciliation, auditability, and incremental data loading capabilities.

Architect modern data pipelines leveraging Snowflake and orchestration technologies, ensuring reliability, scalability, idempotency, and effective error handling.

Establish and govern security models across the data platform, including role-based access control (RBAC), dynamic masking, row-level security, and environment segregation.

Drive platform performance optimisation and cost management within Snowflake, identifying inefficiencies and implementing scalable warehouse, clustering, and workload management strategies.

Design data architectures that support AI and GenAI use cases, including vector search capabilities, embedding pipelines, and semantic data structures.

Collaborate with Business Analysts, Data Engineers, and stakeholders to define data contracts and implement automated data quality frameworks.

Champion Data-as-Code principles, helping establish CI/CD best practices and engineering standards across the organisation.

Provide architectural leadership, mentoring engineering teams and translating complex technical concepts into practical guidance.

Required Experience

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

Minimum 4 years' hands-on experience designing and implementing solutions within Snowflake.

Demonstrated success delivering enterprise-scale data transformation programmes and modernising legacy data environments.

Deep expertise in Data Vault 2.0, Kimball dimensional modelling, and Inmon methodologies, with the ability to select the right approach for varying business requirements.

Advanced knowledge of dbt and Git-based development practices.

Strong experience designing cloud-based data solutions, including integrations across AWS and Azure environments.

Proven track record implementing CI/CD pipelines and promoting software engineering best practices within data teams.

Experience defining data governance, security frameworks, and quality standards across enterprise platforms.

Desirable Skills

Experience with Kestra or similar modern orchestration platforms.

Knowledge of Snowflake Native Apps, Snowpark, and emerging AI/ML capabilities within modern data platforms.

Exposure to vector databases, embeddings, retrieval-augmented generation (RAG), and AI-ready data architectures.

Retail, wholesale, supply chain, or large-scale transactional data experience