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

Lloyd’s is the world’s leading insurance and reinsurance marketplace. We share the collective intelligence and risk sharing expertise of the market’s brightest minds, working together for a braver world. 

Our role is to inspire courage, so tomorrow’s progress isn’t limited by today’s risks.  

Our shared values: we are brave; we are stronger together; we do the right thing; guide what we do and how we act. If you share our values and our passion to build a future that’s more sustainable, resilient and inclusive, you’ll find a home at Lloyd’s – build a braver future with us. 

Catastrophe risk is a major driver within the Lloyd’s market and continues to evolve at pace; Exposure Management & Aggregation is focusing throughout 2025 on ensuring the market adequately captures and models non-peak catastrophe risk in the Lloyd’s Catastrophe Model.

You will need to be an analytical problem-solver looking to make a positive impact, inspired by developing the data and tools that drive the market’s understanding and control of catastrophe risk and use of outwards reinsurance.

You will continue to develop the skills and knowledge to become a technical expert, collating and analysing data from syndicates to enable effective catastrophe risk oversight across the Lloyd’s market.  You will need to be a solution-driven individual, with problem-solving and technical programming skills, an interest in catastrophe risk and exposure management and the curiosity to learn more about how statistical data influences the Lloyd’s market catastrophe risk strategy.  

A degree in a numerate or natural science subject and demonstrable experience of solving complex statistical problems, analysis and coding is required.  Whilst open minded to any quantitative background or data science aspirations within (re)insurance, catastrophe modelling, risk analytics or capital modelling knowledge would be hugely advantageous.  SQL skills and comfort with programming language such as R or Python is essential.  Any prior experience in the following would be beneficial and/or developed in the role; Excel/VBA, Tyche/Igloo/Remetrica, R Shiny, Qlik or PowerBI.

#LI-MARKETS  #LI-HYBRID

Diversity and inclusion are a focus for us – Lloyd’s aim is to build a diverse, inclusive environment that reflects the global markets we work in.  One where everyone is treated with dignity and respect to achieve their full potential. In practice, this means we are positive and inclusive about making workplace adjustments, we offer regular health and wellbeing programmes, diversity and inclusion training, employee networks, mentoring and volunteering opportunities as well as investment into your professional development. You can read more about diversity and inclusion on our website. 

We understand that our work/life balance is important to us all and that a hybrid of working from the office and home can offer a great level of flexibility.  Flexible working forms part of a total reward approach which offers a host of other benefits over and above the standard offering (generous pension, healthcare, wellbeing etc).  These include financial support for training, education & development, a benefit allowance (to spend on our flexible benefits such as gym membership, dental insurance, extra holiday or to partake in our cycle to work scheme), employee recognition scheme and various employee discount schemes.  

By choosing Lloyd's, you'll be part of a team that brings together the best minds in the industry, and together with our underwriters and brokers, we create innovative, responsive solutions allowing us to share risk and solve complex problems. 

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

https://cleartalents.com/apply/lloyds-msa1645695881

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