Technical Data Analyst

Gallagher; Greater London; Hybrid; Confidential; Full time

Benefits offered by this job

Competitive compensation

Career development opportunities

Collaborative, people-first culture

Job summary

Gallagher in London is seeking an experienced Technical Data Analyst to join our Data Technology team. You will analyse complex insurance data, develop scalable data models and deliver trusted datasets on our cloud data platform.

You will work with Data Engineers, Architects and stakeholders to translate business needs into robust data solutions using SQL, Snowflake and dbt, contributing to governance, quality and scalable delivery.

Qualifications

• Proven SQL skills with efficient, optimised queries.
• Hands-on experience with Snowflake.
• Proven experience developing data transformations and data models using dbt.
• Experience with ETL/ELT processes and cloud data architectures.
• Understanding of dimensional modelling and data warehousing principles.
• Experience using Git and CI/CD environments.
• Strong stakeholder engagement and analytical skills.
• Knowledge of data lineage, metadata management and data quality frameworks.

Responsibilities

• Analyse complex insurance datasets across policy, claims, underwriting, finance and regulatory domains.
• Develop logical and physical data models to support reporting, analytics and operational processes.
• Define, document and maintain business and technical data definitions.
• Conduct data investigations and root-cause analysis to identify issues and support remediation.
• Translate business requirements into effective data solutions.
• Collaborate to design and deliver data products and analytical services.

Skills

SQL

Snowflake

dbt

ETL/ELT

Dimensional modelling

CI/CD

Git

Data governance

Stakeholder engagement

Job description

Introduction

At Gallagher, we help clients face risk with confidence because we believe that when businesses are protected, they’re free to grow, lead, and innovate. You’ll be backed by our digital ecosystem: a client-centric suite of consulting tools making it easier for you to meet your clients where they want to be met. Advanced data and analytics providing a comprehensive overview of the risk landscape is at your fingertips. Here, you’re not just improving clients' risk profiles, you’re building trust. You’ll find a culture grounded in teamwork, guided by integrity, and fueled by a shared commitment to do the right thing. We value curiosity, celebrate new ideas, and empower you to take ownership of your career while making a meaningful impact for the businesses we serve. If you’re ready to bring your unique perspective to a place where your work truly matters; think of Gallagher.

Introduction

At Gallagher, we help clients face risk with confidence because we believe that when businesses are protected, they’re free to grow, lead, and innovate. You’ll be backed by our digital ecosystem: a client-centric suite of consulting tools making it easier for you to meet your clients where they want to be met. Advanced data and analytics providing a comprehensive overview of the risk landscape is at your fingertips. Here, you’re not just improving clients' risk profiles, you’re building trust. You’ll find a culture grounded in teamwork, guided by integrity, and fueled by a shared commitment to do the right thing. We value curiosity, celebrate new ideas, and empower you to take ownership of your career while making a meaningful impact for the businesses we serve. If you’re ready to bring your unique perspective to a place where your work truly matters; think of Gallagher.

Overview

We're looking for an experienced Technical Data Analyst to join our Data Technology team. This is an exciting opportunity to help shape and deliver high-quality data products that support reporting, analytics, regulatory requirements and business decision-making across our organisation.

Working at the intersection of business and technology, you'll partner with Data Engineers, Architects, Product Owners and key stakeholders to analyse complex insurance data, develop robust data models and ensure trusted datasets are delivered across our modern cloud data platform.

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, while translating business requirements into scalable technical solutions.

This role is not a senior position and would suit someone looking for their next step.

We other hybrid working and the expectations is to be in London 3 days a week.

How You'll Make An Impact

Data Analysis & Modelling

• Analyse complex insurance datasets across policy, claims, underwriting, finance and regulatory domains.
• Develop logical and physical data models to support reporting, analytics and operational processes.
• Define, document and maintain business and technical data definitions.
• Conduct data investigations and root‑cause analysis to identify issues and support remediation.
• Perform source-to-target mapping and validate transformation logic across multiple systems.

Data Platform Development

• Develop and maintain data transformation pipelines using dbt.
• Build, test and optimise scalable data models within Snowflake.
• Create reusable datasets, metrics and semantic layers that support enterprise-wide analytics.
• Collaborate with Data Engineers to improve data platform performance, reliability and scalability.

Data Quality & Governance

• Design and execute data quality checks, reconciliations and validation controls.
• Validate source-to-target mappings and transformation requirements.
• Support data governance activities, standards and metadata management practices.
• Investigate and resolve data quality issues across multiple source systems.

Technical Delivery

• Translate business requirements into effective data solutions.
• Contribute to the design and delivery of data products and analytical services.
• Collaborate with technical and business teams to ensure data products are fit for purpose and aligned to organisational objectives.

About You

Essential Experience & Skills

• 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.

Desirable Skills

• Python or PySpark.
• Databricks.
• Azure Data Factory.
• Power BI semantic modelling.
• Data testing and quality assurance frameworks.
• Experience working within a Data Mesh or Data Product operating model.

Compensation And 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

At Gallagher, we are dedicated to building an inclusive and authentic workplace. If your past experience doesn’t align perfectly, we encourage you to join our Talent Community to stay connected to additional career opportunities. Although this role is listed as full‑time, if you’re in a job‑share partnership, work reduced hours, or have any other flexible arrangement, please still get in touch. We will also offer reasonable adjustments to the recruitment process if required, so please let us know.

Gallagher is an affirmative action/equal opportunity employer (Minorities/Females/Veterans/Disabled)