Gallagher
Senior Data Analyst-(Re)Insurance- SQL, Power BI, Azure technologies
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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. Previous experience and knowledge of working with Data & Analytics in the insurance industry is essential to be successful in this role.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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)
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location