Shepherd Logo

Shepherd

Actuarial Data Analyst

Posted One Month Ago
In-Office
Chicago, IL, USA
110K-140K Annually
Mid level
In-Office
Chicago, IL, USA
110K-140K Annually
Mid level
Analyze commercial P&C insurance rates, filings, competitors, loss ratios, portfolios, and regulatory requirements. Build rating plans, support rate and form filings, respond to regulatory objections, and monitor product performance. Use SQL and PostgreSQL for data analysis, Metabase for dashboards, and dbt for data transformation. Collaborate with actuarial, underwriting, compliance, product, and engineering teams to translate insights into pricing and product decisions.
The summary above was generated by AI
What we do

Build the insurance behind the physical world.

The world is building data centers, energy projects, hospitals, schools, and critical infrastructure. Every one of those projects needs insurance to move forward. Yet the process of getting that insurance still depends on scattered documents, manual work, and weeks of back-and-forth.

 

Shepherd is rebuilding commercial insurance with software, data, AI, and deep underwriting expertise. We started in construction and energy, where understanding the specifics of a project matters and better decisions have consequences far beyond a screen.

 

We develop insurance products, decide which risks to insure and how to price them, and partner with established insurers to back the coverage. We own the platform our team uses to turn complex submissions into coverage for the builders and operators shaping the world around us.

 

Real problems. Real ownership.

Our engineers, designers, underwriters, CX, and actuaries build together. The problems span turning messy documents into reliable data, making pricing more precise, and designing AI agents that can take on increasingly complex underwriting work.

 

The ambition is a platform where experts spend more time on judgment and relationships, supported by software that handles the work around them. Join us to build systems whose decisions help real projects get built.

 

630+ customers / $500B+ insured project value

 
 
Our investors

Capital to build. Partners to grow with.

$67M total funding / $42M Series B in March 2026

 

Shepherd is backed by Intact Private Capital, Costanoa Ventures, Spark Capital, Susa Ventures, and Y Combinator. In March 2026, we announced a $42M Series B led by Intact Private Capital, bringing our total funding to $67M.

 

Intact is also a capacity partner. Alongside its investment, Intact works with Shepherd to bring insurance products to market. That relationship connects our platform and underwriting expertise with the resources of a global insurer.

 

A bigger opportunity ahead

We are investing in new insurance products, our underwriting team, and the path toward autonomous underwriting. For the people joining Shepherd, that means the chance to shape both the technology and the business it makes possible.

 

Our backing brings together investors who build technology companies and partners who understand insurance. We are building a company that earns the confidence of both.

 
 
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.

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

How we work

Shepherd runs on four values. Here's what each one means in this seat.

  • Think big, build big. We exist to protect progress and the industries that rely on it. The work here is aimed at a system that runs on its own, and the roadmap gets sequenced backward from that rather than forward from what's easy.

  • Win together. We rise as one. We support each other, raise the bar, and celebrate collective success. Come set a standard the rest of the team inherits.

  • Cross the aisle. Collaboration wins. We listen deeply, work across boundaries, and prioritize shared success over individual lanes. The best product calls here come from engineers who've sat with underwriters and underwriters who understand where the model breaks, and much of this job is listening closely enough on both sides to make that happen.

  • Go get it. We act with urgency, move with confidence, take smart risks, and push forward with intention. Nobody hands you the roadmap, the data, or the meeting invite. You pull the failing runs, book the time with the underwriters, and decide what matters.

 
Benefits 

🏥 Premium Healthcare
100% contribution to health, dental, and vision

🥕 Fertility benefits and family building support

🏖️ Flexible PTO
Flexibility to take the time off, recharge, and perform

🥗 Daily lunches, dinners, and snacks
We work together, and enjoy meals together too

🖥️ SF, NYC, Dallas-Fort Worth, Chicago and LA Offices

📚 Professional Development
Access to premium coaching, including leadership development

🏦 Competitive 401(k) Plan

🐶 Dog-friendly office
Plenty of dogs to play with and make friends with in the SF office

Similar Jobs

11 Minutes Ago
Hybrid
Chicago, IL, USA
52K-75K Annually
Entry level
52K-75K Annually
Entry level
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Supports client-facing analytic projects by defining scopes and approaches, managing communications and workflows, overseeing team deliverables, validating data accuracy, and developing insights and presentations. Requires strong quantitative, analytical, communication, and problem-solving skills, along with proficiency in Excel, SQL, and PowerPoint.
Top Skills: ExcelMicrosoft PowerpointSQL
11 Minutes Ago
Easy Apply
In-Office
Chicago, IL, USA
Easy Apply
70K-100K Annually
Mid level
70K-100K Annually
Mid level
Marketing Tech • Mobile • Software
Own the customer lifecycle for Vibes’ Adobe Marketo partnership, managing onboarding, adoption, retention, renewals, and expansion across 50+ B2B SaaS customers. Build playbooks, dashboards, health scores, and operating cadences; configure platform and integration components; coordinate Vibes, Adobe, Sales, Implementation, and Product teams; conduct business reviews; identify risk and opportunities; and provide customer insights to leadership. Travel up to 20% for Adobe events and customer meetings.
Top Skills: Adobe MarketoChurnzeroHubspotMmsMobile WalletRcsSmsVibes Platform
20 Minutes Ago
Hybrid
Chicago, IL, USA
85K-120K Annually
Expert/Leader
85K-120K Annually
Expert/Leader
Fintech • Software • Financial Services
Serve as the investment product subject matter expert for sales teams, advisors, wealth managers, and institutional clients. Explain structured notes, options overlays, ETFs, and separately managed accounts; advise on portfolio construction, hedging, asset allocation, and trading mechanics. Support business development through client meetings, thought leadership content, conferences, and presentations. Provide market intelligence to product teams and help develop investment solutions for affluent and high-net-worth clients.

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account