Data Design Lead (Snowflake)

Tokio Marine HCC; Greater London; On-site; GBP 80,000 - 110,000; Full time

Benefits offered by this job

Competitive salary

Employee benefits package

Job summary

A leading insurance company is seeking a Data Design Lead (Snowflake) in Greater London. This individual will act as the platform authority and champion within the Data & Analytics function, ensuring the optimal use of the Snowflake platform. Responsibilities include overseeing technical integrity, approving data designs, and evolving architectural standards. Ideal candidates will have significant experience in data architecture, familiarity with Snowflake, and experience in regulated environments. Competitive salary and benefits are offered.

Qualifications

• Significant experience in data architecture or senior data engineering roles.
• Experience as a Snowflake technical lead within a medium-to-large organization.
• Ability to produce clear and pragmatic architecture documentation.

Responsibilities

• Own the technical integrity and evolution of the Snowflake platform.
• Act as an approver for low-level data designs and ensure adherence to standards.
• Own and evolve medallion patterns in Snowflake and DBT.

Skills

Data architecture

Snowflake platform expertise

DBT-based transformation patterns

Collaboration skills

Experience in regulated environments

Tools

Fivetran

Job description

**Job Title: Data Design Lead (Snowflake)** this role sits within: Join us to grow your skills, influence strategic outcomes, and be part of a supportive culture that values resilience, curiosity, quality, and continuous improvement. **Job Purpose:** The Data Design Lead (Snowflake) is the Snowflake platform authority and architectural champion within TMHCC International’s Data & Analytics function, acting as deputy to the Head of Data Design & Engineering. The role owns the technical integrity, evolution, and enablement of the ARCUS Snowflake platform, ensuring it is used optimally, consistently, and safely across the organisation. This includes acting as the primary escalation point, design authority, and internal expert for Snowflake architecture, DBT-based transformation patterns, and medallion-layer design. **Key Responsibilities:**Act as an approver for low-level data designs, ensuring adherence to architectural principles, security requirements, and platform standards.Own and evolve canonical Snowflake + DBT medallion patterns (bronze, silver, gold), including layer responsibilities, modelling conventions, and performance expectations.Deputy Effectiveness: Act as an effective deputy to the Head of Data Design & Engineering by owning day-to-day architectural decision-making and operational design oversight, materially reducing escalation and dependency on the role holder. **Skills and Experience Specification:** Significant experience in data architecture, data solution architecture, or senior data engineering roles.Experience acting as a Snowflake technical lead, platform owner, or internal SME within a medium-to-large organisation. Familiarity with Snowflake roadmap-driven adoption and controlled enablement in regulated environments. Proven experience designing and governing enterprise-scale data platforms. Experience with ingestion and CDC tooling (e.g. Fivetran or equivalent).Familiarity with GDPR and implementation considerations for enterprise data platforms.Ability to produce clear, pragmatic architecture documentation, patterns, and standards. Excellent collaboration and stakeholder management skills, including the ability to challenge constructively. Experience in commercial or specialty insurance data domains. Experience operating in regulated or risk-sensitive environments.**What We Offer** The Tokio Marine HCC Group of Companies offers a competitive salary and employee benefit package. We are a successful, dynamic organization experiencing rapid growth and are seeking energetic and confident individuals to join our team of professionals.