Senior Data Analyst - Reinsurance SQL Power BI Azure

Salary: £65,000 - 105,000 per year

Requirements:

• Proven experience as a Data Analyst or Senior Data Analyst within the (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.
• Strong 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.

Responsibilities:

• 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.

Technologies:

• Azure
• Cloud
• Support
• Power BI
• SQL

More:

At Gallagher Re, we help clients around the world make confident, data-driven decisions in a rapidly evolving risk landscape. We are a community of decision makers, future shapers, and trusted experts working side by side to deliver strategic advisory services and transactional excellence. This Senior Data Analyst role sits within our growing data and analytics team and offers the opportunity to work closely with underwriting, operations, claims, and finance stakeholders. We offer flexible/hybrid working, with an expectation to be in our London City office twice a week, along with competitive compensation, comprehensive benefits, career development opportunities, ongoing learning, and a collaborative, people-first culture with accessible leadership. We are committed to building an inclusive and authentic workplace and support flexible working arrangements and reasonable adjustments during the recruitment process.

last updated 36 week of 2026