Data Analyst/Engineer - Casualty Analytics

Arthur J. Gallagher & Co. (AJG); Greater London; Hybrid; GBP 65,000 - 90,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 Re in London is seeking a talented Data Analyst/Engineer to join the Casualty Analytics team. You will become the team's dedicated data specialist, working with actuaries to deliver high-quality data solutions that support complex reinsurance placements for clients worldwide.

Based in London with a hybrid model, you will manage data requests, develop scalable data processes, improve data quality, and unlock deeper insights.

Qualifications

• Bachelor’s degree in data science, computer science, statistics, mathematics or a similarly quantitative, technical subject.
• Proven experience in a data analyst/engineering role, with a focus on technical data pipelining and analysis in the insurance industry.
• Exposure to reinsurance, in particular casualty lines, would be a distinct advantage.
• Excellent Python skills, with demonstrable, production-quality experience using pandas and related libraries for data cleansing, transformation and automation.
• Experience with Git and collaborative development workflows.
• Strong SQL, with practical experience of designing relational database schemas and building and maintaining data stores.
• A proven track record of working with large, messy, inconsistently structured datasets and making them analysis-ready.
• Experience designing and implementing automated data quality checks and controls.
• Advanced Excel and Power Query skills, with data visualisation experience in Power BI.
• Excellent problem-solving and critical-thinking skills.
• Strong communication skills with the ability to present complex data insights to non-technical stakeholders.
• Knowledge of data governance frameworks and regulatory compliance, including GDPR.
• Must have the right to work in the UK.

Responsibilities

• Collaborate with brokers and clients to understand data requirements and provide data-driven insights to support reinsurance placements.
• Utilise advanced data analysis techniques and visualisation tools to analyse large and complex datasets, providing insights on market trends, claims experience, loss ratios and other key performance indicators.
• Design, build and optimise Python data pipelines to ingest, cleanse, transform and standardise datasets from multiple external sources, leveraging VS Code, GitHub version control and modern development practices to deliver efficient, repeatable and auditable data processing and analysis.
• Develop and implement robust data quality checks and controls to ensure data accuracy and completeness.
• Lead the development of a central casualty exposure and claims database, including schema design.
• Design and implement analytical tools, dashboards and benchmarking datasets that compare portfolios consistently across clients, classes and time periods.
• Stay at the forefront of industry trends and emerging technologies in data analysis, visualisation, data engineering and AI.
• Identify and deliver opportunities to automate and streamline existing manual processes.

Skills

Python

SQL

Git

Power BI

Excel

Power Query

Pandas

Data pipelines

GDPR

Data governance

Education

Bachelor’s degree in data science, computer science, statistics, mathematics

Tools

VS Code

GitHub

Job description

Introduction

At Gallagher Re, we bring clarity to complexity by helping clients around the world make confident, data-driven decisions in a rapidly evolving risk landscape. Here, you’ll be part of a team that leverages world-class analytics and deep reinsurance expertise to deliver strategic advisory services and transactional excellence. Together, we transform advanced insights and market intelligence into strategies that protect businesses, drive performance, and shape the future of reinsurance. We’re a community of decision makers, future shapers, and trusted experts working side by side to deliver meaningful impact through innovative thinking and practical solutions. At Gallagher Re, your curiosity is welcomed, your growth is championed, and your work truly matters. This is a place where you'll have the freedom to explore new ideas, take ownership of your career, and collaborate with people who are as driven and inquisitive as you are.

Overview

We are seeking a talented Data Analyst/Engineer to join our Casualty Analytics team at Gallagher Re. This is a unique opportunity to become the team's dedicated data specialist, working closely with actuaries to deliver high-quality data solutions that support complex reinsurance placements for clients worldwide.

As a standalone role, you will be responsible for managing and responding to a wide range of data requests while also driving the evolution of the team's data capabilities, helping to develop scalable processes, improve data quality, and unlock deeper analytical insights.

The role will be based in London and we offer hybrid working with an expectation of being in the office three days a week.

How you'll make an impact

• Collaborate with brokers and clients to understand data requirements and provide data-driven insights to support reinsurance placements.
• Utilise advanced data analysis techniques and visualisation tools to analyse large and complex datasets, providing insights on market trends, claims experience, loss ratios and other key performance indicators.
• Design, build and optimise Python data pipelines to ingest, cleanse, transform and standardise datasets from multiple external sources, leveraging VS Code, GitHub version control and modern development practices to deliver efficient, repeatable and auditable data processing and analysis.
• Develop and implement robust data quality checks and controls to ensure data accuracy and completeness.
• Lead the development of a central casualty exposure and claims database, including schema design.
• Design and implement analytical tools, dashboards and benchmarking datasets that compare portfolios consistently across clients, classes and time periods.
• Stay at the forefront of industry trends and emerging technologies in data analysis, visualisation, data engineering and AI.
• Identify and deliver opportunities to automate and streamline existing manual processes.

About You

• Bachelor’s degree in data science, computer science, statistics, mathematics or a similarly quantitative, technical subject.
• Proven experience in a data analyst/engineering role, with a focus on technical data pipelining and analysis in the insurance industry.
• Exposure to reinsurance, in particular casualty lines, would be a distinct advantage.
• Excellent Python skills, with demonstrable, production-quality experience using pandas and related libraries for data cleansing, transformation and automation.
• Experience with Git and collaborative development workflows.
• Strong SQL, with practical experience of designing relational database schemas and building and maintaining data stores.
• A proven track record of working with large, messy, inconsistently structured datasets and making them analysis-ready.
• Experience designing and implementing automated data quality checks and controls.
• Advanced Excel and Power Query skills, with data visualisation experience in Power BI.
• Excellent problem-solving and critical-thinking skills.
• Strong communication skills with the ability to present complex data insights to non-technical stakeholders.
• Knowledge of data governance frameworks and regulatory compliance, including GDPR.
• Must have the right to work in the UK.

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 our Talent Community to stay connected to additional career opportunities.

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