Project Controls & Forecasting Analyst

Job Position: Project Controls & Forecasting Analyst

Location : Location: Las Vegas, NV, with travel throughout Nevada, as required

Duration: 1 year, with likely extensions up through 3 years (through 8/31/29)

Job Descriptions:

• Project Controls and Forecasting Analyst will provide advanced project controls support focused on cost forecasting, financial analysis, data management, reporting automation, and project performance monitoring across the Transmission Program and other Company projects under development, as requested by Company.
• The Consultant shall support leadership, Project Controls, Project Management, and Financial Planning personnel through development and maintenance of cost forecasting models, reporting tools, and analytical processes that improve visibility into project financial performance, schedule progress, and overall program execution.
• The Consultant shall provide comprehensive project management and construction management support, including but not limited to the following deliverables:

Cost Forecasting

• Develop and maintain detailed project cost forecasts.
• Analyze forecast trends and identify potential cost risks and opportunities.
• Support monthly, quarterly, and annual forecasting cycles.
• Prepare Estimate-at-Completion (EAC) projections.
• Perform variance analysis between actual costs, forecast costs, approved budgets, prior forecasts, and current forecasting assumptions.
• Assist project teams in forecasting labor, contract services, material, and capital expenditures.

Fusion Data Analytics

• Extract, manipulate, validate, and analyze Oracle Fusion financial datasets.
• Reconcile Fusion data with project controls reporting systems.
• Develop repeatable reporting processes using Fusion exports.
• Analyze commitments, accruals, purchase orders, invoices, actual costs, and capital expenditures.
• Support monthly close activities through data validation and reconciliation.

Advanced Excel Model Development

• Develop dynamic forecasting models, automated reporting tools, data validation processes, dashboard reporting solutions, cost performance metrics, KPI reporting packages, and forecast reconciliation tools.
• Advanced Excel skills should include Power Query, Pivot Tables, data models, Power Pivot, XLOOKUP, INDEX/MATCH, dynamic arrays, and financial modeling techniques.

Project Controls Support

• Assist in development and maintenance of project controls processes.
• Support project performance measurement activities.
• Monitor project KPIs and performance indicators.
• Support earned value and productivity analysis, as applicable to the assigned project.
• Assist with budget management and cost control practices.
• Identify emerging project risks through trend analysis.

Reporting and Management Support

• Prepare recurring and ad hoc reporting packages, including executive dashboard reports, monthly project status reports, forecast variance reports, capital spend reports, cash flow forecasts, contractor spend analysis, and budget utilization reports.
• Provide recommendations regarding trends, risks, forecasting assumptions, and financial performance.

Data Quality and Governance

• Validate accuracy of project controls datasets.
• Identify data discrepancies and reporting inconsistencies.
• Support continuous improvement of reporting processes.
• Develop standardized reporting templates.
• Document forecasting methodologies and assumptions.

Desired Qualifications

• Monitor contractor conformance to the construction, operation, and maintenance (COM) plan, permit requirements, and stipulations.
• Coordinate with Company Environmental Scientist and environmental resource monitors.
• Process Company 1st Application reports for Environmental Incidents as required.

Desired Qualifications:

• Minimum 7+ years of project controls experience.
• Minimum 5+ years of utility, transmission, infrastructure, or capital project experience preferred.
• Experience supporting large capital programs exceeding $500M preferred.
• Knowledge areas should include project controls, cost forecasting, capital project accounting, earned value concepts, accrual management, utility construction programs, and financial reporting.
• Performs related duties as assigned.

Consultant must ensure that any personnel working on these projects possess, but are not limited to, the following qualifications:

Relevant Education and Certifications

• Associate’s or Bachelor’s degree in one of the following:
• Project or Business Management (with utility/infrastructure experience).

Acceptable Substitutions:

• High school diploma/GED plus 5–10 years of progressive experience in.
• Utility construction (electric, gas, water, telecom)
• Energy infrastructure (generation, transmission, substations, renewables)
• Public works or federally funded infrastructure projects
• Applicable industry certifications:
• Core Industry Certifications
• CCM – Certified Construction Manager (CMAA)
• CPC – Certified Professional Constructor (AIC)
• CAPM® / PMP® (PMI)
• CM Lean

AACE Certifications

CCP (Certified Cost Professional)

• PSP (Planning & Scheduling Professional)
• EVP (Earned Value Professional)
• Project Controls / Scheduling Certifications
• Primavera P6 Certification
• Microsoft Project Certification
• Earned Value Management (EVM) Training
• Cost Estimating and Forecasting Training
• Software & Technical Training
• Microsoft Power BI Certification
• Oracle Primavera Unifier Training
• Oracle Fusion Financials Training
• Advanced Excel / Power Query / Power Pivot Certification

Software Proficiency

• Advanced proficiency in Microsoft Excel, Oracle Fusion, Power BI, Power Query, data analytics, financial forecasting, budget controls, and cost management.

Communication and Leadership

• Strong written and verbal communication skills for stakeholder engagement.
• Ability to lead teams and collaborate across multiple disciplines.
• Frequent communication and collaboration with the Company project team.

Employment Type: Contract
Salary: $80 - $90 Hourly
Bonus/Commission: No