Exposure Aggregation Analyst
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