FP&A Analyst

Agents, brokers and direct customers all buy through our platforms, with policy administration on Guidewire. Founded in 1972, we now have 6,600 employees.

The role:

We are replacing a colleague who is moving away. We want an analyst who can explain why the numbers moved, in plain language, to people who do not work in finance. Hybrid. You will need to be in Chicago at least two days per week.

Day to day:

• Track headcount and payroll costs against plan.
• Update KPIs such as gross margin, CAC and revenue per employee.
• Answer ad hoc questions from the CFO with quick-turn analysis.
• Partner with department heads to understand spending and headcount plans.
• Build and maintain the annual budget and quarterly forecast models.
• Reconcile forecast data with accounting after close.
• Develop dashboards in Power BI or Tableau for leadership.

Minimum qualifications:

• 2+ years of FP&A, corporate finance or public accounting experience.
• Experience building budgets and forecasts.
• Advanced Excel: INDEX/MATCH, XLOOKUP, SUMIFS, pivot tables and linked three-statement models.
• Working knowledge of accounting and how the three statements connect.

Nice to have:

• Manufacturing cost analysis.
• Power BI or Tableau.
• SaaS metrics experience (ARR, churn, LTV)

Compensation: $91,000 to $115,000 a year DOE.

What you get:

• Health insurance.
• 401(k) with 4% match.
• Paid holidays.
• Paid time off.
• Life insurance.
• Cell phone reimbursement.
• Health, dental and vision coverage starting on day one.

Apply with your resume. A cover letter is optional.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Merrick Assurance Corp..