Consulting Energy Resource Planning Acquisition Analyst (Anaplan)

About the role

Puget Sound Energy's Resource Acquisition Analytics team is hiring a Consulting Energy Resource Planning Acquisition Analyst focused on Anaplan. The role supports long-term energy resource planning and acquisition, including detailed financial proformas, and works closely with external stakeholders to lay the groundwork for recovering costs of future resource acquisitions. The position is listed as hybrid (Washington-based); details on work arrangements are discussed during interviews.

Key responsibilities

• Develop analytical approaches using long-term resource models, spreadsheet analysis or other tools, including models such as Aurora and Plexos.
• Build financial models in Anaplan and manage complex data on electric generation resources using Anaplan, spreadsheets, scripting languages and other tools.
• Lead interdepartmental consensus on analytical approaches and assumptions shaping the long-term resource strategy, and coordinate research on long-term energy market trends and policy issues.
• Communicate analytical results through data visualization, charts, presentations and dashboards to technical, business, senior management, regulatory and external stakeholder audiences.
• Lead and train staff on assessing financial implications of resource opportunities and evaluating fuel supply alternatives.
• Act as strategic lead on special projects, technical analysis and complex matters, and direct research on energy industry issues.

Required profile

• Bachelor's degree in business, economics, engineering, finance, math or a related field.
• 10 years of relevant work experience, including 8 years in an energy-related industry performing complex analysis.
• Experience building complex spreadsheets; proven ability to lead and influence cross-functional teams and stakeholders.
• Excellent interpersonal, verbal and written communication skills.

Required skills

• Anaplan modeling
• Aurora and Plexos (desired)
• Data visualization tools such as Power BI (desired)
• Python, SQL, cloud-based analytical platforms, machine learning and AI tools (desired)

What we offer

• Pay range of $124,600 to $207,400, 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 EAP.
• 401(k) and cash balance retirement plans, paid time off and paid holidays.