Project Controls & Forecasting Analyst

Experience: 7+ Years
Industry: Utilities / Transmission / Infrastructure / Capital Projects
Work Mode: Onsite

Job Summary

We are seeking an experienced Project Controls & Forecasting Analyst to support the Transmission Program and other large-scale capital projects. The ideal candidate will provide advanced project controls, cost forecasting, financial analysis, project performance monitoring, reporting, and data management services.

The role will work closely with Project Controls, Project Management, and Financial Planning teams to provide accurate financial insights, forecasts, dashboards, KPIs, and executive-level reporting to support informed project and portfolio decisions.

Key Responsibilities

• Develop and maintain project cost forecasts and Estimate-at-Completion (EAC) projections.
• Perform cost, budget, and schedule variance analysis and identify key drivers of project performance.
• Support capital expenditure (CAPEX) forecasting, budget management, and forecast reconciliation.
• Analyze and validate financial and project data from Oracle Fusion and other project systems.
• Develop project performance reports, executive dashboards, and management presentations.
• Build and maintain automated reporting solutions using Power BI, Power Query, and Microsoft Excel.
• Track project KPIs and provide actionable insights into cost, schedule, budget, and forecast performance.
• Support Earned Value Management (EVM) analysis, including performance measurement and forecasting.
• Monitor project financial performance against approved budgets, commitments, actuals, and forecasts.
• Perform data reconciliation, quality checks, and data governance activities to ensure reporting accuracy.
• Identify opportunities to automate and improve project controls and forecasting processes.
• Collaborate with Project Managers, Project Controls teams, Finance, and other stakeholders to resolve data and forecasting issues.
• Prepare ad hoc financial analysis and reporting to support project and program leadership.
• Maintain documentation for forecasting methodologies, reporting processes, data sources, and controls.
• Contribute to continuous improvement initiatives across project controls, financial reporting, and forecasting functions.

Required Skills & Qualifications

• 7+ years of experience in project controls, cost engineering, financial analysis, or project forecasting.
• Experience supporting utility, transmission, infrastructure, energy, or large-scale capital projects.
• Strong hands-on experience with Oracle Fusion financial data and reporting.
• Advanced proficiency in Microsoft Excel, including complex formulas, pivot tables, data analysis, and reporting.
• Strong experience with Power BI and Power Query for dashboard development, data transformation, and reporting automation.
• Solid understanding of project cost forecasting and EAC methodologies.
• Experience with Earned Value Management (EVM) and project performance measurement.
• Strong knowledge of CAPEX, budget management, actuals, commitments, accruals, and forecast reconciliation.
• Strong analytical, problem-solving, and data-management skills.
• Ability to work with large datasets and translate complex financial/project information into clear business insights.
• Excellent communication skills with the ability to present findings to project and executive stakeholders.roject Controls & Forecasting Analyst