Exposure Management Data Analyst

Exposure Management Data Analyst Insurance - London

Up to £74,000 plus benefits

SQL Power BI Python Exposure Management

This is an excellent opportunity for an Exposure Management-focused data professional to join a growing and strategically important Exposure Management (EM) function within a highly regarded London Market insurance business.

This is not a pure reporting or operational data role. We are specifically looking for someone who understands Exposure Management in practice - including the broader commercial, modelling and portfolio challenges associated with EM data - and can combine strategic thinking with hands-on delivery.

My client is investing heavily in strengthening underwriting insight, portfolio optimisation and catastrophe risk management capability. This role sits at the heart of that transformation, requiring someone who can move quickly, think critically, and translate complex EM data challenges into scalable, high-impact solutions.

You will work closely with Exposure Management, Catastrophe Modelling, Underwriting and Technology teams, acting as a key bridge between domain experts and data execution.

Key Responsibilities

• Partner directly with Exposure Management and Catastrophe Modelling teams to understand real-world portfolio and accumulation challenges

• Design and deliver scalable reporting and analytics solutions that improve underwriting insight and portfolio optimisation

• Build and enhance Power BI dashboards covering exposure, accumulations, data quality and portfolio risk metrics

• Develop and optimise SQL-based data models to support complex EM analytics

• Own end-to-end data pipelines, ensuring EM data flows are accurate, robust and fit for purpose

• Identify structural data issues within underwriting and modelling inputs - not just report on them, but help solve them

• Drive automation and efficiency across EM reporting and data processes

• Support strategic portfolio analysis and scenario insight beyond standard MI production

• Work at pace in a fast-moving London Market environment, responding to emerging portfolio and regulatory requirements

Skills and Experience

• Strong hands-on Exposure Management experience or demonstrable familiarity with EM frameworks, processes and outputs

• Understanding of catastrophe modelling workflows and portfolio risk metrics

• Ability to interpret EM data commercially - not just process it

• Proven track record of combining strategic thinking with practical execution

• Advanced SQL skills and strong Power BI capability

• Experience using Python for automation, data transformation and integration

• Experience working with insurance, London Market or Lloyd's exposure data

• Strong problem-solving mindset with the ability to work with incomplete or imperfect datasets

• Comfortable operating in a fast-paced, evolving environment

Desirable

• Experience with catastrophe modelling platforms such as AIR (Verisk), RMS or Touchstone

• Knowledge of Lloyd's/London Market reporting requirements

• Exposure to cloud-based data platforms

• Experience improving or redesigning EM data architecture

If this sounds like the role for you, hit APPLY & a consultant will be in touch.