Energy Resource Planning Acquisition Analyst - Anaplan

About the role

Puget Sound Energy's Resource Acquisition Analytics team is hiring an Energy Resource Planning Acquisition Analyst (Anaplan) in Bellevue, Washington, working hybrid. The role supports long-term energy resource planning for the Integrated Resource Plan and the creation and modification of financial proformas for resource acquisitions, and helps build consensus on analytical approaches and assumptions. Specific work arrangements are discussed during the interview.

Key responsibilities

• Perform long-term resource analysis under the direction of senior staff using models such as Aurora, Plexos and Excel.
• Build financial models in Anaplan and manage complex data on electric generation resources with Anaplan, spreadsheets, scripting languages and other tools.
• Prepare financial forecasts for revenue requirements, operating expenses, capital expenditures, EBITDA and net income for resource acquisition and integration candidates.
• Research energy policy and industry issues and summarize their implications.
• Communicate analytical results through data visualization, charts, presentations, dashboards and clear narratives for technical, business, senior management, regulatory and external stakeholder audiences.
• Write reports and create presentation materials such as PowerPoint slides and visualizations.

Required profile

• Bachelor's degree in Business, Economics, Engineering, Finance, Math or a related field.
• Five years of relevant experience performing complex analysis, or three years in an energy-related industry doing so.
• Experience building complex spreadsheets to analyze questions.
• Solid written, interpersonal and group communication skills; supportive team member.

Required skills

• Anaplan modeling
• Aurora, Plexos, Sendout or Power World (desired)
• Data visualization tools such as Power BI (desired)
• Python, SQL, machine learning and AI tools (desired)

What we offer

• Pay range of $82,000 to $136,300, with eligibility for annual goal-based incentive bonuses.
• Medical, dental, vision, basic life and short- and long-term disability insurance, plus optional supplemental life and accidental death coverage.
• Flexible spending accounts, an employee assistance program, a 401(k) and a cash balance retirement plan.
• Paid time off and paid holidays.