Energy Resource Planning Acquisition Analyst - Anaplan

Puget Sound Energy; Bellevue (WA); Sur place; USD 82 000 - 136 000; Plein temps

Avantages offerts par ce poste

Medical, dental, vision insurance

Paid time off and holidays

401(k) and cash balance retirement

Résumé du poste

Puget Sound Energy is seeking a qualified Energy Resource Planning Acquisition Analyst - Anaplan to support the company's Integrated Resource Plan and related financial modeling.

The role involves building models in Anaplan, analyzing long-term energy resources, and communicating results to stakeholders. Collaboration with senior staff and cross-functional teams is essential, with emphasis on data-driven decision making.

Qualifications

• Bachelor's degree or higher in a relevant field specified by the employer.
• 5 years of complex analytical experience or 3 years in energy analytics.
• Experience building complex spreadsheets for analysis.
• Strong communication and teamwork skills.

Responsabilités

• Performs long-term resource analysis using models like Aurora, Plexos, and Excel.
• Develops and maintains input/output data bases for long-term resource planning.
• Builds financial models in Anaplan.
• Manages data related to electric generation resources using Anaplan and advanced spreadsheets.
• Communicates results via visuals, reports, dashboards for management and stakeholders.
• Researches energy policy issues affecting long-term resource strategy.
• Prepares financial forecasts including revenue, Opex, capex, EBITDA, and net income.
• Creates documents and presentations to communicate research results.
• Develops analyses and research per senior staff directions.
• Produces communication materials such as PowerPoint slides and visualizations.

Connaissances

Analytical thinking

Team collaboration

Strong communication

Policy research

Formation

Bachelor's degree in Business, Economics, Engineering, Finance, Math, or related field

Master's degree in Business, Economics, Engineering, Finance, Math, or related field

Outils

Aurora

Plexos

Excel

Anaplan

Power World

Python

SQL

Sendout

Description du poste

Puget Sound Energy is looking to grow our community with top talented individuals like you! With our rapidly growing, award winning energy efficiency programs, our pathway to an exciting and innovative future is now.

PSE'sResource Acquisition Analyticsteam is looking for qualified candidates to fill anopenEnergy Resource Planning Acquisition Analyst - Anaplanposition!

Specific details regarding the work arrangements for this position will be discussed in further detail during the interview process.

Job Description

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.

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.

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 Information

The 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 pageWhy 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 [e-mail] or 425-462-3017.