Project Controls & Forecasting Analyst

Metasys Technologies, LLC; Las Vegas (NV); On-site; USD 90,000 - 130,000; Full time

Job summary

Metasys Technologies, LLC is seeking a Project Controls & Forecasting Analyst in Las Vegas, NV, to support the Transmission Program and other initiatives. The role focuses on cost forecasting, data management, reporting automation, and performance monitoring across multiple projects.

The consultant will develop forecasting models, validate data, and deliver actionable insights to leadership, project controls, and financial planning teams, enabling better visibility into costs, schedules, and

Qualifications

• 7+ years of project controls experience.
• 5+ years of utility, transmission, infrastructure, or capital project experience preferred.
• Knowledge of project controls, cost forecasting, capital project accounting, earned value concepts, accrual management, utility construction programs, and financial reporting.
• Performs related duties as assigned.

Responsibilities

• Provide advanced project controls support focused on cost forecasting, financial analysis, data management, reporting automation, and project performance monitoring across programs.
• Develop and maintain cost forecasting models, reporting tools, and analytical processes to improve visibility into project financial performance, schedule progress, and execution.
• Prepare recurring and ad hoc reporting packages, including executive dashboard reports, monthly status, forecast variance, and budget utilization reports.

Skills

Advanced Excel

Oracle Fusion

Power BI

Power Query

Data analytics

Financial forecasting

Budget controls

Cost management

Education

Associate or Bachelor’s in Project/Business Management

Tools

Microsoft Power BI

Oracle Fusion

Microsoft Project

Job description

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.
• 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.
• 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.
• 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
• CPC – Certified Professional Constructor (AIC)

AACE Certifications

CCP (Certified Cost Professional)

• PSP (Planning & Scheduling Professional)
• EVP (Earned Value Professional)
• Project Controls / Scheduling Certifications
• Microsoft Project Certification
• Earned Value Management (EVM) Training
• Cost Estimating and Forecasting Training
• Software & Technical Training
• Microsoft Power BI Certification
• 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

• Ability to lead teams and collaborate across multiple disciplines.
• Frequent communication and collaboration with the Company project team.