Technical Data Analyst

Arthur J. Gallagher & Co.; Greater London; Hybrid; GBP 42,000 - 64,000; Full time

Benefits offered by this job

Competitive compensation

Comprehensive benefits

Career development opportunities

Collaborative culture

Global reach with local impact

Job summary

Gallagher is seeking an experienced Technical Data Analyst to join its Data Technology team in London. You will analyse complex insurance datasets, develop robust data models, and ensure trusted datasets are delivered on a modern cloud data platform.

You will work with Data Engineers, Architects, and Product Owners to translate business requirements into scalable data solutions, using SQL, Snowflake, and dbt, with hybrid working 3 days in London.

Qualifications

• Two years of data analytics experience in insurance preferred.
• Strong SQL writing and data modelling skills.
• Experience reconciling data between source and target systems.
• Knowledge of data warehousing concepts and data governance.

Responsibilities

• Analyse complex insurance datasets across policy, claims, underwriting, finance and regulatory domains.
• Develop logical and physical data models to support reporting and analytics.
• Translate business requirements into scalable data solutions.
• Collaborate with Data Engineers to improve data platform performance.

Skills

SQL proficiency

Data modelling

ETL understanding

Problem solving

Data lineage

Policy/Claims data knowledge

Excel

Analytical thinking

Tools

Snowflake

DBT

SSIS

PowerBI

Excel

Job description

Introduction

Welcome to Gallagher - a global community of people who bring bold ideas, deep expertise, and a shared commitment to doing what’s right. We help clients navigate complexity with confidence by empowering businesses, communities, and individuals to thrive. At Gallagher, you’ll find more than a job; you’ll find a culture built on trust, driven by collaboration, and sustained by the belief that we’re better together. Whether you join us in a client-facing role or as part of our brokerage division, our benefits and HR consulting division, or our corporate team, you’ll have the opportunity to grow your career, make an impact, and be part of something bigger. Experience a workplace where you’re encouraged to be yourself, supported to succeed, and inspired to keep learning. That’s what it means to live The Gallagher Way.

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 so would suit a data professional who has two-years experience and is looking to take the next step in their career. 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.
• Source to target mapping experience and advanced SQL writing ability
• Technical ability to reconcile data between source and target data sets using SQL and or Excel
• Problem solving ability to trace data discrepancies back to source to identify root cause
• Ability to trace data flows through data structures using various ETL toolsets including SQL, SSIS, PowerBI, Snowflake, DBT to define data lineage
• Previous experience and an understanding of Policy / Claims data elements would be a preference.
• Knowledge of data warehouse principles i.e. Dimensional modelling, Kimbal, Start Schemas, incremental loading, master data management etc
• Understanding and ability to profile data and identify Data Quality issues
• Requirements gathering and analysis skills

Compensation and benefits

At Gallagher, we believe supporting our colleagues goes far beyond the role itself.For more information, visit our Benefits page.

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