Senior Energy Resource Planning Acquisition Analyst - Anaplan

Job Description: Performs quantitative and qualitative analysis related to long-term energy resource planning and/or acquisition, including creation and modification of detailed financial proformas in support of resource acquisitions. Develops and builds interdepartmental consensus on analytical approaches and related critical input assumptions that will shape the Company's long-term resource strategy and/or its implementation. Researches trends in long-term energy markets including policy issues that will impact the Company's long-term resource strategy. Effectively communicates 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: Plans, develops interdepartmental consensus on, and performs long-term resource analysis using models such as Aurora. Plans, develops interdepartmental consensus on, builds, and performs long-term resource 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. Assesses complex business questions, identifies appropriate analytical methodologies, technologies, and tools, and develops effective analytical solutions. Develops input databases necessary to perform long-term resource planning analysis. Identifies and develops means to address critical energy policy issues that may affect the Company's long-term resource strategy. Serves as task lead for preparation of financial forecasts related to revenue requirements, operating expenses, capital expenditures, EBITDA, net income for resource acquisition candidates. Researches energy industry issues and summarizes implications. Performs long-term resource analysis to support resource acquisitions. Effectively communicates results of research and analyses both written and in presentations. Works with external stakeholders to develop consensus around resource planning 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 incorporates that data into the models as necessary. Creates communication materials, such as PowerPoint slides, charts, etc. Performs other duties as assigned.

Minimum Qualifications: Bachelor's Degree in Business, Economics, Engineering, Finance, Math, or related field. Seven (7) years of relevant work experience, including five (5) 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. 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/or 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 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 Information: The pay range for this position is$108,200.00-$180,200.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. Puget Sound Energy is committed to providing equal employment opportunity to all qualified applicants. We do not discriminate on the basis of race, color, religion, sex, national origin, age, sexual orientation, gender identity, marital status, veteran status or presence of a disability that with or without reasonable accommodation does not prevent performance of the essential functions of the job, or any other category prohibited by local, state or federal law. Should you have a disability that requires assistance and/or reasonable accommodation with the job application process, please contact the Human Resources Staffing department at jobs@pse.com or 425-462-3017.