Job DescriptionPlease 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.Assists and performs quantitative and qualitative analysis related to long-term energy resource planning for the Company's Integrated Resource Plan and/or creation and modification of detailed financial proformas in support of resource acquisitions. Assists with building interdepartmental consensus on analytical approaches and related critical input assumptions that will shape the Company's long-term resource strategy. Researches trends in long-term energy markets including policy issues that will impact the Company's long-term resource strategy, under direction of senior staff. Supports efforts 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- Performs long-term resource analysis under direction of senior staff using models such as Aurora, Plexos, and Excel.
- Develops and maintains input and output data bases necessary to perform long-term resource planning analysis using spreadsheets and other analytical tools.
- 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.
- Researches critical energy policy issues that may affect the Company's long-term resource strategy.
- Prepares financial forecast related to revenue requirements, operating expenses, capital expenditures, EBITDA, net income for resource acquisition and integration candidates.
- Researches energy industry issues and summarizes implications.
- Performs analysis to support resource acquisitions.
- Develops written documents and presentations to effectively communicate results of research and analyses.
- Develops and performs analysis and research at the direction of senior staff.
- Creates communication materials, such as PowerPoint slides, visualizations, etc.
- Performs other duties as assigned.
Minimum Qualifications- Bachelor's Degree in Business, Economics, Engineering, Finance, Math, or related field.
- Five (5) years of relevant work experience involving performance of complex analysis or three (3) years of experience in an energy-related industry involving performance of complex analysis.
- Experience building complex spreadsheets to analyze questions.
- Demonstrated ability to be a supportive team member.
- Solid written, interpersonal, and group communication skills.
Desired Qualifications- Master's Degree in Business, Economics, Engineering, Finance, Math, or related field.
- Experience using Aurora, Sendout, Power World, or other models used for long-term resource planning.
- 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 processing, cleansing, validating, and organizing data for analytical applications.
- Experience performing statistical analysis.
- Demonstrated creative problem solving abilities.
- Experience analyzing risk.
- Experience creating and using database applications to support analysis.
Additional InformationThe pay range for this position is $82,000.00 - $136,300.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).
