Snowflake Data Architect - London, Wembley

Adecco

Wembley, UK

3 days ago

Apply on www.careerboard.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

4 years minimum

Compensation

£85,000.0 - £110,000.0

Working hours

Regular working hours

Job source

www.careerboard.com

Tech stack

Application Programming Interfaces (APIs) Artificial Intelligence Amazon Web Services Amazon S3 Audit Trail Microsoft Azure Cloud Computing Encodings Data Architecture Information Engineering Data Infrastructure Data Structures

+18 more

Data Stores Data Vault Modeling Data Warehousing Identity and Access Management Python (Programming Language) Operational Data Store Software Product Management Role-Based Access Control SQL Databases Large Language Models Snowflake Data Build Tool (dbt) Data Lakes Data Lineage Star Schema Enterprise Integration Dynamic Data Data Pipelines

Job description

Data Modelling Standard: defining Star Schema patterns, Snowflake object hierarchies, and modelling conventions that serve as the Group-wide standard for all data products.
Cross-Cloud Orchestration: Design and implement secure, high-throughput data pipelines connecting AWS S3 and Azure APIs through Snowflake - ensuring data integrity, lineage tracking, and end-to-end auditability.
Snowflake Governance: Own the full security model for the Snowflake platform - RBAC policy design, dynamic data masking, row-level security, and comprehensive audit logging across all environments.
FinOps for Data: Monitor Snowflake credit consumption patterns, identify and remediate high-cost query anti-patterns, and implement warehouse scheduling strategies to reduce operational data spend.
AI Readiness: Architect data stores purpose-built for LLM consumption - including vector databases, embedding pipelines, and RAG-compatible data structures that will serve as the foundation for Bestway’s AI product layer.
Data Contracts: Partner with Business Analysts to formally define and document ‘Data Contracts’ between systems - creating clear, agreed interfaces between producers and consumers across the data platform.

Requirements

Solid experience in Data Engineering or Data Architecture, with a minimum of 4 years specialising in Snowflake platform design and governance.
Data Architecture: Mastery of Data Warehouse design methodologies - Inmon, Kimball, and Data Vault 2.0 - with the judgement to apply the right pattern for the right use case.
Technical Skills: Expert SQL and Python; hands-on experience with dbt (data build tool) or equivalent transformation frameworks.
AWS Integration: Solid understanding of AWS IAM, S3 data lake patterns, and PrivateLink for cross-cloud data connectivity.
AI Readiness: Practical experience architecting data infrastructure for AI/ML consumption - vector databases, embedding stores, and RAG pipeline integration.
Soft Skills: Strong interpersonal skills; ability to translate complex data architecture into clear language for Business Analysts and non-technical stakeholders.