Analyst, Business, Financial Analyst

Position Summary

This position is responsible for the development and analysis of cost analysis reports, project schedules, and support for project lifecycle execution on organizationally strategic projects. The analyst coordinates with Project Managers to assemble budget and forecast data, provides integrated reporting, supports initial and ongoing project set up in the work and asset management system, and advises on the development of financial and schedule work breakdown structures.

Functional integration of schedule and financial software is managed, and regional training and mentoring are provided to project control personnel as a subject matter expert.

• 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.
• Develops, maintains and promotes project schedules as a project management tool. Progressively elaborates schedule details to identify critical path, supports Project Managers by assessing the reporting of work progress against the project baseline, and maintains subject matter expert proficiency of the corporate tool and knowledge of industry-standard software tools.
• Assists Project Managers and other project personnel in preparing project Cost Analysis Reports and various cost analyses. Facilitates execution of strategic projects for all aspects of project cost controls and 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 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 reporting and tracking for all key controls applicable to a capital project.
• Provides training for internal and external stakeholders on project management processes and mentoring on the work and asset management system and scheduling software in relation to execution, control, analysis and reporting.

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.

• Dive deeply into data
• Analyze and interpret results
• Explain trends and variances
• Provide actionable insights
• Translate data into business recommendations
• Support leadership decision-making

• Utility industry experience
• Regulated industry experience
• Capital project analytics
• Financial analysis
• Dashboard development
• Data visualization
• Executive reporting