Three Statement Model Finance Jobs

1 job found

Today

Sr Financial Analyst

Tempus Chicago, IL

Chicago, IL

Today

$80k - $110k/yr Full time Senior Accounting Budget Management

Apply Now

Job Description

Tempus is looking for a Central FP&A Senior Analyst to strengthen financial planning, reporting, and operational execution. This onsite role in Chicago, IL combines advanced Excel modeling with automation and systems integration to streamline forecasting and executive reporting across the business.

You will help improve Excel-based financial models and reporting, automate recurring processes, support management reporting, and use tools and integrations to make planning and forecasting workflows faster and more reliable.

What you’ll do

Consolidate and model the annual operating budget, quarterly rolling forecasts, and multi-year strategic plans across all business divisions.
Maintain, audit, and enhance the corporate integrated three-statement model (Income Statement, Balance Sheet, Cash Flow).
Partner with the Corporate Accounting team during monthly and quarterly close to ensure accurate accruals, reduce reporting discrepancies, and streamline consolidation schedules.
Review, clean up, and optimize existing Excel models, Central Model roadmaps, and financial reporting files.
Automate recurring manual tasks and workflows using Power Query, VBA/macros, and complex formulas.
Build, maintain, and improve FP&A reporting templates and data loading processes.
Support weekly and monthly executive reporting, including preparation of the monthly executive reporting pack.
Provide concise analysis of consolidated revenue, operating margins, and EBITDA.
Deliver variance analysis (Budget vs. Actual, Forecast vs. Actual, Prior Year) with qualitative insights on key performance drivers, risks, and operational headwinds/tailwinds.
Create dynamic presentation decks for the Executive Leadership Team (CFO, CEO) and the Board of Directors.
Assist with system implementations and integrations, including ERP go-lives, account/team mappings, and entity structures.
Standardize planning templates, automate repetitive data pulls, and streamline workflows to reduce the corporate forecasting cycle time.
Build scalable Finance dashboards to extend operational insights to cross-functional stakeholders.

What you bring

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 (minimum 3 years).
Expert-level Excel skills, including advanced formulas, modeling, and data manipulation.
Proven experience with Excel automation tools such as Power Query and VBA/macros or similar.
FP&A software experience such as Pigment and ERP exposure such as NetSuite are preferred.
Strong analytical, problem-solving, and organizational skills with a track record of navigating ambiguity.
Exceptional communication and interpersonal skills to collaborate effectively across teams.
Ability to adapt in a fast-paced environment and drive change initiatives.
Familiarity with cash flow, balance sheet, and capital allocation is a plus.

Tools you’ll use

Excel, Power Query, VBA/macros, Pigment, NetSuite

Salary range: USD 80,000 to 110,000 per year.

View full job page →

Get Three Statement Model Finance Jobs alerts

New Three Statement Model Finance Jobs, daily.