Actuarial Data Analyst

About 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. As an Actuarial Data Analyst, you will be the bridge between market intelligence, regulatory requirements, and data-driven product decisions. You will be joining a small team of actuaries playing a critical role in ensuring our products remain competitive while maintaining compliance across all jurisdictions where we operate. The actuarial team works in close partnership with underwriters and software engineers, translating actuarial insights into the technology and decisions that power a modern insurance platform.

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

Benefits

Additional Information

What We Do Shepherd is an AI-native commercial insurance platform transforming how high-hazard industries get covered. Our mission is to make risk frictionless for the builders and operators shaping the physical world - protecting progress from concept through construction and into decades of operation. The infrastructure behind the AI boom - data centers, semiconductor fabs, renewable energy assets - has to be built and insured. But traditional carriers weren't built for this speed: Complex commercial construction projects routinely wait weeks for a single quote Legacy carriers rely on static applications and disconnected systems Brokers chase carriers through calls, emails, and resubmissions We built Shepherd to solve that. Our AI performs the same underwriting workflows in seconds, and integrates real-time data from construction technology partners - Procore, Autodesk, OpenSpace, DroneDeploy, and others - to see risk as it actually exists, not just as it was reported on a static form. We're pursuing the most ambitious technical vision in commercial insurance: fully autonomous underwriting. We're closing in on the first fully agentic submission in the industry - email in, price out, no human intervention until the last mile. With Shepherd, safety, speed, and quality no longer trade off against one another - they compound. We're building: Faster decisions Smarter, more accurate pricing Better risk outcomes for insureds who invest in safer practices We're not just modernizing insurance products. We're building the risk infrastructure for the next generation of financial services. Our Investors In March 2026, Shepherd raised a $42M Series B - bringing total funding to over $60M - led by Intact Private Capital, the investment arm of one of the largest insurers in the world. Intact is not only our lead investor but also a carrier partner, a testament to the confidence the incumbent industry has in what we're building. Our investors: Intact Private Capital Spark Capital Costanoa Ventures Y Combinator Susa Ventures And several others Our Team We're a team of technologists and insurance enthusiasts, bridging the two worlds together. Check out our About page to learn more.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at shepherd? Share your experience