Xcel Energy Strategic Resource Planning Analyst Job in Denver, Colorado

Location(s): CO - Denver

Are you looking for an exciting job where you can put your skills, talents and education 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 professional position at Xcel Energy could be just what you’re looking for.


Develops and maintains historic and predictive models and forecasts of short- and long-term workload and manpower resources. Designs and performs quantitative studies and presents recommendations in support of strategic workload and manpower resourcing for Xcel Energy Distribution design, construction and maintenance activities. Continually defines and coordinates existing and future data requirements for the analysis necessary to optimize the accomplishment of Xcel Energy Distribution and Strategic Resource Planning. Contributes to a high-performing, motivated workgroup by applying statistical, analytical, interpersonal communication and collaboration skills to achieve financial and performance goals and metrics.

Essential Responsibilities

  • Develop and maintain historic and predictive models and forecasts of the economic, workload and workforce factors that impact the accomplishment of Xcel Energy Distribution capital, O&M and reliability commitments in a timely and cost effective manner. Entails performing data acquisition, analysis, output interpretation and result presentations. Prepare multiple scenarios and perform sensitivity testing.

  • Design and perform quantitative analysis of financial, workload and manpower data from multiple corporate systems utilizing a variety of query and analysis applications in support of work force planning and utilization. Respond to business unit requests for analyses in support of their resource decision-making. Prepare reporting (routine and ad hoc) and presentations for Asset Management, OpCo leadership and Field Operations based on analysis and modeling results.

  • Support the creation and maintenance of annual workload-to-resource plans for OpCo Distribution design, construction and maintenance activities. Perform quarterly statistical post-plan implementation effectiveness evaluations as part of process improvement.

  • Continually define and coordinate existing and future data requirements to optimize the accomplishments of Xcel Energy Distribution and the effectiveness of Strategic Resource Planning. Provide consultation and recommendations on appropriate query tools utilization, statistical methodologies and database applications. Assist in developing new processes to increase efficiencies and enhance reporting capabilities

  • Interface with personnel from Business Systems, Asset Management, Investment Delivery, Business Operations and Planning, Financial Operations and Human Resources in order to ensure data availability, integrity and quality.

  • Work directly with IT technical support personnel in the development, enhancement and maintenance of various information repositories and metric reporting systems necessary to plan and manage the Distribution Design, Construction and Maintenance workload.

  • Lead and/or perform special projects as needed


  • Bachelor's degree in Finance, Economics, Mathematics, Market Research, or Business

  • 5 years of experience in database development, quantitative/statistical analysis and historical/predictive modeling and forecasting

  • Demonstrated proficiency in a wide range of database programs, analytical and reporting tools; may include but is not limited to Excel, Access, Passport, work management software, SPSS, SQL, Brio, Crystal and web-based applications

  • Demonstrated advanced skills in problem solving, negotiating, oral and written communication of technical information, customer service and relationship development

  • Demonstrated ability to identify opportunities for improvement or synergies that lead to goal achievement


  • Advanced degree

As a leading combination electricity and natural gas energy company, Xcel Energy offers a comprehensive portfolio of energy-related products and services to 3.4 million electricity and 1.9 million natural gas customers across eight Western and Midwestern states. At Xcel Energy, we strive to be the preferred and trusted provider of the energy our customers need. If you’re ready to be a part of something big, we invite you to join our team.

Posting Notes: CO - Denver || CO - Denver || United States (US) || Operations || 58670:Gas System Strt and Bus Ops XS || Full-Time || Non-Bargaining ||

Requisition Number: 8971

Equal Opportunity Employer: Minority/Female/Disability/Veteran

Individuals with a disability who need an accommodation to apply please contact us at recruiting@xcelenergy.com