Back to jobs
New

Senior Strategic Financial Modeler

United States
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.

Reporting directly to Pie’s Vice President of FP&A, this role will be responsible for owning the three-statement financial modeling for the strategic plan, budget and forecasts which will inform decisions at the executive and board level.  The ideal candidate has deep modeling and forecasting skills in the P&C insurance industry and deeply understands insurance accounting, both GAAP and Statutory, and can easily analyze and explain drivers of performance for insurance carriers.  This individual will be highly analytical with the ability to synthesize information from disparate sources across the business and strategic landscape.

How You’ll Do It

  • Insurance financial modeling:
    • Build from scratch the three-statement financial projection model (balance sheet, income statement and cash flow) by legal entity for both GAAP and Statutory projections.
    • Own capital modeling for the business - BCAR, RBC, and Hazardous Financial Condition.
    • Perform variance analysis on key elements of results (gross written premium, net earned premium, losses, cash, capital, balance sheet drivers that impact the model.
    • Create presentation materials for various audiences including senior leadership and the Board, to display forecast, plan and actual results.
    • Maintain rolling near- and long-term forecasts for use by Pie management, Pie’s Board, and to inform communications with investors, ratings bureaus, reinsurance partners, and regulators.
    • Coordinate with FP&A business partners and their business leaders on incorporating 5-year business plans into the models.
  • Reinsurance:
    • Read and understand reinsurance contract terms and understand accounting for reinsurance for all policies in force.
    • Build out the forecast model for the treatment of reinsurance, pulling the thread through to all three financial statements.
  • Earned Premium: Builds out the modeling and forecasting for Gross to Net Written and From Gross to Net Earned, taking into account UPR and IFP impacts.
  • Net Losses and LAE:
    • Build loss and LAE forecasts based on AY and PY; understands loss triangle modeling.
    • Perform variance analysis and explain drivers of variance to a peg (e.g. CAY and PAY development and drivers of that development by state/segment).
    • Work with our actuarial, claims and data science teams to understand trends and drivers of Pie’s insurance losses and integrate those insights into our forecasting processes.
  • Deferred Acquisition Costs: Build modeling/forecast for DAC and explains variances. 
  • Strategic Finance and Other Modeling and Presentations:
    • Build ad-hoc models for analyzing and aiding strategic decision-making. 
    • Build out the MD&A financial narratives to help the board and investors understand Pie’s business.
    • Provide financial modeling and analysis support for fundraising, reinsurance negotiations, and potential future acquisitions.

The Right Stuff

  • Bachelor’s Degree in Finance, Business, Economics, Accounting or related field is required.
  • 8+ years of total relevant experience in the areas of insurance Finance or Accounting is required.
  • 5+ years of experience in Financial Planning and Analysis (FP&A) is required
  • 2+ years of building financial models specific to insurance companies is preferred, including modeling RBC and BCAR
  • Insurance industry experience is required (P&C experience is a plus) 
  • Strong insurance accounting knowledge including both GAAP and Statutory is highly recommended.
  • Exceptional modeling skills with strong experience building three-statement models, building models from scratch, and building dynamic scenarios for scenario analysis.
  • Strong finance acumen and with a high attention to detail.
  • Highly skilled in variance analysis and developing related commentary (budget vs actuals and vs forecast).
  • Oriented around forecasting accuracy and performs variance analysis to better their own modeling.
  • Highly analytical skills and natural curiosity for how the “why” behind company metrics and KPIs; digs in until they have the understanding.
  • Comfortable working with large datasets.
  • Strong preference to base decisions on data and ROI.
  • Ability to identify areas of opportunity and drive projects from planning to completion.
  • Ability to work with minimal guidance.
  • Experience in managing work-streams end-to-end along with working across multiple functions and teams.
  • Advanced proficiency in Excel and PowerPoint. 
  • Excellent interpersonal, oral/written communication skills, with the ability to build trusted relationships with business stakeholders.
  • Google Suite, Looker, Intacct, Adaptive and Workday experience or experience with related tools is a plus.

The use of AI in Application Review: To support a fair, efficient, and consistent hiring process, we use AI-powered tools to assist in the initial screening of applications. These tools help us identify qualifications and prior work experiences that align with the requirements of the role. All AI-reviewed applications are still subject to human oversight and decision-making at multiple stages of the process. By submitting your application, you acknowledge and consent to it being reviewed using these AI technologies to assist in our evaluation process.

Base Compensation Range

$130,000 - $160,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 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.  

Safety First: Pie Insurance is committed to your security during the recruitment process. We will never ask you for credit card information or ask you to purchase any equipment during our interview or onboarding process.

Pie Insurance Announces $315 Million Series D Round of Funding

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

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Select...
Select...
Select...
Select...

U.S. Standard Demographic Questions

We invite applicants to share their demographic background. If you choose to complete this survey, your responses may be used to identify areas of improvement in our hiring process.
Select...
Select...
Select...
Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Pie Insurance’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.