Project Controls Analyst

Job Position: Project Controls & Forecasting Analyst Location : Location: Las Vegas, NV, with travel throughout Nevada, as required 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: Develop and maintain detailed project cost forecasts. Analyze forecast trends and identify potential cost risks and opportunities. 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. 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. Document forecasting methodologies and assumptions. 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. 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. Consultant must ensure that any personnel working on these projects possess, but are not limited to, the following qualifications: Associate’s or Bachelor’s degree in one of the following: Project or Business Management (with utility/infrastructure experience). High school diploma/GED plus 5–10 years of progressive experience in. Utility construction (electric, gas, water, telecom) Public works or federally funded infrastructure projects CCM – Certified Construction Manager (CMAA) CAPM® / PMP® (PMI) CM Lean PSP (Planning & Scheduling 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 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. Frequent communication and collaboration with the Company project team. Employment Type: Contract Salary: $80 - $90 Hourly Bonus/Commission: No