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

  • Job Reference: AWDO-P12113
  • Date Posted: 17 April 2024
  • Recruiter: Lloyd's
  • Location: City of London / Hybrid
  • Remote Working: Hybrid - some remote working possible
  • Salary: On Application
  • Bonus/Benefits: Competitive + Benefits
  • Sector: Banking, Insurance & Financial Services, I.T. & Communications
  • Job Type: Permanent
  • Work Hours: Full Time
  • Contact: CV Response Team

Job Description

Aggregation Analyst - Excel VBA, R, Python, Qlik and / or Power BI Jobs, Careers & Vacancies in London / Hybrid Advertised by AWD online – Multi-Job Board Advertising and CV Sourcing Recruitment Services

Aggregation 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; with this in mind we have an additional headcount to join the Aggregation team in 2024.


As the Aggregation Analyst 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
  • 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. 


Requirements of the Aggregation Analyst

  • A degree in a numerate or natural science subject
  • Demonstrable experience of solving complex statistical problems analysis and coding is required
  • 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 comfortable 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




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.

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.




This job is being advertised by AWD online on behalf of Lloyd’s

Aggregation Analyst Jobs | Excel VBA | Qlik | Microsoft Power BI | SQL | R | Python | R Shiny | Tyche | Igloo | Remetrica | Quantitative | Data Science | Statistical Data | Catastrophe Modelling | Reinsurance | Lloyd’s