Lloyd's
Aggregation / Catastrophe Analyst - Excel VBA, R, Python, Qlik and/or Power BI
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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 Analyst
Make 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.
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.
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Being inclusive at Lloyd’s
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;
“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