(Re)Insurance Data Analyst

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.

Gallagher Re are looking to hire an experienced Insurance Analytics Data Analyst/Engineer to join our growing analytics team. This opportunity will play a critical role in delivering sophisticated data analysis to support the placement of insurance and reinsurance programs for our clients across various lines of business and territories.

Working as our Data Analyst you will be leveraging tools like SQL, DAX, and Power BI to analyse and visualise complex datasets, enabling data-driven decision-making. A significant aspect of the role includes working with bordereaux data, which entails managing and analysing detailed reports of insurance risks, premiums, and claims provided by coverholders or delegated authorities. This requires ensuring data accuracy, compliance, and alignment with reinsurance agreements.

By utilising SQL for data extraction, DAX for advanced calculations, and Power BI for creating insightful dashboards, analysts provide actionable insights that help optimise risk management, improve operational efficiency, and support strategic decision-making within the reinsurance ecosystem. This role will be based from our London office with an expectation of being on site two days per week.

How you’ll make an impact:

• Collaborate with brokers and external clients to understand data requirements and provide advanced data-driven insights to support insurance and 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.
• Previous experience working with Bordereau and Delegated Authority is essential and required for this role.
• Develop and optimise data pipelines using Microsoft Azure Data Factory and other Azure tools to ensure efficient data processing and analysis.
• Design and implement analytical tools and dashboards to support strategic data-driven decision-making across the organisation.
• Lead the development and implementation of robust data quality checks and controls to ensure data accuracy and completeness.
• Stay at the forefront of industry trends and emerging technologies in data analysis, visualisation, and data pipelining.
• Contribute to the development of bespoke client data models.

About You:

• Proven experience gained in an Analytics or Data Analyst/Engineering role, with a focus on technical data pipelining and analysis in the insurance or reinsurance industry is essential for this role.
• Experience of working with Bordereaux and Delegated Authority is essential for this position.
• Experience in data analysis and visualisation tools such as SQL, DAX, Power BI, SQL, Python, and Microsoft Excel.
• Extensive experience with Microsoft Azure toolkit, including data storage and analytics services such as Azure Data Lake, Azure Data Factory, and Azure Analysis Service would be an advantage.
• Knowledge of Tabular Modelling/Models would be advantageous.
• Excellent problem-solving skills and meticulous attention to detail.
• Excellent communication and presentation skills with the ability to convey complex technical concepts to non-technical audiences.
• Ability to work independently and manage multiple priorities in a fast-paced, deadline-driven environment.

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.

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.

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.