Senior Energy Resource Planning Acquisition Analyst (Anaplan)

About the role

Puget Sound Energy's Resource Acquisition Analytics team is hiring a Senior Energy Resource Planning Acquisition Analyst (Anaplan) in Bellevue, WA, working hybrid. The role covers quantitative and qualitative analysis of long-term energy resource planning and acquisition, including detailed financial proformas, and involves building consensus on analytical approaches and communicating results to external stakeholders. Specific work arrangements are discussed during the interview.

Key responsibilities

• Plan, develop consensus on and perform long-term resource analysis using models such as Aurora, spreadsheets and other analytical tools
• Build financial models in Anaplan and manage complex data on electric generation resources
• Develop input databases for long-term resource planning and assess business questions with appropriate analytical methods
• Serve as task lead for financial forecasts on revenue requirements, operating expenses, capital expenditures, EBITDA and net income for resource acquisition candidates
• Research energy industry and policy issues and communicate results in writing and in presentations
• Work with external stakeholders to build consensus on resource planning and acquisition issues
• Monitor energy load and supply trends locally, statewide, regionally and nationally and incorporate them into models
• Create communication materials such as PowerPoint slides and charts

Required profile

• Bachelor's degree in Business, Economics, Engineering, Finance, Math or a related field
• Seven years of relevant work experience, including five in an energy-related industry performing complex analysis
• Experience building complex spreadsheets to analyze questions
• Supportive team member with solid written, interpersonal and group communication skills

Required skills

• Anaplan modeling
• Aurora, Plexos or similar long-term resource planning models (desired)
• Data visualization tools such as Power BI (desired)
• Python, SQL, machine learning and AI tools (desired)

What we offer

• Pay range of $108,200 to $180,200, 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 and paid time off and holidays
• 401(k) and a cash balance retirement plan