Actuarial Data Analyst

The role

You will perform ratemaking, competitive intelligence, actuarial reporting, and data analytics. You will support commercial lines including General Liability, Workers' Compensation, Commercial Property, and Excess Casualty.

What you will do

• 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
• Analyze filings, rate manuals, underwriting guidelines, and coverage forms to develop benchmarks and strategic recommendations
• Research and draft comprehensive responses to rate-related objections
• Perform loss ratio analysis by line of business, territory, and risk characteristics
• Develop and maintain reporting requirements, including bordereaux and portfolio reporting
• Support workers’ compensation statistical reporting obligations, including WCSTAT and WCPOLS
• Write SQL queries to extract and analyze data from internal PostgreSQL databases
• Create interactive BI dashboards using Metabase or similar platforms

Required qualifications

• 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
• Advanced SQL proficiency for data extraction, manipulation, and analysis from PostgreSQL databases
• SERFF system knowledge including navigation, filing preparation, and objection response processes
• Advanced spreadsheet modeling skills for financial analysis and data manipulation
• Experience with industry databases and tools including ISO manuals, NCCI data, and regulatory research platforms
• Understanding of commercial insurance products including rating methodologies and underwriting guidelines
• Knowledge of state insurance filings process
• Understanding of ISO forms, NCCI guidelines, and industry standard practices
• Understanding of actuarial concepts including loss development, rate adequacy, and predictive modeling principles
• Strong analytical and critical thinking skills

Nice to have

• Actuarial exams such as P, FM, MAS-I, MAS-II, 5
• Python experience for advanced analytics

Benefits

• 100% contribution to health, dental, and vision
• Fertility benefits and family building support
• Flexible PTO
• Daily lunches, dinners, and snacks
• Professional development opportunities including conference attendance and certification support
• Premium coaching, including leadership development
• Competitive 401(k) Plan with company match
• Dog-friendly office

About the company

Shepherd is rebuilding commercial insurance with software, data, AI, and deep underwriting expertise. The company develops insurance products and partners with established insurers to back coverage.