Aggregation / Catastrophe Analyst - Excel VBA, R, Python, Qlik and/or Power BI

Posted 4 Days Ago
Be an Early Applicant
London, England, GBR
In-Office
Mid level
Marketing Tech
The Role
Analyse catastrophe exposure and outwards reinsurance across Lloyd's syndicates, support in-house catastrophe model development, monitor and report market risk, benchmark exposures, assess reinsurance arrangements, and build analytical tools and data-driven solutions for stakeholders and regulators.
Summary Generated by Built In

Lloyd’s is the world’s leading insurance and reinsurance marketplace, bringing together the world’s leading risk takers to advance global progress.


Our strategy is focused on delivering strong underwriting performance, operating an efficient and flexible marketplace, and maximising the capital advantage of the Lloyd’s market — while continuing to build a Lloyd’s we are proud of.


How we deliver this, matters. We take the risk, make things happen, and own the outcome — working together across our global network to turn insight into impact.

Aggregation AnalystMake the market better. It starts with you.

At Lloyd's, we're the world's leading insurance and reinsurance marketplace. Every day, we bring together the expertise, insight and capital needed to help businesses, communities and economies recover from the unexpected.

We're looking for an Aggregation Analyst to join our Catastrophe Risk & Reinsurance Analytics team. This is an opportunity to work at the heart of the Lloyd's market, helping us understand and manage some of the most complex risks facing the global insurance industry.

You'll use data, analytics and technology to provide insight into catastrophe risk and reinsurance across the Lloyd's market. Your work will support business-critical decisions, influence market oversight and help strengthen the resilience of a marketplace trusted around the world.


What you'll do

You'll be part of the team responsible for analysing two of the market's most significant sources of aggregate risk: catastrophe exposure and outwards reinsurance. The insight you produce will be used by senior stakeholders across Lloyd's to support strategic decision-making.

Key responsibilities include:

  • Analysing exposure and catastrophe data from syndicates across the Lloyd's market.
  • Supporting the development and maintenance of Lloyd's in-house catastrophe model.
  • Monitoring and reporting on catastrophe risk at both syndicate and market level.
  • Producing internal and external risk reporting, including information for regulatory stakeholders.
  • Assessing outwards reinsurance arrangements and helping quantify the risks they present to the market.
  • Benchmarking syndicate exposures and identifying emerging trends.
  • Working with colleagues across Lloyd's to evaluate risk management practices and reinsurance strategies.
  • Supporting continuous improvement through innovative analytical tools, modelling techniques and data-driven solutions.

What we're looking for

We're interested in curious, analytical thinkers who enjoy solving complex problems and turning data into actionable insight.

You'll bring:

  • A degree in a numerate, scientific or related discipline, or equivalent experience solving complex analytical challenges.
  • Experience using statistical software and analytical techniques.
  • Strong coding and data analysis skills.
  • Working knowledge of SQL and R, or similar statistical programming tools.
  • Excellent problem-solving and investigative abilities.
  • The confidence to communicate complex information clearly to a range of audiences. [

Previous insurance experience is helpful, but not essential. If you have a strong analytical background and are excited by the opportunity to apply your skills in a unique and globally significant environment, we'd love to hear from you

Being inclusive at Lloyd’s is integral to how we work — and how we deliver impact.
We aim to build a diverse, inclusive environment that reflects the global markets we serve, where everyone is treated with dignity and respect and supported to reach their full potential.

We take the risk by challenging traditional thinking and being proactive about inclusion. That means being open and positive about workplace adjustments, prioritising health and wellbeing, and investing in diversity and inclusion training so everyone feels able to contribute and succeed.

We make things happen by turning our commitment into action. Through employee networks, mentoring, volunteering opportunities and sustained investment in professional development, we create an environment where inclusion is experienced day‑to‑day — not just talked about.

We own the outcome by focusing on impact. By bringing together diverse perspectives and the best minds in the industry, we work collaboratively with underwriters and brokers to create innovative, responsive solutions that share risk and solve complex problems across global markets.

Should you require any additional support with your application, or any adjustments, please click the following link;


https://urldefense.com/v3/__http:/ctir.cleartalents.com/apply/experiencedhires__;!!BHksnLxjsWnPVFM!Zw-sfFLbBNwtuHUIxAmJhLtq95RHC4LwVQ7lnk_w-3aFwpTfsLqE3qds0B5si5JOpqnfgYCoarWa3kTt1ET-Wfj94vZY_A$


Please note, clicking on this link does not register your application for the vacancy

Skills Required

  • Degree in a numerate, scientific or related discipline, or equivalent experience
  • Experience using statistical software and analytical techniques
  • Strong coding and data analysis skills (Excel VBA, R, Python)
  • Working knowledge of SQL and R, or similar statistical programming tools
  • Experience with Qlik and/or Power BI (data visualisation/dashboarding)
  • Experience or familiarity with catastrophe modelling and catastrophe exposure analysis
  • Excellent communication skills to explain complex information to varied audiences
  • Previous insurance experience
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: London
2,496 Employees
Year Founded: 1999

What We Do

Lloyd’s is the world’s leading marketplace for insurance and reinsurance. Through the collective intelligence and risk-sharing expertise of the market’s underwriters and brokers, Lloyd’s helps to create a braver world.

Similar Jobs

Wells Fargo Logo Wells Fargo

Software Engineer

Fintech • Financial Services
Hybrid
City of London, City and County of the City of London, England, GBR
205000 Employees
Hybrid
City of London, City and County of the City of London, England, GBR
205000 Employees

Wells Fargo Logo Wells Fargo

Principal Engineer

Fintech • Financial Services
Hybrid
City of London, City and County of the City of London, England, GBR
205000 Employees

Atlassian Logo Atlassian

Head of EMEA Sales, DX

Cloud • Information Technology • Productivity • Security • Software • App development • Automation
In-Office
London, Greater London, England, GBR
11000 Employees

Similar Companies Hiring

ClickMint Thumbnail
AdTech • eCommerce • Marketing Tech • Generative AI
Malibu, CA
9 Employees
PRIMA Thumbnail
Travel • Software • Marketing Tech • Hospitality • eCommerce
US
15 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account