Share this Job

Strategic Resource Planning Analyst Job

Date: Dec 1, 2018

Location: CO - Denver, US, 80202

Company: Xcel Energy

Location(s): CO - Denver; MN - St Paul


Do you want to have an essential role supporting the energy infrastructure that provides power to millions of homes and businesses? Do you want to build a long-term career in a stable industry at a company that’s committed to treating you with respect, training you well and ensuring your safety? Consider a position within Xcel Energy’s natural gas operations.



Develops and maintains historic and predictive models and forecasts of short- and long-term Gas Capital and O&M budgets. Designs and performs quantitative studies and presents recommendations in support of strategic workload and manpower resourcing for Xcel Energy Gas 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 Gas 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 Gas 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.
  • Maintain Project Portfolio Management system including the prioritization of projects and funding activities needed to support them.
  • Continually define and coordinate existing and future data requirements to optimize the accomplishments of Xcel Energy Gas and the effectiveness of  Gas Strategy. 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 Gas Design, Construction and Maintenance workload.
  • Lead and/or perform special projects as needed

Minimum Requirements

  • 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

Preferred Requirements

  • Advanced degree
  • SAP Experience





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; MN - St Paul || United States (US) || Operations || 58665:Gas Investment Delivery XS || Full-Time || Non-Bargaining ||

Requisition Number: 14752

Equal Opportunity Employer: Minority/Female/Disability/Veteran

Individuals with a disability who need an accommodation to apply please contact us at

Nearest Major Market: Denver

Job Segment: Strategic Planning, ERP, Sustainability, Strategy, Technology, Energy