CareerPlan

Exposure Aggregation Analyst

Ebene, .Full-time2026-09-09 → 2026-11-16

Core

Maintain, improve, and report exposure aggregation and accumulation views across specialty insurance portfolios to ensure data accuracy and decision-usefulness.

Role type

Junior data analyst (insurance risk)

Builds

Exposure Management dashboards, monthly/ad hoc reports, and event response analysis packs

Domain

Insurance / Reinsurance / Risk Management

Deliverable

dashboards & analysis

Required skills

SQL, Power BI, Excel, data cleaning, data reconciliation, geocoding, numerical analysis, stakeholder communication

Preferred skills

Python, R, Tableau, database joins, automation

Technologies

Power BI, SQL, Excel, Python, R, Power Query, DAX

Responsibilities

Monitor exposure concentrations against appetite thresholds; maintain and enhance exposure dashboards; perform data quality checks on policy and location data; support data enrichment via geocoding and region mapping; produce exposure and RDS scenario reports; support live and post-event loss impact analysis; streamline reporting processes; collaborate with underwriting, actuarial, and IT teams.

Seniority

Junior, recent graduate or early-career