Snowflake Data Architect

LocationLondon, England, United Kingdom# Snowflake Data Architect at N Consulting LtdLocationLondon, England, United KingdomSalary£80 - £90 /yearJob TypeFull-timeDate PostedJanuary 23rd, 2026Apply Now Role: Snowflake Data Architect Experience: 15years Location: London Work mode: Hybrid Job Description: Roles & Responsibilities Possess 15 plus years of work experience at a reputable Data & AI services firm. Outstanding written and verbal communication skills, with a flair for compelling storytelling. Analyse complex insurance data to identify trends, patterns, and insights that support strategic business decisions. Design and implement an enterprise-grade Data Vault 2.0 architecture on Snowflake, ensuring scalability, flexibility, and auditability. Lead the end-to-end data architecture design, from data ingestion through transformation to reporting layers. Collaborate with business stakeholders to understand insurance-specific data requirements (e.g., policy, claims, underwriting, premiums, risk, reinsurance). Define data modelling standards, naming conventions, and governance frameworks aligned with industry best practices. Work with data engineering teams to implement dbt-based data pipelines for data transformation and lineage tracking. Ensure efficient data integration and performance optimization across Snowflake and downstream systems. Partner with BI developers to enable Power BI reporting and semantic modelling using curated data layers. Oversee data quality, validation, and reconciliation processes to ensure accurate and reliable reporting. Provide technical leadership and mentorship to engineering and analytics teams on Data Vault and Snowflake architecture.