Consulting Energy Resource Planning Acquisition Analyst - Anaplan

Puget Sound Energy • Bellevue, WA

8d • $124,600 - $207,400

About The Position

Puget Sound Energy (PSE) is seeking qualified candidates for a Consulting Energy Resource Planning Acquisition Analyst - Anaplan position within its Resource Acquisition Analytics team. This role is linked with other similar postings, and candidates should apply to the one that best matches their qualifications. The position involves developing quantitative and qualitative analytical methods for long-term energy resource planning and acquisition, including creating and modifying financial proformas. The analyst will lead efforts to build interdepartmental consensus on analytical approaches and assumptions, coordinate research on energy market trends and policy impacts, and develop communication processes for external stakeholders regarding 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.
• Ten (10) years of relevant work experience, including eight (8) years of experience in an energy related industry involving performance of complex analysis.
• Experience building complex spreadsheets to analyze questions.
• Demonstrated ability to be supportive team member.
• Demonstrated experience and ability to lead and influence cross-functional teams and stakeholders.
• Excellent interpersonal skills and ability to develop and cultivate strong working relationships with contractual counterparties, regulators and other industry participants.
• Excellent verbal and written communication skills.
• Solid written, interpersonal, and group communication skills

Nice To Haves

• Ph.D. or Master’s Degree in business, economics, engineering, finance, math, or related field.
• Experience using Aurora, Plexos, or other models used for long-term resource planning and acquisition.
• 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 performing statistical analysis.
• Demonstrated creative problem solving abilities.
• Experience analyzing risk.
• Experience creating and using database applications to support analysis.

Responsibilities

• Develops analytical approaches using long-term resource models, spreadsheet analysis, or other tools to analyze long-term resource analysis using models such as Aurora and Plexos.
• 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.
• Assesses complex business questions, identifies appropriate analytical methodologies, technologies, and tools, and develops effective analytical solutions.
• Plans, leads development of interdepartmental consensus on, builds, and performs long-term resource analysis using spreadsheets and other analytical tools.
• Directs development of input databases necessary to perform long-term resource acquisition analysis.
• Leads efforts to streamline analytical work through automation and collaboration with Information Technology.
• Identifies and oversees development of means to address critical energy policy issues that may affect the company’s long-term resource strategy.
• Serves as strategic lead on special projects, technical analysis and complex matters.
• Directs and performs research on energy industry issues and communicates implications to senior management and high-level external stakeholders.
• Develops analytical ties between resource planning and resource acquisitions.
• Creates communication strategies with regard to results of research and analyses both written and in presentations. Creates communication materials, such as PowerPoint slides, charts, etc.
• Leads efforts to communicate with external stakeholders to develop consensus around resource acquisition issues and to effectively communicate resource acquisition issues.
• Monitors energy load and supply trends and developments at the local, state, regional and national levels, and incorporate that data into the models as necessary.
• Leads, trains, and mentors staff in the development, administration, and analysis of programs to assess financial implications and alternatives of specific resource opportunities and evaluation of fuel supply alternatives.
• Performs other duties as assigned.

Benefits

• medical, dental, vision, basic life, and short- and long-term disability insurance.
• supplemental life insurance
• accidental death and dismemberment insurance
• flexible spending accounts for health care and dependent daycare
• Employee assistance program (EAP)
• 401(k) investment option
• cash balance retirement plan
• Paid Time Off (PTO)
• Paid Holidays

What This Job Offers

• Job Type: Full-time
• Career Level: Senior