Shepherd
Actuarial Analyst - Commercial Lines
Shepherd, San Francisco, California, United States, 94199
Overview
Actuarial Analyst - Commercial Lines at Shepherd. Role supporting multiple commercial lines of business, including General Liability, Workers' Compensation, Inland Marine, and Excess Casualty. The position focuses on executing rigorous insurance analysis, cross-functional collaboration, and delivering precise, actionable insights to drive competitive advantage. Base pay range: $110,000.00/yr - $140,000.00/yr Responsibilities
Data Analytics & Performance Monitoring (50%) Write SQL queries to extract and analyze data related to premium volumes, loss ratios, exposure metrics, and rate change impacts from internal PostgreSQL databases Develop and maintain spreadsheet-based models for competitive analysis and rate monitoring 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 Conduct analytical work including rating factor impact analysis, product performance summaries, and segmentation studies to support product design and optimization Perform loss ratio analysis by line of business, territory, and risk characteristics to identify profitable segments and areas of concern Support actuarial and underwriting teams with data extraction and analysis for pricing studies and rate filings Competitive Intelligence & Market Analysis (50%) 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 track competitor product launches, rate changes, and form modifications to inform product development and pricing strategies Prepare competitive analysis reports with recommendations for product enhancements, rate adjustments, and market positioning Research and draft comprehensive responses to rate-related objections, ensuring actuarial justification is provided Qualifications
Experience & Education 2-5 years of experience in commercial insurance product analysis, actuarial, underwriting, 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) Technical Skills 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 Python experience for advanced analytics (preferred but not required) Insurance Knowledge 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 Core Competencies Strong analytical and critical thinking skills with ability to translate data into insights and recommendations Exceptional attention to detail and accuracy, especially for time-sensitive regulatory deliverables Clear communication skills for both technical and non-technical audiences Cross-functional collaboration experience working with actuarial, underwriting, compliance, and product management teams Benefits
Premium Healthcare
— 100% contribution to top-tier health, dental, and vision Unlimited PTO
— Flexibility to take time off, recharge, and perform Daily lunches, dinners, and snacks
— We work together, and enjoy meals together too SF, NYC, or Dallas-Fort Worth Offices
— Premium office spaces with daily lunches provided Professional Development
— Access to premium coaching, including leadership development 401(k) Plan
— Competitive 401(k) plan offered Dog-friendly office
— Plenty of dogs to play with in the SF office Compensation Range: $110K - $140K Additional Details
Seniority level: Mid-Senior level Employment type: Full-time Job function: Finance and Sales Industries: Insurance We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Actuarial Analyst - Commercial Lines at Shepherd. Role supporting multiple commercial lines of business, including General Liability, Workers' Compensation, Inland Marine, and Excess Casualty. The position focuses on executing rigorous insurance analysis, cross-functional collaboration, and delivering precise, actionable insights to drive competitive advantage. Base pay range: $110,000.00/yr - $140,000.00/yr Responsibilities
Data Analytics & Performance Monitoring (50%) Write SQL queries to extract and analyze data related to premium volumes, loss ratios, exposure metrics, and rate change impacts from internal PostgreSQL databases Develop and maintain spreadsheet-based models for competitive analysis and rate monitoring 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 Conduct analytical work including rating factor impact analysis, product performance summaries, and segmentation studies to support product design and optimization Perform loss ratio analysis by line of business, territory, and risk characteristics to identify profitable segments and areas of concern Support actuarial and underwriting teams with data extraction and analysis for pricing studies and rate filings Competitive Intelligence & Market Analysis (50%) 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 track competitor product launches, rate changes, and form modifications to inform product development and pricing strategies Prepare competitive analysis reports with recommendations for product enhancements, rate adjustments, and market positioning Research and draft comprehensive responses to rate-related objections, ensuring actuarial justification is provided Qualifications
Experience & Education 2-5 years of experience in commercial insurance product analysis, actuarial, underwriting, 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) Technical Skills 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 Python experience for advanced analytics (preferred but not required) Insurance Knowledge 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 Core Competencies Strong analytical and critical thinking skills with ability to translate data into insights and recommendations Exceptional attention to detail and accuracy, especially for time-sensitive regulatory deliverables Clear communication skills for both technical and non-technical audiences Cross-functional collaboration experience working with actuarial, underwriting, compliance, and product management teams Benefits
Premium Healthcare
— 100% contribution to top-tier health, dental, and vision Unlimited PTO
— Flexibility to take time off, recharge, and perform Daily lunches, dinners, and snacks
— We work together, and enjoy meals together too SF, NYC, or Dallas-Fort Worth Offices
— Premium office spaces with daily lunches provided Professional Development
— Access to premium coaching, including leadership development 401(k) Plan
— Competitive 401(k) plan offered Dog-friendly office
— Plenty of dogs to play with in the SF office Compensation Range: $110K - $140K Additional Details
Seniority level: Mid-Senior level Employment type: Full-time Job function: Finance and Sales Industries: Insurance We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr