Gas Resource Planning Analyst

Xcel Energy (NASDAQ: XEL) is a leading energy provider and Fortune 500 company, dedicated to serving millions of electricity and natural gas customers across eight states:
Minnesota, Colorado, Wisconsin, Michigan, North Dakota, South Dakota, New Mexico and Texas. We make energy work better for our customers, helping them thrive every day. That means always raising the bar - delivering better service and providing more reliable, resilient, and sustainable energy.

Xcel Energy is a place where you’ll have opportunities to grow, expand your skills, and help lead the clean energy transition. We offer meaningful rewards, recognition, and support to help you build your career and make an impact - both on the job and beyond. Most importantly, it means you’ll be joining a company that knows employees are the driving force behind its success and is committed to helping you be your best.

Xcel Energy supports a hybrid work model to enable collaboration and flexibility. Many roles are expected to work onsite three days per week (Tuesday–Thursday); however, work location expectations vary based on role, team, and business needs.

Position Summary Assist in the evaluation of complex gas supply, transportation, and storage service plans for both the gas distribution and electric generation gas supply portfolios. Model various supply alternatives to ensure portfolio optimization, support the negotiation of fuel supply related contracts, assist in the development of gas supply forecasts, develop corporate budget forecasts, and perform financial analysis of interstate and intrastate pipeline rate cases.

Essential Responsibilities Develop/run/maintain long range, complex resource modeling for the gas supply portfolios for XE's gas and electric operations. Develop sophisticated resource models in Sendout and Plexos (portfolio optimization-linear or  stochastic  program models) to determine the optimal gas purchases for each operating business unit. Collaborate with Gas Supply to develop and implement each season's gas purchase plan estimated at $2B/year of expenditures.

Create Design Day forecast projecting peak gas requirements for gas distribution and electric generation business units. Ensure accuracy of modeling, which is critical to prevent loss of gas and electric service to customers. Use Design Day forecast to determine the variety and quantity of transportation and storage contracts held across 12 geographically dispersed pipeline systems as well as when to modify or purchase additional transportation and storage capacity, estimated at $200M per year of expenditures.

Prepare and defend extensive regulatory filings to recover the costs related to the $2B annual gas fuel budget. Create filing schedule based on modeling efforts. Provide accurate information in support of XE's requests and written descriptions of Company practices/activities to regulators to obtain state commission approval for expended costs and avoid financial loss to shareholders. Contribute to written and verbal testimony to state commissions.

Prepare financial analysis of interstate and intrastate pipeline rate cases to determine the tariff rates XE will pay after litigation or settlement of the pipeline case. Support the litigation and/or settlement of the pipeline case by preparing financial models and preparing written testimony for others.

Prepare, implement, and maintain dynamic annual and long-range gas supply plans for the gas distribution and electric generation operating units. Plan must optimize reliability and cost effectiveness of XE's $2B budget for gas supply, storage, and transportation.

Evaluate market opportunities and perform analysis on proposed transactions.

Minimum Requirements BS degree in Economics, Finance,…