FP&A Analyst: Forecasting, Modeling & Dashboards

Ziegler Caterpillar

BLOOMINGTON (MN)

On-site

USD 71,000 - 89,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health, Dental, Vision and Life Ins.
15 days of PTO in year 1
9 paid holidays
401(k) plan with company match
HSA with employer contribution
Disability Insurance (Short/Long)
Paid Parental Leave & Funeral Leave
Fitness membership discount
Education Assistance

Job summary

Ziegler Inc. in Bloomington, MN seeks an FP&A Analyst to deliver timely financial analysis and reporting across revenue streams, forecast models, and performance insights.

You will translate operational metrics into financial implications and support branch leadership with data-driven decisions. The role emphasizes forecasting, modeling, and dashboards using Excel and Power BI, with a focus on equipment sales, rental, parts, and service performance.

Qualifications

  • Bachelor’s degree in Finance, Accounting, Economics, or a related field.
  • 2-5 years of experience in FP&A, accounting, or financial analysis (industrial, distribution, or dealership environment preferred)
  • Advanced Excel skills with strong financial modeling capabilities
  • Experience with Power BI or similar data visualization tools preferred
  • Strong analytical, problem-solving, and critical thinking skills
  • High attention to detail with the ability to communicate insights clearly
  • Curiosity and interest in understanding operational drivers and business performance

Responsibilities

  • Assist in the annual budget, reforecast, and rolling forecast processes
  • Develop and maintain forecasts at the branch, product, and departmental levels
  • Build and maintain financial models for: Equipment sales volume and margins, Rental utilization and fleet economics, Parts gross margin and inventory assumptions, Service labor efficiency and absorption
  • Monitor actual results versus forecasts and identify key variances
  • Analyze monthly financial results by business line, branch/region, and customer or project as needed
  • Support pricing, discounting, and margin analysis
  • Conduct analyses on: Equipment turns and aging, Rental fleet ROI and lifecycle costs, Technician productivity and cost recovery, Parts inventory velocity and obsolescence
  • Provide ad hoc analysis to support leadership decision-making
  • Prepare and maintain recurring management reports
  • Track and report on key performance indicators, including: Absorption, Utilization, Backlog, and Gross margin by segment
  • Develop and enhance dashboards and visual reporting tools (e.g., Excel, Power BI)
  • Ensure accuracy, consistency, and integrity of data across reports
  • Partner with FP&A Lead to support branch managers, sales leadership, and rental/service teams
  • Translate operational metrics into financial insights and performance implications
  • Participate in business review meetings as a financial resource
  • Extract, validate, and analyze data from ERP systems (e.g., D365)
  • Maintain financial models, templates, and underlying assumptions
  • Identify and resolve data integrity issues in collaboration with Finance and IT
  • Contribute to process improvements and automation initiatives

Skills

Advanced Excel
Financial modeling
Power BI
Data analysis

Education

Bachelor’s degree in Finance, Accounting, Economics

Tools

D365 ERP

Job description

Ziegler Inc. in Bloomington, MN seeks an FP&A Analyst to deliver timely financial analysis and reporting across revenue streams, forecast models, and performance insights.

You will translate operational metrics into financial implications and support branch leadership with data-driven decisions. The role emphasizes forecasting, modeling, and dashboards using Excel and Power BI, with a focus on equipment sales, rental, parts, and service performance.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

FP&A Analyst: Strategic Forecasting & Growth Insights
FP&A Analyst: Strategic Forecasting & Growth Insights

Ziegler Inc. • Minneapolis (MN)

On-site
USD 71,000 - 89,000
Health, Dental, Vision and Life Ins.
15 days PTO first year
9 paid holidays
+1
FP&A Analyst: Forecasting, Insights & Growth
FP&A Analyst: Forecasting, Insights & Growth

Ziegler Caterpillar • Minneapolis (MN)

On-site
USD 71,000 - 89,000
Health, Dental, Vision and Life
15 days of PTO
9 paid holidays
+6
FP&A Analyst - Forecasting, Analytics & Strategy
FP&A Analyst - Forecasting, Analytics & Strategy

Ziegler Inc. • BLOOMINGTON (MN)

On-site
USD 71,000 - 89,000
Health, Dental, Vision and Life保险
15 days of PTO
9 paid holidays
+6
Strategic FP&A Lead: Growth, Insights & Forecasting
Strategic FP&A Lead: Growth, Insights & Forecasting

Ziegler Caterpillar • Minneapolis (MN)

On-site
USD 95,000 - 119,000
Health, Dental, Vision Insurance
Paid time off (PTO) 15 days
9 paid holidays
+2
Product Support & Operations Data Analyst
Product Support & Operations Data Analyst

Ziegler Inc. • BLOOMINGTON (MN)

On-site
USD 71,000 - 89,000
Health Insurance
15 days PTO
9 holidays
+6
Power BI Data Visualization Analyst
Power BI Data Visualization Analyst

Ziegler Inc. • BLOOMINGTON (MN)

On-site
USD 82,000 - 103,000
Health, Dental, Vision and Life保险
PTO 15 days first year
9 paid holidays
+3
Financial Planning and Analysis (FP&A) Analyst
Financial Planning and Analysis (FP&A) Analyst

Ziegler Inc. • BLOOMINGTON (MN)

On-site
USD 71,000 - 89,000
Health, Dental, Vision and Life保险
15 days of PTO
9 paid holidays
+6
Financial Planning and Analysis Lead
Financial Planning and Analysis Lead

Ziegler Caterpillar • Minneapolis (MN)

On-site
USD 95,000 - 119,000
Health, Dental, Vision Insurance
Paid time off (PTO) 15 days
9 paid holidays
+2
Power BI Data Analyst & Insights Architect
Power BI Data Analyst & Insights Architect

Ziegler Caterpillar • Minneapolis (MN)

On-site
USD 82,000 - 103,000
Health Insurance
Dental Insurance
Vision Insurance
+9
FP&A Finance Manager — Strategic Business Partner
FP&A Finance Manager — Strategic Business Partner

Zep Inc. • Atlanta (GA)

On-site
USD 100,000 - 150,000