Actuarial Data Analyst

Actuarial Analyst – Commercial P&C

We are seeking a detail-oriented and analytical Actuarial Analyst to support multiple commercial lines of business, including General Liability, Workers' Compensation, Commercial Property, and Excess Casualty.

• Assist in the development, pricing, and implementation of rating plans for filing with state Departments of Insurance
• Support the Compliance team in the preparation, documentation, and submission of rate and form filings
• Conduct comprehensive competitor analysis of rate and form filings across all commercial lines, utilizing SERFF, S&P Capital IQ Pro, and other regulatory databases to identify market trends and competitive positioning
• Analyze filings, rate manuals, underwriting guidelines, and coverage forms from industry resources including ISO manuals and NCCI data to develop detailed benchmarks and strategic recommendations
• Research and draft comprehensive responses to rate-related objections, ensuring actuarial justification is provided
• Perform loss ratio analysis by line of business, territory, and risk characteristics to identify profitable segments and areas of concern
• Develop and maintain reporting requirements, including bordereaux and portfolio reporting, coordinating with internal teams and external partners on data accuracy and timely delivery
• Support workers’ compensation statistical reporting obligations, including WCSTAT and WCPOLS
• Write SQL queries to extract and analyze data related to premium volumes, loss ratios, exposure metrics, and rate change impacts from internal Postgre
  
  SQL databases
• Create interactive BI dashboards using Metabase or similar platforms to track key product performance metrics
• Support data transformation processes using dbt for analytics and reporting workflows

• 2-5 years of experience in commercial P&C insurance product analysis, actuarial, or competitive analysis functions
• Bachelor’s degree in Mathematics, Statistics, Economics, Finance, or related analytical field
• Demonstrated experience with commercial insurance products and insurance data analytics
• Actuarial exams such as P, FM, MAS-I, MAS-II, 5 (preferred but not required)

• Advanced SQL proficiency for data extraction, manipulation, and analysis from Postgre
  
  SQL databases
• SERFF system knowledge including navigation, filing preparation, and objection response processes
• Advanced spreadsheet modeling skills
• Experience with industry databases and tools including ISO manuals, NCCI data, and regulatory research platforms
• Python experience for advanced analytics (preferred but not required)

• Competitive salary ranging from $110,000 - $140,000 based on experience and qualifications
• Equity participation with significant upside potential
• Comprehensive benefits package including health, dental, vision, and 401(k) with company match
• Professional development opportunities including conference attendance and certification support
• Collaborative startup environment with opportunities for rapid career growth and expanded responsibilities