Energy Resource Planning Acquisition Analyst - Anaplan

Puget Sound Energy•Bellevue, WA

8d•$82,000 - $136,300

About The Position

Puget Sound Energy (PSE) is seeking qualified candidates for an open Energy Resource Planning Acquisition Analyst - Anaplan position. This role involves quantitative and qualitative analysis for the Company’s Integrated Resource Plan and the creation/modification of financial proformas for resource acquisitions. The analyst will help build consensus on analytical approaches and assumptions that shape the Company’s long-term resource strategy. Responsibilities include researching long-term energy market trends and policy issues, supporting communication of analytical methods and results to stakeholders, and ensuring cost recovery for future resource acquisitions. All PSE employees are expected to uphold safety compliance, conduct business ethically, and adhere to regulatory obligations.

Requirements

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.

Nice To Haves

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.

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.