Data Analyst - Casualty Analytics

Gallagher Re; Greater London; On-site; GBP 60,000 - 85,000; Full time

Benefits offered by this job

Competitive compensation

Comprehensive benefits

Career development

Collaborative culture

Flexible arrangements

Job summary

Gallagher Re is seeking an experienced Data Analyst to join the Casualty analytics team in London. The role involves delivering sophisticated data analysis to support reinsurance placements, building Python data pipelines, and delivering dashboards and benchmarks across client portfolios.

You will work with brokers and clients to understand data needs, ensure data quality, and collaborate across teams. Strong Python, SQL, Power BI and GDPR knowledge are essential for success.

Qualifications

• Bachelor’s degree in data science, computer science, statistics, mathematics or similar.
• Minimum of three years’ experience in a data analyst role with data pipelining and analysis in insurance.
• Experience with reinsurance casualty lines is a plus.
• Excellent Python skills with production-quality pandas usage for data cleansing and automation.
• Git and collaborative development workflows.
• Strong SQL and ability to design relational schemas and data stores.
• Proven ability to make large, messy datasets analysis-ready.
• Experience implementing automated data quality checks and controls.
• Advanced Excel and Power Query; Power BI data visualisation.
• Strong problem-solving, communication, and stakeholder presentation skills.
• Knowledge of GDPR and data governance; right to work in the UK.

Responsibilities

• Collaborate with brokers and clients to understand data requirements and provide insights.
• Utilise advanced data analysis and visualisation to assess market trends and KPI metrics.
• Design, build and optimise Python data pipelines for diverse data sources.
• Develop robust data quality checks to ensure accuracy.
• Lead development of central casualty exposure and claims database design.
• Create analytical tools, dashboards and benchmarks across portfolios and time.
• Keep abreast of data analytics, engineering and AI trends.
• Identify opportunities to automate manual processes.

Skills

Analytical thinking

Attention to detail

Communication

Problem solving

Education

Bachelor’s degree in data science / CS / statistics / math

Tools

Python

SQL

Power BI

Excel

Git

VS Code

pandas

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 looking for an experienced data analyst to join our Casualty analytics team.


• The successful candidate will play a critical role in delivering sophisticated data analysis to support the placement of reinsurance programmes for our clients.


• This role requires a strong understanding of data management principles, excellent analytical skills, and the ability to collaborate with cross-functional teams to support data-driven decision-making.

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.


• Minimum of three years’ experience in a data analyst role, with a strong 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.

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)