Senior Data Analyst-(Re)Insurance- SQL, Power BI, Azure technologies
Gallagher London, United KingdomSenior Data Analyst-(Re)Insurance- SQL, Power BI, Azure technologies
Gallagher London, United Kingdom
Senior Data Analyst-(Re)Insurance- SQL, Power BI, Azure technologies
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.
We offer flexible/hybrid working and you will be expected in our London City office twice a week.
How you'll make an impact
About you
Compensation and benefits
On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits.
Below are the minimum core benefits you'll get, depending on your job level these benefits may improve:
Other benefits include:
We value inclusion and diversity
Inclusion and diversity (I&D) is a core part of our business, and it's embedded into the fabric of our organisation. For more than 95 years, Gallagher has led with a commitment to sustainability and to support the communities where we live and work.
Gallagher embraces our employees' diverse identities, experiences and talents, allowing us to better serve our clients and communities. We see inclusion as a conscious commitment and diversity as a vital strength. By embracing diversity in all its forms, we live out The Gallagher Way to its fullest.
Gallagher is Disability Confident Committed. We have pledged to make sure our recruitment process is inclusive and accessible, in addition to supporting our existing employees with any long-term health conditions or disabilities.
We understand that applicants may have disabilities, if you do, you may find some parts of the recruitment process more challenging than others. Don't worry, we're here to help, however, we can only do this if you let us know.
Should you require reasonable adjustments to your application, please get in touch with TAGlobalSupport@ajg.com . If you'd prefer to speak on the phone, please request a call back, leaving details, so we get in touch.
Our employing entity, Arthur J. Gallagher Services (UK) Limited, is proud to be accredited as a Living Wage employer with the Living Wage Foundation. We are committed to diversity and opportunity for all and are opposed to any form of less favourable treatment on the grounds of gender or gender identity, marital status, civil partnership status, parental status, race, ethnicity, colour, nationality, disability, sexual orientation, religion/ belief, age and those with caring responsibilities.
Gallagher believes that all persons are entitled to equal employment opportunity and prohibits any form of discrimination by its managers, employees, vendors or customers based on race, color, religion, creed, gender (including pregnancy status), sexual orientation, gender identity (which includes transgender and other gender non-conforming individuals), gender expression, hair expression, marital status, parental status, age, national origin, ancestry, disability, medical condition, genetic information, veteran or military status, citizenship status, or any other characteristic protected (herein referred to as "protected characteristics") by applicable federal, state, or local laws.
Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. In addition, Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified person with a disability, unless the accommodation would impose an undue hardship on the operation of our business.
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.
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
On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits.
Below are the minimum core benefits you'll get, depending on your job level these benefits may improve:
- Minimum of 25 days holiday, plus bank holidays, and the option to 'buy' extra days
- Defined contribution pension scheme, which Gallagher will also contribute to
- Life insurance, which will pay 4x your basic annual salary, which you can top-up to 10x
- Income protection, we'll cover up to 50% of your annual income, with options to top up
- Health cash plan or Private medical insurance
Other benefits include:
- Three fully paid volunteering days per year
- Employee Stock Purchase plan, offering company shares at a discount
- Share incentive plan, HMRC approved, tax effective, stock purchase plan
- Critical illness cover
- Discounted gym membership, with over 3,000 gyms nationally
- Season ticket loan
- Access to a discounted voucher portal to save money on your weekly shop or next big purchase
- Emergency back-up family care
- And many more...
We value inclusion and diversity
Inclusion and diversity (I&D) is a core part of our business, and it's embedded into the fabric of our organisation. For more than 95 years, Gallagher has led with a commitment to sustainability and to support the communities where we live and work.
Gallagher embraces our employees' diverse identities, experiences and talents, allowing us to better serve our clients and communities. We see inclusion as a conscious commitment and diversity as a vital strength. By embracing diversity in all its forms, we live out The Gallagher Way to its fullest.
Gallagher is Disability Confident Committed. We have pledged to make sure our recruitment process is inclusive and accessible, in addition to supporting our existing employees with any long-term health conditions or disabilities.
We understand that applicants may have disabilities, if you do, you may find some parts of the recruitment process more challenging than others. Don't worry, we're here to help, however, we can only do this if you let us know.
Should you require reasonable adjustments to your application, please get in touch with TAGlobalSupport@ajg.com . If you'd prefer to speak on the phone, please request a call back, leaving details, so we get in touch.
Our employing entity, Arthur J. Gallagher Services (UK) Limited, is proud to be accredited as a Living Wage employer with the Living Wage Foundation. We are committed to diversity and opportunity for all and are opposed to any form of less favourable treatment on the grounds of gender or gender identity, marital status, civil partnership status, parental status, race, ethnicity, colour, nationality, disability, sexual orientation, religion/ belief, age and those with caring responsibilities.
Gallagher believes that all persons are entitled to equal employment opportunity and prohibits any form of discrimination by its managers, employees, vendors or customers based on race, color, religion, creed, gender (including pregnancy status), sexual orientation, gender identity (which includes transgender and other gender non-conforming individuals), gender expression, hair expression, marital status, parental status, age, national origin, ancestry, disability, medical condition, genetic information, veteran or military status, citizenship status, or any other characteristic protected (herein referred to as "protected characteristics") by applicable federal, state, or local laws.
Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. In addition, Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified person with a disability, unless the accommodation would impose an undue hardship on the operation of our business.
Job ID 55169
More Jobs From Gallagher
Gallagher
London, United Kingdom
Gallagher
London, United Kingdom
Gallagher
London, United Kingdom
Gallagher
London, United Kingdom
Gallagher
London, United Kingdom
Gallagher
Glasgow, United Kingdom
Boost your career
Find thousands of job opportunities by signing up to eFinancialCareers today.More Jobs Like This