Snowflake Data Architect

Snowflake Data Architect at N Consulting Ltd

Job title: Snowflake Data Architect

Job location: London, UK

Job type: Permanent

Job mode: Hybrid

JD:

Job Description:

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