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