Consulting Energy Resource Planning Acquisition Analyst - Anaplan

Job Description

Please note that the Consulting Energy Resource Planning Acquisition Analyst - Anaplan (6658) & Senior Energy Resource Planning Acquisition Analyst - Anaplan (6659) & Energy Resource Planning Acquisition Analyst - Anaplan (6660) are linked job postings for one opening. Please apply to the role that best matches your qualifications.

Develops quantitative and qualitative analytical and research methods to support long-term energy resource planning and acquisition including creation and modification of detailed financial proformas in support of resource acquisitions. Leads efforts to build interdepartmental consensus on analytical approaches and related critical input assumptions that will shape the company's long-term resource strategy. Coordinates and oversees research activity to identify trends in long-term energy markets including policy issues that will impact the company's long-term resource strategy. Leads and develops communication processes to effectively communicate analytical methods, assumptions, and results with key external stakeholders to lay the foundation for recovering costs of future resource acquisitions.

All PSE employees are expected to uphold the safety compliance standards inherent in PSE's operating and/or field procedures related to work responsibilities and promote and support a culture of total safety. Additionally, employees need to demonstrate commitment to conduct business honestly, ethically and consistent with our core values and Code of Conduct. All duties are to be performed in accordance with all regulatory compliance obligations.

Job Responsibilities

• Develops analytical approaches, using long-term resource models, spreadsheet analysis, or other tools as necessary, 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.

Minimum Qualifications

• 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

Desired Qualifications

• 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.

Additional Information

At PSE, we value our employees and provide them with opportunities to excel. We offer a competitive and comprehensive total rewards package. To learn more about why PSE is a great place to work, see our Employee Value Proposition, which highlights our commitment to employee growth, work-life balance, and meaningful career opportunities in the energy sector.

The pay range for this position is $124,600.00 - $207,400.00, and this position is eligible for annual goals based incentive bonuses.

PSE offers a suite of benefits to our employees. Employees are eligible for medical, dental, vision, basic life, and short- and long-term disability insurance. There are additional voluntary options of supplemental life insurance, accidental death and dismemberment insurance, flexible spending accounts for health care and dependent daycare, and an Employee assistance program (EAP). For long term savings, PSE offers a 401(k) investment option and a cash balance retirement plan. Employees will also receive Paid Time Off (PTO) and Paid Holidays throughout the calendar year. Detailed benefit overviews can be found on our Career page - Why Work For Us (pse.com).

Families and businesses depend on PSE to provide the energy they need to pursue their dreams. Our steadfast commitment to serving Washington communities with safe, dependable and efficient energy started in 1873. Today we're building the Northwest's energy future through efforts like our award winning energy efficiency programs and our leadership in renewable energy.