Central FP&A Analyst: Excel Automation & Dashboards

Tempus; Chicago (IL); On-site; USD 80,000 - 110,000; Full time

Benefits offered by this job

Full benefits package

Incentive compensation

Restricted stock units

Job summary

Tempus is seeking an experienced Central FP&A Senior Analyst to drive planning, modeling, and reporting across the organization. You will enhance Excel-based models, automate recurring tasks with Power Query and VBA, and support executive reporting with clear narrative insights.

You will partner with cross-functional teams, maintain FP&A templates and data integrations, and help deliver accurate budgets, forecasts, and board-ready presentations for senior leadership.

Qualifications

• Bachelor's degree in Finance, Accounting, Information Technology, or a related field.
• 3–5+ years of relevant experience in Finance, FP&A, Accounting, or Business Analytics.
• Expert-level Excel skills with advanced formulas, modeling, and data manipulation; experience with Excel automation (Power Query, VBA/macros).
• Experience with FP&A software (e.g., Pigment) and ERP systems (e.g., NetSuite) preferred.
• Strong analytical, problem-solving, and organizational skills with a track record of navigating ambiguity.
• Exceptional communication and interpersonal skills to collaborate with cross-functional teams.
• Ability to adapt to a fast-paced, dynamic environment and drive change initiatives.
• Familiarity with cash flow, balance sheet, and capital allocation is a plus.

Responsibilities

• Plan, budget, and forecast across all business divisions with consolidation and modeling.
• Maintain, audit, and enhance the integrated three-statement financial model (Income Statement, Balance Sheet, Cash Flow).
• Collaborate with Corporate Accounting during monthly/quarterly close to ensure accurate accruals and streamlined consolidation.
• Review, clean up, and optimize Excel models and reporting files.
• Automate recurring tasks using Power Query, VBA/macros, and complex formulas.
• Build, maintain, and clean FP&A reporting templates and data loading processes.
• Support weekly and monthly executive reporting and narrative synthesis.
• Develop dynamic, high-impact decks for the CFO/CEO and Board of Directors.
• Assist with system implementations and ERP go-lives; map accounts and entities.
• Standardize planning templates and automate data pulls to reduce forecasting cycle time.
• Build scalable Finance dashboards for cross-functional insights.

Skills

Advanced Excel

Analytical thinking

Cross-functional collaboration

Education

Bachelor's degree in Finance/Accounting/IT

Tools

Pigment

NetSuite

Power Query

VBA/macros

Job description

Tempus is seeking an experienced Central FP&A Senior Analyst to drive planning, modeling, and reporting across the organization. You will enhance Excel-based models, automate recurring tasks with Power Query and VBA, and support executive reporting with clear narrative insights.

You will partner with cross-functional teams, maintain FP&A templates and data integrations, and help deliver accurate budgets, forecasts, and board-ready presentations for senior leadership.