Technical Data Analyst

Role Overview

Join Gallagher’s Data Technology team as a Technical Data Analyst to help shape and deliver high-quality data products that support reporting, analytics, and business decision-making across the organisation. You’ll work at the intersection of business and technology, partnering with Data Engineers, Architects, and stakeholders to analyse complex insurance data and develop robust data models.

What You Will Do

As a Technical Data Analyst, you’ll analyse complex insurance datasets, develop logical and physical data models, and perform source-to-target mapping and validation. You’ll also develop and maintain data transformation pipelines using dbt, build and test scalable data models within Snowflake, and collaborate with Data Engineers to improve data platform performance and reliability.

Why It Might Be a Fit

This role is ideal for someone who combines technical expertise with a genuine interest in solving business problems through data. You’ll be comfortable working hands-on with SQL, Snowflake, and dbt, and translating business requirements into scalable technical solutions.

Requirements

• Previous experience within Insurance, Lloyd’s Market, Specialty Insurance or Reinsurance environments
• SQL skills with the ability to develop efficient, optimised queries
• Hands-on experience with Snowflake
• Proven experience developing data transformations and data models using dbt
• An understanding of dimensional modelling and data warehousing principles
• Experience working with ETL/ELT processes 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

Benefits

• Competitive compensation
• Comprehensive benefits programs designed to support your well-being
• Career development opportunities and ongoing learning
• A collaborative, people-first culture with accessible leadership
• The opportunity to do meaningful work with global reach and local impact

Tagged as: Data Analysis