What are the responsibilities and job description for the Data Analyst - P&C position at Wall Street Consulting Services LLC?
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