Senior Data Analyst-(Re)Insurance- SQL, Power BI, Azure technologies

Gallagher Re; Greater London; Hybrid; GBP 70,000 - 100,000; Full time

Benefits offered by this job

Competitive compensation

Career development opportunities

Job summary

Gallagher Re is seeking a Senior Data Analyst to join our growing data and analytics team in London. You will collaborate with underwriting, operations, claims and finance to deliver actionable insights that drive performance and strategic decision-making.

You will work with Bordereaux and Delegated Authority data, transform complex data into meaningful analysis, and develop reporting solutions that improve efficiency and outcomes. Hybrid working with London City office twice a week is expected.

Qualifications

• Proven experience as a Data Analyst in (Re)Insurance.
• Knowledge of Bordereaux and Delegated Authority data.
• Advanced SQL skills with ability to write, troubleshoot and optimise queries.
• Experience developing reports and dashboards using Power BI.
• Experience with Azure Data Lake and cloud-based data environments.
• Experience in London Market insurance environment.

Responsibilities

• Analyse and interpret large, complex datasets to provide insights and recommendations.
• Work with Delegated Authority and Bordereaux data ensuring accuracy and regulatory compliance.
• Develop and maintain dashboards, reports, and visualisations using Power BI.
• Write and optimise complex SQL queries to extract data from multiple sources.
• Support development of data models, reporting frameworks, and analytical solutions.
• Collaborate with underwriting, actuarial, finance and operations to deliver data-driven solutions.
• Work with Azure-based data platforms to support modern data architecture.
• Identify data quality issues and implement controls to enhance integrity.
• Provide SME on (Re)Insurance data structures and reporting requirements.

Skills

Analytical thinking

Stakeholder management

Problem solving

Tools

Power BI

SQL

Azure Data Lake

Azure Synapse

Azure Data Factory

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.

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 highly skilled Senior Data Analyst to join our growing data and analytics team. This role offers the opportunity to work closely with underwriting, operations, claims, and finance stakeholders to deliver actionable insights that support business performance and strategic decision-making.

The successful candidate will bring proven experience in the (Re)Insurance market, with hands‑on experience working with Bordereaux and Delegated Authority data. You will play a key role in transforming complex data into meaningful analysis, improving data quality, and developing reporting solutions that drive operational efficiency and commercial outcomes. Previoious experience and knowldge of working with Data & Analytics in the insurannce industry is essential to be successful in this role.

We offer flexible/hybrid working and you will be expected in our London City office twice a week.

How You'll Make An Impact

• Analyse and interpret large, complex datasets to provide business-critical insights and recommendations.
• Work with Delegated Authority and Bordereaux data, ensuring accuracy, completeness, and regulatory compliance.
• Develop and maintain dashboards, reports, and visualisations using Power BI.
• Write and optimise complex SQL queries to extract, transform, and analyse data from multiple sources.
• Support the development and enhancement of data models, reporting frameworks, and analytical solutions.
• Collaborate with underwriting, actuarial, finance, and operational teams to understand business requirements and deliver data‑driven solutions.
• Work with cloud‑based data platforms, including Azure Data Lake, to support modern data architecture and analytics capabilities.
• Identify data quality issues and implement controls and improvements to enhance data integrity.
• Provide subject matter expertise on (Re)Insurance data structures, reporting requirements, and market best practices.

About You

• Proven experience as a Data Analyst or Senior Data Analyst within (Re)Insurance market is essential.
• Extensive knowledge of Bordereaux and Delegated Authority business processes and datasets.
• Advanced SQL skills with the ability to write, troubleshoot, and optimise complex queries.
• Hands‑on experience developing reports and dashboards using Power BI.
• Experience working with Azure Data Lake and cloud‑based data environments.
• Fantastic analytical, problem‑solving, and data visualisation skills.
• Excellent stakeholder management and communication abilities.
• Experience translating business requirements into meaningful analytical solutions.
• Experience within the London Market insurance environment.
• Knowledge of data governance, data quality, or master data management principles.
• Exposure to Azure Synapse, Data Factory, or other Azure analytics services.
• Understanding of underwriting, claims, exposure management, or reinsurance reporting processes.

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)