Technical Data Analyst

Overview

In this role, you will shape and deliver high-quality data products to support reporting, analytics, regulatory needs and business decisions. You’ll work at the intersection of business and technology with Data Engineers, Architects, Product Owners and stakeholders to analyse insurance data and build robust data models on a modern cloud platform. You will translate business requirements into scalable data solutions while ensuring trusted datasets across Snowflake-based environments. This is an opportunity to apply hands-on data skills to solve real risk and regulatory challenges in a collaborative, growth-focused culture.

Pay / Benefits

• competitive compensation
• comprehensive benefits programs
• career development opportunities
• collaborative, people-first culture
• global reach with local impact

Responsibilities

• Analyse complex insurance datasets across policy, claims, underwriting, finance and regulatory domains to support reporting and analytics
• Develop logical and physical data models and maintain data definitions
• Conduct data investigations and root-cause analysis to identify issues and enable remediation
• Perform source-to-target mapping and validate transformation logic across systems
• Develop and maintain data transformation pipelines using dbt and optimise data models in Snowflake
• Create reusable datasets, metrics and semantic layers for enterprise analytics
• Collaborate with Data Engineers to improve platform performance, reliability and scalability
• Design and execute data quality checks, validations and metadata management activities
• Translate business requirements into data solutions and contribute to data product delivery and governance

Key requirements

• Experience in Insurance, Lloyd’s Market, Specialty Insurance or Reinsurance environments
• SQL skills with efficient, optimised queries
• Hands-on experience with Snowflake
• Experience developing data transformations and models using dbt
• Understanding of dimensional modelling and data warehousing principles
• Experience with ETL/ELT and modern cloud-based data architectures
• Knowledge of data lineage, metadata management and data quality frameworks
• Experience using Git and working within CI/CD environments
• Excellent analytical, problem-solving and stakeholder engagement skills

• Analytical thinking
• Stakeholder engagement
• Problem-solving
• SQL
• Snowflake
• dbt

…