Position Summary
This position is responsible for the development and analysis of cost analysis reports, development and analysis of project schedules, support for project lifecycle execution or a combination there of on organizationally strategic projects. Coordinate with Project Managers to assemble the budget and forecast data to provide integrated reporting. Supports initial and on-going project set up in the work and asset management system. Advise and assist in the initial development of financial work breakdown structure, accounting, and reporting. Advise and assist in the development of the schedule work breakdown structure, resource loading & profiles, and adherence to organizational performance index. Functional integration of schedule and financial software. Assists department leads with creation and coordination of short and long term work profiles. Provides regional training and mentoring to various stakeholders and project control personnel as a subject matter expert.
Essential Responsibilities
a) Supports the Project Managers' with standardized reporting for regional capital project stakeholders regarding project level business area 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.
b) Develop, maintain and promote project schedules as a project management tool. Progressively elaborate schedule details to identify critical path. Support Project Managers by assessing the reporting of work progress against the project baseline. Maintain subject matter expert proficiency of the corporate tool and knowledge of industry standard software tools.
c) 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.
d) 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.
e) Works in conjunction with Capital Project Analyst, Capital Asset Accounting, Tax, Regulatory finance and other areas of Xcel Energy and the business area 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.
f) 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.
Explain what the scope of the work/project is? Project Overview, deliverables (what is this person
responsible for).
This role supports the Gas Capital Portfolio through detailed analysis of project and operational data. The
Analyst will collect, analyze, validate, and interpret large data sets to identify trends, explain variances,
support business decisions, and provide insights to leadership. The role is highly analytical and requires
someone who enjoys working deeply within data while also being able to communicate findings to
stakeholders. The manager described this role as being more focused on analyzing and interpreting data
than the Project Coordinator position.
What are the top 3-5 skills and qualifications (technology/application/software, etc.) required?
The ideal candidate can:
Dive deeply into data
Analyze and interpret results
Explain trends and variances
Provide actionable insights
Translate data into business recommendations
Support leadership decision-making
The manager indicated that leadership ultimately helps guide decisions, but the Analyst should be capable of interpreting
data and helping tell the story behind it rather than simply providing raw reports.
2. Are there any preferred or "nice to have" skills?
Utility industry experience
Regulated industry experience
Capital project analytics
Financial analysis
Dashboard development
Data visualization
Executive reporting