Sr Project Cost Analyst

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

Location: Belle River, Monroe, or Detroit, MI (Hybrid)

Rate: $55-60/hr (6 Month Contract)

Schedule: Hybrid | Onsite Tuesday-Thursday

About the Role

We are seeking a Senior Project Cost Analyst to support a large portfolio of capital projects across generation and energy infrastructure assets. This individual will play a critical role in project forecasting, budgeting, variance analysis, month-end close activities, and financial reporting. The ideal candidate brings strong project cost controls experience, advanced Excel capabilities, and a solid understanding of accrual accounting and unbilled liabilities within a capital project environment.

What You'll Do

• 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 project 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 that affect project forecasts
• Monitor project financial health and communicate key risks, trends, and budget concerns
• Build and maintain complex Excel-based financial models, forecasting tools, and reporting dashboards
• Consolidate and analyze data from multiple sources to support portfolio-level reporting and decision-making
• Support continuous improvement initiatives related to project controls, reporting, and forecasting processes

What You Bring

• 6+ years of experience in project cost controls, project finance, budgeting, or cost analysis supporting capital projects
• Strong background in forecasting, budgeting, variance analysis, and project financial reporting
• Advanced Excel skills including Pivot Tables, VLOOKUP/XLOOKUP, Power Query, complex formulas, and large interconnected spreadsheets
• Experience supporting month-end close processes and accrual accounting activities
• Understanding of unbilled liabilities (UBLs), evaluated receipt settlement (ERS), and financial forecasting principles
• Experience working with large project portfolios and managing multiple priorities simultaneously
• Strong analytical, communication, and stakeholder management skills

Why Join Us?

• 401(k) Matching Plan
• Medical, Dental & Vision Plans
• Relationship Driven Process to Find Your Best Fit
• 6 Paid Holidays
• Regular Meetings to Ensure Quality in Your Engagement

About Us

At Brooksource, relationships are the foundation of everything we do. Since 2000, we’ve built lasting partnerships with clients, consultants, and internal teams to deliver an exceptional experience across every engagement. As a trusted IT and Engineering services provider, Brooksource supports Fortune 500 organizations through Experience-Driven Staffing, Professional Services, and Elevate, our proprietary Workforce Transformation program.

Whether you're hiring for software development, cloud computing, cybersecurity, data analytics, or enterprise IT, our customized staffing solutions are designed to align with your company’s unique goals, culture, and technology stack. We offer flexible hiring models, including contract, contract-to-hire, and direct placement to meet your evolving business needs.

We are a certified partner of leading platforms, including Salesforce, AWS, Microsoft, and Google Cloud, enabling us to deliver scalable, end-to-end technology solutions. With a growing national footprint, Brooksource is redefining expectations in IT consulting, engineering services, and technology workforce solutions.

EEO Statement

Brooksource is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, lactation and related medical conditions), gender identity or gender expression, sexual orientation, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances.

Benefits & Perks

• competitive medical
• dental
• vision
• Health Savings Account
• Dependent Care FSA
• supplemental coverage with plans that can fit each employee's needs.
• 401(k) plan that includes a company match and is fully vested after eligibility
• paid time off
• sick time
• paid company holidays
• Employee Assistance Program (EAP) that provides services such as virtual counseling, financial services, legal services, and life coaching.

Pay Disclaimer

• The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include, but are not limited to, responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreements, or other legal requirements.