Excel-Driven Financial Data Analyst: KPIs & Forecasting

Paycom; Boise (ID); On-site; USD 55,000 - 75,000; Full time

Benefits offered by this job

PTO

Parental Leave

Volunteer Time Off

Paid holidays

Medical, Dental, Vision

401(k)

Job summary

The Car Park is seeking a detail-oriented finance professional to support monthly P&L preparation, variance analysis, and management reporting. You will help consolidate data across departments, build Excel-based dashboards, and contribute to budgeting and forecasting processes, ensuring accuracy and financial alignment.

You have a foundational accounting knowledge (GAAP) and 1–2 years of related experience, with strong Excel skills and a drive to grow in a dynamic team environment.

Qualifications

• Bachelor’s degree in Finance, Accounting, Economics, or related field.
• 1–2 years of experience in a finance, accounting, or analytical role (internships included).
• Strong proficiency in Microsoft Excel, including formulas, pivot tables, and charts; experience with financial modeling preferred.
• Understanding of basic accounting principles, including GAAP.

Responsibilities

• Assist in the preparation and delivery of monthly P&L statements, variance analysis, and management reports.
• Track key financial metrics and explain variances to budget and forecast.
• Support annual budgeting processes and quarterly reforecasts by gathering data from multiple departments.
• Develop and maintain advanced Excel spreadsheets, dashboards, and models for tracking expenses, revenues, and KPIs.
• Collaborate with accounting, operations, and department leaders to ensure financial alignment.

Skills

Excel

Financial modeling

GAAP

Data analysis

Education

Bachelor’s degree in Finance/Accounting

Job description

The Car Park is seeking a detail-oriented finance professional to support monthly P&L preparation, variance analysis, and management reporting. You will help consolidate data across departments, build Excel-based dashboards, and contribute to budgeting and forecasting processes, ensuring accuracy and financial alignment.

You have a foundational accounting knowledge (GAAP) and 1–2 years of related experience, with strong Excel skills and a drive to grow in a dynamic team environment.