Project Control Specialist II

Xcel Energy•Denver, CO

About The Position

Are you looking for an exciting job where you can put your skills and talents to work at a company you can feel proud to be a part of? Do you want a workplace that will challenge you and offer you opportunities to learn and grow? A position at Xcel Energy could be just what you’re looking for. Position Summary This position is responsible for the analysis and reporting of project and business unit financials, and project controls support for project lifecycle execution on organizationally strategic projects. Coordinate with Project Managers to assemble budget and forecast data to provide integrated reporting. Supports initial and on-going project set up in financial and project tracking systems. Advise and assist in the initial development of financial work breakdown structures, accounting, estimating, schedules, and reporting. Advise and assist in the development of the schedule, work breakdown structure, resource loading & profiles, and adherence to organizational KPIs and public utility policies such as Sarbanes Oxley. Functional integration of schedule and financial software. Assists department leads with creation and coordination of short and long term budgets, forecasts, accruals, and actuals reporting. Provides regional training and mentoring to various stakeholders, project controls, and project management personnel as a subject matter expert.

Requirements

Bachelor's degree in Construction Management, Business, Finance or technical field or a combination of education and experience providing equivalent knowledge and relevant experience with project planning, cost estimating, scheduling, forecasting and financial analysis.
Minimum of five (5) years related project controls experience.
Practical knowledge of overall project control, estimating, and reporting methods.
Expert level knowledge of one or highly proficient in both: Cost control for application in project cost estimating, organization, and control. Scheduling for project planning and monitoring/control methods and practices.
Comprehensive understanding of company policies, procedures and financial obligations that would apply to projects.
Proficient in standard server software applications such as e-mail, spreadsheet, word processing, database, as well as scheduling and cost estimating software applications.

Nice To Haves

Past experience with Enterprise based project management tools such as: SAP, Primavera Unifier, Primavera P6 Scheduler, Microsoft Office Suite, Power BI, CoPilot, PowerApps, SharePoint.
Microsoft Excel Advanced Certification or similar demonstration of advanced Excel proficiency such as: data management and analysis using advanced formulas, macros and reporting techniques demonstrating advanced skills across multiple Microsoft applications.
Professional certification through PMI, ASCE, or other accredited organization.

Responsibilities

Supports the Project Managers' with standardized reporting for project level capital expenditures.
Establishes, implements and monitors the availability, accuracy and usefulness of project cost analysis reports and key performance indicators for use at the individual project level up to executive management.
Assists Project Managers and other project personnel in preparing project Cost Analysis Reports and various cost analyses.
Facilitate execution of strategic projects for all aspects of project cost controls.
Understands, demonstrates and communicates the use of Work Breakdown Structures in project cost control.
Responsible for understanding and integrating capital cost reporting tools and applications, including the Work and Asset Management System.
Demonstrates super-user capabilities with the Work and Asset Management System, and other financial systems.
Works in conjunction with Business Area Finance, Capital Asset Accounting, Tax, Regulatory finance and other areas of Xcel Energy and the business unit to facilitate integration of financial aspects and impacts for Capital Projects.
Understands Sarbanes Oxley key controls and provides and reporting and tracking for all key controls applicable to a capital project.
Performs financial controls tasks such as: Journal Entries, Capital Determinations, project status submissions, work order / PO/ PR generation, month-end and year-end financial close assistance, audit support, financial variance reviews and cash flow tracking.
Provides training for internal and external stakeholders on process and function within the overall project management process.
Provides mentoring on the work and asset management system and/or scheduling software in relation to execution, control, analysis and reporting.