Job title: Snowflake Data Architect
Job location: London, UK
Job type: Permanent
Job mode: Hybrid
JD:
Job Description: Snowflake Data Architect
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.