Own the collection, consolidation, and validation of financial data from ERP systems, project management tools, and internal stakeholders
Build and maintain dashboards, trackers, and reports that provide real-time visibility into project costs, margins, and cash flow
Prepare weekly and monthly financial reporting packages for the Director of Finance and senior leadership while working alongside the accounting department.
Reconcile actuals vs. budget across projects and cost centers, identifying and investigating variances
Facilitate the departmental budget reviews
Design and maintain sophisticated Excel financial models for project economics, scenario analysis, and cost forecasting
Build reusable templates for FP&A workflows including budgeting, cash flow forecasting, and project pro formas
Automate Excel-based processes using AI based tools available
Actively use AI coding tools (e.g., Claude, GitHub Copilot) that automate data extraction, transformation, and reporting tasks
Analyze project cost data across the full lifecycle — procurement, construction, and commissioning — to identify cost drivers and opportunities
Support the budgeting process through data gathering, model building, and departmental coordination
Assist with rolling financial forecasts, tracking actuals against plan and flagging risks and opportunities
Develop and maintain KPI tracking tied to financial and operational performance
Conduct ad hoc financial analysis to support strategic and operational decisions
Work within the company's ERP system to extract, validate, and report on financial data across projects and cost centers
Coordinate with accounting on accounts payable, accounts receivable, and job costing to ensure accurate project-level financials
Support month-end close
Own project-level cost tracking across the full BoxPower project lifecycle: build and maintain project pro formas, cost-to-complete analyses, and job cost reports for active and pipeline projects
Track budget vs. actual by project phase and cost code, flagging variances and driving resolution with project managers.
Requirements
Bachelor's degree in Finance, Accounting, Economics, Construction Management, or a related field
4–10 years of experience in project finance, project accounting, FP&A, or financial operations — with at least 2 years directly supporting construction or capital project environments
Demonstrated hands-on experience with job costing, cost-to-complete tracking, and project-level budget management
Expert-level proficiency in Microsoft Excel — pivot tables, complex formulas, financial modeling, and multi-project cost tracking
Hands-on experience with ERP systems (e.g., NetSuite, SAP, Oracle, Procore, Sage 300 CRE, or similar) in a construction context
Experience in FP&A: budgeting, forecasting, variance analysis, and KPI reporting across projects or business units
Familiarity with project finance structures: draw schedules, milestone billing, lender reporting, and cost certification
Willingness and demonstrated ability to use AI coding tools (Claude, Copilot, ChatGPT, etc.) to write scripts, automate workflows, or accelerate analysis
Strong attention to detail and a process-improvement mindset — comfortable identifying and fixing broken workflows.