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.

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

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

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