Role Summary
Loading...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
