Job Title: Data Design Lead (Snowflake)
Reporting to: Head of Data Design and Engineering
Position Type: Individual Contributor
Standing still is not an option in the current world of Insurance. TMHCC are one of the world’s leading Specialty Insurers. With deep expertise in our chosen lines of business, our unparalleled track record and a solid balance sheet, TMHCC evaluates and manages risk like no one else in the industry. Looking beyond profit, empowering our people and delivering on our commitments are at the core of our customer values, and so is a desire to grow and provide creative and innovative solutions to our clients.
Operations sits at the heart of TMHCC, we ensure the smooth running of all business processes — from policy administration and claims handling to data, technology, and delivery. We focus on driving efficiency which enables our teams across the business to deliver exceptional results every day. Our value statement: Ops makes it happen.
Operations is made up of 7 functions, this role sits within: Data Office
The TMHCC Data Office is a dynamic, forward-thinking team where data analytics, data design & engineering, and data governance come together to drive meaningful impact across the business. You’ll collaborate with passionate experts who champion innovation, empower decision-making, and help get the right data to the right people at the right times, to shape decision making at TMHCC.
Join us to grow your skills, influence strategic outcomes, and be part of a supportive culture that values resilience, curiosity, quality, and continuous improvement.
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.
1. Solution Design & Low-Level Architecture
Act as an approver for low-level data designs, ensuring adherence to architectural principles, security requirements, and platform standards.
2. Operational Architecture & Production Stewardship
Maintain and prioritise architecture-led technical backlogs covering refactoring, resilience, cost optimisation, and platform hygiene.
Ensure operational patterns (monitoring, alerting, error handling, recovery) are applied consistently across solutions.
Own Snowflake run-state health, including warehouse sizing strategies, query performance, cost efficiency, and concurrency management.
Lead architectural decisions related to Snowflake cost optimisation, including workload isolation, warehouse reuse, and consumption controls.
3. Snowflake Platform Evolution & Enablement
Act as TMHCC International’s internal Snowflake Subject Matter Expert (SME), providing authoritative guidance on platform capabilities, limitations, and best-fit usage.
Serve as the design and escalation authority for Snowflake-specific decisions, including performance optimisation, warehouse strategy, data sharing, security models, and cost governance.
Own and evolve canonical Snowflake + DBT medallion patterns (bronze, silver, gold), including layer responsibilities, modelling conventions, and performance expectations.
Act as final design authority for DBT project structures, model materialisation strategies, testing conventions, and semantic-layer design.
4. Standards, Governance & Enterprise Alignment
5. Leadership, Mentorship & Delegated Authority
Architectural Consistency: Establish and enforce consistent low-level data architecture patterns across the ARCUS platform, ensuring all new and materially changed solutions align with agreed Snowflake, DBT, and medallion-layer standards with minimal rework.
Production Stability & Operability: Improve the stability, data quality, and operability of production data solutions by strengthening run-state architectural patterns, reducing repeat incidents, and embedding robust observability and error-handling approaches.
Architectural Maturity Uplift: Uplift the architectural capability and autonomy of engineering teams through mentoring, design reviews, and clear guidance, resulting in higher-quality designs and reduced reliance on central architecture.
Skills and Experience Specification:
Deep, hands-on expertise with Snowflake as an enterprise analytics platform, including performance tuning, cost management, access control, and production operations, alongside advanced SQL and DBT.
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.
The Tokio Marine HCC Group of companies is an equal opportunity employer. Please visit www.tmhcc.com for more information about our companies.
