Snowflake Data Architect

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 (eg, 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.