Gas Resource Planning Analyst

Xcel Energy•Denver, CO

3d•$84,900 - $120,566•Hybrid

About The Position

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. 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.

Requirements

BS degree in Economics, Finance, Mathematics, Engineering, or closely related field. Equivalent work experience may be accepted in lieu of a degree.
Minimum of 2 years of natural gas or electric industry experience, preferably in resource planning, design day modeling, or related areas of identifying, forecasting, and delivering energy resources.
Knowledge of linear programming and model development required.
Must have financial analysis skills to evaluate and compare service opportunities, written communication skills to prepare regulatory filings and testimony, and attention to detail to ensure accuracy of modeling.

Nice To Haves

Knowledge of the natural gas industry and understanding of the various natural gas markets.
Knowledge of Plexos.
Master's degree.
Database Management Skills.

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.