Electric Vehicle Load Forecasting Analyst

Job Description

This position is focused on transportation electrification analysis and forecasting at Puget Sound Energy (PSE). The role serves as a critical link between transportation electrification trends and PSE's business planning processes, requiring deep understanding of business activities, coordination and intelligence gathering across multiple PSE departments, and quantitative skills to develop queries and models that support the understanding of transportation electrification trends in PSE’s service area. 

The position has two main analytical responsibilities:

1. Current Impact Analysis - Understanding how transportation electrification is currently affecting PSE's customer growth and electrical load
2. Future Impact Forecasting - Projecting how transportation electrification will impact PSE's customer growth and load in the future, providing essential inputs for PSE's load forecasting models

The information and processes developed by this position directly support PSE's load forecasting function, which in turn enables other critical long-term planning functions including Resource Planning, Financial Planning, System Planning and Rates & Regulatory.

This role requires coordination among multiple groups to either utilize existing data or develop new processes to track the impacts of PSE's transportation electrification activities.

Upholds the safety compliance standards inherent in PSE’s operating and/or field procedures related to work responsibilities. Promotes and supports a culture of total safety.

Demonstrates commitment to conduct business honestly, ethically, and consistent with our core values and Code of Conduct.  Ensures duties are performed in accordance with all regulatory compliance obligations.

Job Responsibilities

• Manages annual adoption and load forecast updates developed by external vendor, including oversight of external vendor contracts and developing scopes of work as needed.
• Responsible for cross-team collaboration to build and maintain comprehensive records of PSE's existing EV data sources and models.
• Spearheads development of new modeling requirements to enhance forecasting capabilities related to impacts of EV adoption and charging.
• Conducts analyses related to growth and load impacts and the forecast using PSE systems, AMI interval data, and other data sources.  Ingests and prepares data for PSE’s load forecast.
• Monitors actual EV trends related to EV adoption, PSE customer growth, and load impacts, as well as new PSE programs and rates involving electric vehicles.
• Identifies data needed to track actual EV activity in PSE's service area, and collaborates with various PSE teams to develop reports and communications.
• Develops/improves processes for more geographically granular forecasting/planning.
• Maintains knowledge of current and potential policy changes impacting EV adoption and charging infrastructure at federal, state, and local levels.
• Participates in external stakeholder conferences and workshops on behalf of PSE as needed.
• Creates comprehensive dashboards and reports to consolidate transportation electrification intelligence across the organization.

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

• Ph.D. or master’s degree in business, economics, engineering, finance, mathematics, or related field.
• Experience in economic or energy-related forecasting, data science, energy efficiency evaluation or related field.
• Demonstrated experience with statistical analyses, forecasting and econometric theory.
• Experience with SAS, SQL, R, Python or other data analytic programming tools.
• Experience with SAP BW, SAP HANA, PI.
• Experience with databases and using database applications to support analysis.
• Experience with data visualization and dashboard reporting software such as Tableau or Power BI.
• Superior Excel spreadsheet skills including development of charts, and familiarity with the other Microsoft applications such as Outlook, PowerPoint, Word, Teams, and SharePoint.
• Knowledge of energy forecasting tools such as Itron MetrixND/LT and Forecast Manager, LoadSEER, and EViews.
• Demonstrated creative problem-solving abilities, excellent communication skills, and experience collaborating across multiple groups within an organization.

Additional Information