Role Summary

HIGHLIGHTS

P&C-focused data analyst role supporting Keenan (Gallagher) in Torrance, CA or remote. You'll prepare, map, and reconcile policy, claims, and financial data, build reports and dashboards, and support underwriting, pricing and reserving models. Role emphasizes SQL, Power BI, and Excel and is suited to candidates with ~2+ years' data analyst experience.

JOB DESCRIPTION SUMMARY

Support underwriting, pricing, and reserving with policy, claims, and financial data
Build reports and dashboards using SQL, Power BI, and Excel
Analyze treaty and claims coding and track P&C KPIs like loss ratios
Automate data extraction and reporting processes for underwriting teams
Associate-level role; remote work flexibility with Torrance, CA location

DOMAIN EXPERTISE

Policy, claims, and financial data analysis
P&C underwriting and claims coding
Treaty data analysis
Data preparation for pricing and reserving models

KEY REQUIREMENTS

Minimum 2 years' experience in a data analyst role or equivalent
Proficiency with SQL, Power BI, and Excel required
Experience with policy, claims, and financial data for underwriting/reporting
Bachelor's degree in CS, Mathematics preferred or equivalent experience
Eligible to work in the U.S. (see company U.S. eligibility requirements)

TECH STACK

Excel
Power_BI
Tableau
PowerPoint

Role Summary

HIGHLIGHTS

JOB DESCRIPTION SUMMARY

Support underwriting, pricing, and reserving with policy, claims, and financial data
Build reports and dashboards using SQL, Power BI, and Excel
Analyze treaty and claims coding and track P&C KPIs like loss ratios
Automate data extraction and reporting processes for underwriting teams
Associate-level role; remote work flexibility with Torrance, CA location