Strategic Project Cost Lead: Forecasting & Budgeting

Brooksource; Michigan; Hybrid; USD 76,000 - 83,000; Full time

Benefits offered by this job

401(k) Matching

Medical, Dental & Vision

6 Paid Holidays

Health Savings Account

Dependent Care FSA

Paid Time Off

Sick Time

EAP program

Job summary

Brooksource is seeking a Senior Project Cost Analyst to support a large portfolio of capital projects across generation and energy infrastructure assets. This role focuses on forecasting, budgeting, variance analysis, and month‑end close activities in a hybrid setting in Michigan.

You will build Excel models, analyze spend vs forecast, work with project managers, and provide accurate financial reporting to stakeholders.

Qualifications

• 6+ years in project cost controls for capital projects.
• Proficient in forecasting, budgeting, variance analysis, and reporting.
• Strong Excel skills and understanding of accruals.

Responsibilities

• Develop and maintain project forecasts, budgets, and financial performance tracking across capital programs
• Analyze actual spend versus forecasted costs and provide detailed variance explanations to stakeholders
• Support month-end close activities, including accruals, forecast updates, actuals validation, and financial reporting
• Partner with Project Managers to identify scope, schedule, and cost impacts affecting forecasts
• Monitor project financial health and communicate risks, trends, and budget concerns
• Build and maintain complex Excel-based financial models, forecasting tools, and dashboards
• Consolidate and analyze data from multiple sources to support portfolio-level reporting
• Support continuous improvement initiatives related to project controls, reporting, and forecasting processes

Skills

Cost controls

Budgeting

Forecasting

Variance analysis

Excel advanced

Month-end close

Accrual accounting

UBLs/ERS knowledge

Stakeholder mgmt

Portfolio analysis

Tools

Excel

Power Query

Pivot Tables

VLOOKUP/XLOOKUP

Job description

Brooksource is seeking a Senior Project Cost Analyst to support a large portfolio of capital projects across generation and energy infrastructure assets. This role focuses on forecasting, budgeting, variance analysis, and month‑end close activities in a hybrid setting in Michigan.

You will build Excel models, analyze spend vs forecast, work with project managers, and provide accurate financial reporting to stakeholders.