Gas Resource Planning Analyst

Xcel Energy; Denver (CO); Hybrid; USD 85,000 - 121,000; Full time

Benefits offered by this job

Annual Incentive Program

Medical/Pharmacy Plan

Dental

Vision

401(k)

Job summary

Xcel Energy seeks an experienced analyst to evaluate gas supply plans for both distribution and electric generation. You will model portfolios, forecast gas needs, and support cost recovery filings.

The role emphasizes financial analysis, regulatory testimony, and collaboration with the Gas Supply team. Responsibilities include designing long-range gas supply plans, developing period forecasts, and defending filings before regulators to protect shareholder value.

Qualifications

• Minimum BS in Economics, Finance, Mathematics, Engineering, or related field.
• 2+ years in natural gas or electric industry, preferably in resource planning or modeling.
• Knowledge of linear programming and model development.
• Strong financial analysis, written communication for regulatory filings, and attention to detail.

Responsibilities

• Develop/run/maintain long-range resource modeling for gas supply portfolios.
• Create Design Day forecasts for peak gas requirements across units.
• Prepare and defend regulatory filings to recover costs in the $2B budget.
• Perform financial analysis of interstate and intrastate pipeline rate cases.
• Support litigation with financial models and testimony.

Skills

Financial analysis

Linear programming

Regulatory testimony writing

Attention to detail

Modeling

Education

Bachelor's degree in Economics, Finance, Mathematics, or Engineering

Master's degree

Tools

Plexos

Database Management

Job description

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 SummaryAssist 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 ResponsibilitiesDevelop/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 RequirementsBS 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.Preferred RequirementsKnowledge of the natural gas industry and understanding of the various natural gas markets.Knowledge of Plexos.Master's degree.Database Management Skills.Our culture is grounded in shared values and employee commitments that guide how we work, support one another, and grow together.Our ValuesConnected, Committed, Trustworthy, SafeOur Employee CommitmentsWork that makes a differenceA team you can count ofOpportunities to growRewards that help you thriveXcel Energy provides job applicants reasonable accommodations for disabilities throughout the application process. If you are in need of an accommodation to complete the application process, now or at any time in the future, please complete the Applicant Accommodation Request Form.Non-BargainingThe anticipated starting base pay for this position is: $84,900.00 to $120,566.00 per yearThis position is eligible for the following benefits: Annual Incentive Program, Medical/Pharmacy Plan, Dental, Vision, Life Insurance, Dependent Care Reimbursement Account, Health Care Reimbursement Account, Health Savings Account (HSA) (if enrolled in eligible health plan), Limited-Purpose FSA (if enrolled in eligible health plan and HSA), Transportation Reimbursement Account, Short-term disability (STD), Long-term disability (LTD), Employee Assistance Program (EAP), Fitness Center Reimbursement (if enrolled in eligible health plan), Tuition reimbursement, Transit programs, Employee recognition program, Pension, 401(k) plan, Paid time off (PTO), Holidays, Volunteer Paid Time Off (VPTO), Parental LeaveBenefit plans are subject to change and Xcel Energy has the right to end, suspend, or amend any of its plans, at any time, in whole or in part.In any materials you submit, you may redact or remove age-identifying information including but not limited to dates of school attendance and graduation. You will not be penalized for redacting or removing this information.Deadline to Apply: 10/19/26EEO is the Law (PDF) | Equal Opportunity Statement (PDF) | Employee Rights (PDF)All Xcel Energy employees and contractors share responsibility for protecting the company's information and systems by adhering to cybersecurity policies, standards, and best practices, recognizing that cybersecurity is everyone's responsibility.Accessibility StatementXcel Energy endeavors to make https://www.xcelenergy.com and https://jobs.xcelenergy.com accessible to any and all users. If you are in need of an accommodation to complete the application process, now or at any time in the future, please complete the Applicant Accommodation Request Form. For any other application related questions, including application follow-ups or technical issues, please use our Recruiting Assistance, Electra, for assistance. Electra can be found in the lower right-hand corner of our Xcel Energy Careers site.