ACTUARIAL DATA ANALYST

The Role We are seeking a detail-oriented and analytical Actuarial Analyst to join our actuarial team supporting multiple commercial lines of business, including General Liability, Workers' Compensation, Commercial Property, and Excess Casualty. This role is perfect for someone who thrives on executing rigorous insurance analysis, collaborating cross-functionally, and delivering precise, actionable insights that drive competitive advantage. Key Responsibilities Ratemaking & Competitive Intelligence (50%) 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 Actuarial Reporting & Portfolio Monitoring (25%) 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 Data Analytics (25%) Write SQL queries to extract and analyze data related to premium volumes, loss ratios, exposure metrics, and rate change impacts from internal PostgreSQL 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 Required Qualifications Experience & Education 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) 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 What We Offer Competitive salary ranging from $110,000 – $140,000 based on experience and qualifications Equity participation with significant upside potential in our growing organization 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 Benefits 100% contribution to top‑tier health, dental, and vision coverage Fertility benefits and family building support Unlimited PTO Daily lunches, dinners, and snacks – meals to share with colleagues Multiple office locations including SF, NYC, Dallas/Fort Worth, Chicago, and LA Professional development access including leadership coaching and premium coaching programs Competitive 401(k) plan with company match Dog‑friendly office with opportunities to bring dogs and socialize in the SF office #J-18808-Ljbffr Shepherd Insurance Agency