Energy Resource Planning Acquisition Analyst - Anaplan

Puget Sound Energy is looking to grow our community with top talented individuals like you! With our rapidly growing, award winning energy efficiency programs, our pathway to an exciting and innovative future is now.

PSE's Resource Acquisition Analytics team is looking for qualified candidates to fill an open  Energy Resource Planning Acquisition Analyst - Anaplan  position!

Specific details regarding the work arrangements for this position will be discussed in further detail during the interview process.

Job Description

Please note that the Consulting Energy Resource Planning Acquisition Analyst - Anaplan (6658) & Senior Energy Resource Planning Acquisition Analyst - Anaplan (6659) & Energy Resource Planning Acquisition Analyst - Anaplan (6660) are linked job postings for one opening. Please apply to the role that best matches your qualifications.

Assists and performs quantitative and qualitative analysis related to long-term energy resource planning for the Company’s Integrated Resource Plan and/or creation and modification of detailed financial proformas in support of resource acquisitions. Assists with building interdepartmental consensus on analytical approaches and related critical input assumptions that will shape the Company’s long-term resource strategy. Researches trends in long-term energy markets including policy issues that will impact the Company’s long-term resource strategy, under direction of senior staff. Supports efforts to effectively communicate analytical methods, assumptions, and results with key external stakeholders to lay the foundation for recovering costs of future resource acquisitions.

All PSE employees are expected to uphold the safety compliance standards inherent in PSE’s operating and/or field procedures related to work responsibilities and promote and support a culture of total safety. Additionally, employees need to demonstrate commitment to conduct business honestly, ethically and consistent with our core values and Code of Conduct. All duties are to be performed in accordance with all regulatory compliance obligations.

Job Responsibilities

• Performs long-term resource analysis under direction of senior staff using models such as Aurora, Plexos, and Excel.
• Develops and maintains input and output data bases necessary to perform long-term resource planning analysis using spreadsheets and other analytical tools.
• Builds financial models in Anaplan.
• Manages complex data related to electric generation resources using Anaplan, moderately complex spreadsheets, scripting languages and other tools.
• Communicates complex analytical results through data visualization, charts, presentations, dashboards, and clear narrative formats for technical, business, senior management, regulatory, and external stakeholder audiences.
• Researches critical energy policy issues that may affect the Company’s long-term resource strategy.
• Prepares financial forecast related to revenue requirements, operating expenses, capital expenditures, EBITDA, net income for resource acquisition and integration candidates.
• Researches energy industry issues and summarizes implications.
• Performs analysis to support resource acquisitions.
• Develops written documents and presentations to effectively communicate results of research and analyses.
• Develops and performs analysis and research at the direction of senior staff.
• Creates communication materials, such as PowerPoint slides, visualizations, etc.
• Performs other duties as assigned.

Minimum Qualifications

• Bachelor’s Degree in Business, Economics, Engineering, Finance, Math, or related field.
• Five (5) years of relevant work experience involving performance of complex analysis or three (3) years of experience in an energy-related industry involving performance of complex analysis. 
• Experience building complex spreadsheets to analyze questions.
• Demonstrated ability to be a supportive team member.
• Solid written, interpersonal, and group communication skills.

Desired Qualifications

• Master’s Degree in Business, Economics, Engineering, Finance, Math, or related field.
• Experience using Aurora, Sendout, Power World, or other models used for long-term resource planning.
• Experience building models in Anaplan.
• Experience with cloud-based analytical platforms, machine learning techniques, advanced data-science methodologies, and artificial intelligence tools.
• Experience with data visualization tools such as Power BI.
• Experience automating processes using Python or other scripting languages and SQL databases.
• Experience processing, cleansing, validating, and organizing data for analytical applications.
• Experience performing statistical analysis.
• Demonstrated creative problem solving abilities.
• Experience analyzing risk.
• Experience creating and using database applications to support analysis.

Additional Information

At PSE, we value our employees and provide them with opportunities to excel. We offer a competitive and comprehensive total rewards package. To learn more about why PSE is a great place to work, see our Employee Value Proposition , which highlights our commitment to employee growth, work-life balance, and meaningful career opportunities in the energy sector.

The pay range for this position is $82,000.00 - $136,300.00, and this position is eligible for annual goals based incentive bonuses. 

PSE offers a suite of benefits to our employees. Employees are eligible for medical, dental, vision, basic life, and short- and long-term disability insurance. There are additional voluntary options of supplemental life insurance, accidental death and dismemberment insurance, flexible spending accounts for health care and dependent daycare, and an Employee assistance program (EAP). For long term savings, PSE offers a 401(k) investment option and a cash balance retirement plan. Employees will also receive Paid Time Off (PTO) and Paid Holidays throughout the calendar year. Detailed benefit overviews can be found on our Career page - Why Work For Us (pse.com) .  

Families and businesses depend on PSE to provide the energy they need to pursue their dreams. Our steadfast commitment to serving Washington communities with safe, dependable and efficient energy started in 1873. Today we're building the Northwest's energy future through efforts like our award winning energy efficiency programs and our leadership in renewable energy. 

Puget Sound Energy is committed to providing equal employment opportunity to all qualified applicants. We do not discriminate on the basis of race, color, religion, sex, national origin, age, sexual orientation, gender identity, marital status, veteran status or presence of a disability that with or without reasonable accommodation does not prevent performance of the essential functions of the job, or any other category prohibited by local, state or federal law.

Should you have a disability that requires assistance and/or reasonable accommodation with the job application process, please contact the Human Resources Staffing department at View email address on us.fitly.work or View phone number on us.fitly.work.