Actuarial Associate, Data

Pie Insurance

Pie Insurance

United States
Posted on Friday, April 7, 2023
Pie's mission is to empower small businesses to thrive by making commercial insurance affordable and as easy as pie. We leverage technology to transform how small businesses buy and experience commercial insurance.
Like our small business customers, we are a diverse team of builders, dreamers, and entrepreneurs who are driven by core values and operating principles that guide every decision we make.

The Actuarial Associate position will primarily be responsible for helping develop reserve indications, performing rate indications, and creating underwriting diagnostics. Being able to extract and analyze data is the key to success for the Actuarial Associate position.

How You’ll Do It

Analytics & Data Manipulation

  • Query internal claims and policy data using SQL and evaluate data for reasonability
  • Architect the development of an actuarial data warehouse supporting both ratemaking and reserving functions
  • Develop automated procedures to determine on-level premium at various points in time
  • Develop a set of procedures to automatically monitor data quality and check for material shifts in the data
  • Support various reserving and ratemaking projects as needed
  • Develop automated procedures to bring in and normalize various external data resources, such as NCCI and WCIRB, in order to supplement internal data or serve as a complement of credibility.

Team Resource

  • Highlighting areas of concern and bringing forward to senior management for review.
  • Effectively communicate information from large data sets and be able to explain the why behind the information.
  • Directly supporting the actuarial team with data and data analysis.
  • Networks and collaborates on ideas and challenges with business units such as Claims, Product, and Data Engineering.

The Right Stuff

  • Bachelor's Degree or equivalent experience with some college coursework is required.
  • Background in statistics, mathematics, economics, actuarial science or other quantitative major fields of study is highly desirable.
  • Advanced SQL skills for data extraction, transfer, and loading are required (joins, window functions, common table expressions, recursive CTEs, writing stored procedures, pivoting data, self joins, date-time manipulation, qualification statements, user-defined function creation, temporary function creation, merging tables of different granularity, etc.). Must be able to write complex SQL queries from scratch and not just edit existing queries.
  • Must have passed CAS Exam 5 - Basic Ratemaking and Est Claim Liabilities at a minimum. ACAS designation preferred
  • Advanced Excel skills are required (complex formulas, data linking, pivot tables, ODBC connections).
  • Intermediate knowledge of R and/or Python required
  • 3-years of work experience in the P&C commercial insurance industry, specifically workers compensation, is preferred.
  • 2-years prior working experience in a data or data science focused actuarial role
  • Intermediate communication (written and verbal) skills, to deliver more complex information effectively.
  • Intermediate problem solving skills to be able to manage complex tasks and work through to solutions with little guidance and direction.
  • Intermediate awareness of your own tasks, and how it impacts the team and deliverables.
  • Understanding of basic actuarial concepts, such as loss development, credibility, earned premium, calendar year v policy year, on leveling, components of a rate, and off balancing
  • Familiarity with industry data sources, such as NCCI or WCIRB is desirable.
  • Sense of creativity and strategic thinking about how analytics relate to business outcomes now and into the future.
  • Problem solving skills to work through numerical issues with data sets.
  • Comfortable with ambiguity and a self starter.
  • Likes variety and not repetition, but can build repetition in process for scalability purposes.
  • Attention to detail and ability to perform reasonability checks.


Base Compensation Range
$110,000$150,000 USD

Compensation & Benefits

  • Competitive cash compensation
  • A piece of the pie (in the form of equity)
  • Comprehensive health plans
  • Generous PTO
  • Future focused 401k match
  • Generous parental and caregiver leave
  • Our core values are more than just a poster on the wall; they’re tangibly reflected in our work

Our goal is to make all aspects of working with us as easy as pie. That includes our offer process. When we’ve identified a talented individual who we’d like to be a Pie-oneer , we work hard to present an equitable and fair offer. We look at the candidate’s knowledge, skills, and experience, along with their compensation expectations and align that with our company equity processes to determine our offer ranges.

Each year Pie reviews company performance and may grant discretionary bonuses to eligible team members.

Location Information

Unless otherwise specified, this role has the option to be hybrid or remote. Hybrid work locations provide team members with the flexibility of working partially from our Denver or DC office and from home. Remote team members must live and work in the United States* (*territories excluded), and have access to reliable, high-speed internet.

Additional Information

Pie Insurance is an equal opportunity employer. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, marital status, age, disability, national or ethnic origin, military service status, citizenship, or other protected characteristic.

Pie Insurance participates in the E-Verify program. Please click here, here and here for more information.

Pie Insurance is committed to protecting your personal data. Please review our Privacy Policy.

Pie Insurance Announces $315 Million Series D Round of Funding

Built In honors Pie in its 2023 Best Places to Work Awards