Technical Data Analyst

Arthur J. Gallagher & Co. · London, England ·

Last confirmed by our partners on 23 Oct 2026.

Apply on partner site You apply on the advertiser's own site — nothing is stored here.

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, Lloyds 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
Apply on partner site Listing supplied by one of our partner job boards. Last confirmed: 5 days ago.

Report this job

Market data from EasyWorkClub, not from the employer

Typical pay for Data analyst in London: £37,600 – £72,500, from 104 adverts

320 live adverts for Data analyst in London

Remote or home office in 14% of 65 Data analyst adverts we list nationwide

More openings at Arthur J. Gallagher & Co.

67 other openings we list

Arthur J. Gallagher & Co.London Apply