Actuarial Data Analyst
Core
Actuarial Data Analyst supporting commercial P&C insurance product analysis, ratemaking, and competitive intelligence for high-hazard industries.
Role type
Mid-level actuarial data analyst (commercial P&C)
Builds
Commercial insurance rating plans, regulatory filings, and portfolio performance dashboards
Domain
Commercial Property & Casualty Insurance
Deliverable
production ML models | dashboards & analysis | client delivery
Required skills
Commercial P&C insurance product analysis, SQL (PostgreSQL), SERFF system navigation, spreadsheet modeling, regulatory filing processes, loss ratio analysis, competitor analysis
Preferred skills
Actuarial exams (P, FM, MAS-I, MAS-II, 5), Python, dbt, Metabase
Technologies
PostgreSQL, SERFF, Metabase, dbt, ISO manuals, NCCI data
Responsibilities
Develop and implement rating plans for state filings; Conduct competitor analysis of rate and form filings; Perform loss ratio analysis by line of business and territory; Write SQL queries to extract and analyze premium and loss data; Create interactive BI dashboards for product performance metrics; Support workers' compensation statistical reporting obligations
Seniority
Mid-level, hands-on IC