Data Analyst - P&C

A Data Analyst in Property & Casualty insurance focuses on analyzing policy, claims, underwriting, and loss data to support risk assessment, pricing, profitability, and regulatory reporting. Key Responsibilities (P&C-specific) • Analyze policy, premium, claims, and loss data across lines like Auto, Home, Workers’ Comp, Liability • Perform loss ratio, combined ratio, and profitability analysis • Support underwriting with risk insights and trend analysis • Analyze claims severity & frequency, leakage, and fraud indicators • Build dashboards for claims performance, exposure, reserves, and renewals • Work with actuarial and underwriting teams to validate assumptions • Ensure data quality and reconciliation across policy admin & claims systems • Support regulatory and compliance reporting (state filings, audits) • Identify trends impacting pricing, retention, and risk exposure Core Skills Required Technical • SQL (strong – joins, CTEs, window functions) • Python / R (pandas, NumPy for analysis) • Excel (advanced formulas, pivots) • BI Tools: Power BI / Tableau • Data modeling & data validation