Data Analyst/Engineer - Casualty Analytics

Gallagher; City Of London; Hybrid; GBP 60,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 is seeking a talented Data Analyst/Engineer to join the Casualty Analytics team in London. You’ll specialize in data solutions supporting complex reinsurance placements and work with actuaries to deliver scalable processes and high-quality data products.

You will build pipelines, implement data quality controls, and create dashboards to compare portfolios across clients and time periods. The role is hybrid with three days in the office.

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, focusing on technical data pipelining and analysis in the insurance industry.
• Exposure to reinsurance, in particular casualty lines, is advantageous.
• Excellent Python skills with production-quality experience using pandas and related libraries for data cleansing, transformation and automation.
• Experience with Git and collaborative development workflows.
• Strong SQL with designing relational database schemas and building data stores.
• Proven ability to work with large, messy, inconsistently structured datasets and make them analysis-ready.
• Experience designing automated data quality checks and controls.
• Advanced Excel and Power Query skills, with data visualization in Power BI.
• Excellent problem-solving and communication skills.
• Knowledge of data governance frameworks and GDPR compliance.
• Must have the right to work in the UK.

Responsibilities

• Collaborate with brokers and clients to understand data requirements and provide data-driven insights for reinsurance placements.
• Utilize advanced data analysis techniques and visualization tools to analyze large datasets and provide insights on market trends, claims experience, loss ratios, and KPIs.
• Design, build and optimize Python data pipelines to ingest, cleanse, transform and standardize datasets from multiple sources using VS Code and GitHub.
• 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 across clients, classes and time periods.
• Stay at the forefront of industry trends in data analysis, visualization, data engineering and AI.
• Identify and deliver opportunities to automate and streamline existing manual processes.

Skills

Python

SQL

Excel

Power BI

Power Query

Data governance

GDPR

Communication

Problem solving

Data pipelines

Education

Bachelor’s degree in data science / computer science / statistics / mathematics or similar

Tools

Git

GitHub

VS Code

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