SlipstreamJobs tracks this role from the company's public career site. Apply directly on the employer's site.
Salary: USD 110,000 - 140,000 / annual
Shepherd is a technology-driven Managing General Underwriter (MGU) transforming commercial Property & Casualty insurance for high-hazard industries. The company recently raised a $42M Series B (March 2026, total funding >$60M) led by Intact Private Capital and is building a modern risk platform that combines underwriting expertise, data, and automation to deliver faster decisions, smarter pricing, and better risk outcomes.
As an Actuarial Data Analyst, you will serve as a bridge between market intelligence, regulatory requirements, and data-driven product decisions. You will join a small actuarial team supporting multiple commercial lines including General Liability, Workers' Compensation, Commercial Property, and Excess Casualty. The role involves close partnership with underwriters and software engineers, translating actuarial insights into technology and decisions that power the platform.
Key Responsibilities (50% Ratemaking & Competitive Intelligence): Assist in developing, pricing, and implementing rating plans for state Department of Insurance filings. Support the Compliance team in preparing and submitting rate and form filings. Conduct comprehensive competitor analysis using SERFF, S&P Capital IQ Pro, and regulatory databases to identify market trends. Analyze filings, rate manuals, underwriting guidelines, and coverage forms from ISO manuals and NCCI data to develop benchmarks and strategic recommendations. Research and draft responses to rate-related objections with actuarial justification.
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. Support workers' compensation statistical reporting obligations (WCSTAT, 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 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.
The company operates on four core values: Think Big Build Big (protecting progress and industries that rely on it), Win Together (supporting each other and celebrating collective success), Cross the Aisle (collaboration and listening across boundaries), and Go Get It (acting with urgency and taking smart risks).
REQUIREMENTS:
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
