Lead Financial Analyst - Power Portfolio Strategy (Depending on Experience)

Grant PUD•Ephrata, WA

27d•$86,570 - $191,318•Hybrid

About The Position

The Power Portfolio Strategy business unit’s Financial Analyst – Data Analysis, Reporting, Systems Integration (FA-DARSI, FA- DARSI, LFA- DARSI), scope of work for Grant PUD’s power portfolio management includes: (1) Data Analyses, (2) Power/Risk Reporting, (3) Systems Integration. Further, DARSI Financial Analysts are responsible for assessing, monitoring, reporting, and communicating financial and business analytics for all commercial activities regarding the power commodity at Grant PUD. This position will be focused on data architecture in support of analytical functions within ESM; to ensure data quality and consistency within ESM and with the data shared outside of ESM.

Requirements

Bachelor’s degree in finance, accounting, economics, or related field OR two years additional relevant experience in lieu of degree.
Eight (8) or more years of experience in Finance, Economics, Energy Risk, Data Analytics, or related area.
Bachelor’s degree in finance, accounting, economics, or related field OR two years additional relevant experience in lieu of degree.
Five (5) or more years of experience in Finance, Economics, Energy Risk, Data Analytics, Data Science, Statistics, Computer Science or related area.
Bachelor’s degree in finance, economics, Data Science, Statistics, Computer Science or related field OR two years additional relevant experience in lieu of degree.
Two (2) or more years of experience in Finance, Economics, Energy Risk, Data Analytics, or related areas.

Nice To Haves

Master’s degree in finance, accounting, economics, Data Science, Statistics, Computer Science.
Knowledge/advance knowledge in financial analytics
Knowledge/advance knowledge of Microsoft office suite or Microsoft 365
Applicable Washington statutes, policies, rules, regulations, and codes
State and Federal regulations, policies, and laws affecting the utility industry
Organization and prioritization
Problem-solving skills
Written and oral communication and presentations and preparing high quality research, reports, and other written work products

Responsibilities

Directs and oversees the process for monitoring, and reporting for portfolio modeling, resource planning, and/or energy risk that support the improvement in accuracy and maturity of the energy analytics functions.
Will also be responsible for developing systems integration plans, creating sustainable workflows and processes for others to utilize in analyses. This integration will be both internal systems as well as external. ESM will be working with various vendors and external stakeholders requiring integration and communication. This position will lead those efforts.
Develop and implement a system of data management, pipelines that facilitates ESM workflows (IRP develop, Portfolio modeling, markets integration, etc.
Direct and execute the process for storing, updating and modifying assumptions for energy valuation, resource planning, and/or energy risk studies (including the energy risk register)
Direct and execute research for energy valuation, resource planning, and/or energy risk and communication or research to internal and external stakeholders
Collaborate with IT, Control System Engineers, and vendors to identify integration needs and define technical requirement.
Leads coordination with other Grant PUD business units for gathering information and data on work that impacts energy valuation, resource planning, and/or energy risk, and Serves in the capacity as Project Manager to analyze business and technical requirements to design integration solutions, document integration processes, and ensure compliance with data governance policies and best practices.
Assists the analysis, monitoring, and reporting for energy valuation, resource planning, and/or energy risk that support the improvement in accuracy and maturity of the energy analytics functions.
Key responsibilities and tasks for managing the energy risk register include, but are not limited to: Assisting with financial modeling and development of energy valuation, resource planning, and/or energy risk studies, Assisting with the process for updating and modifying assumptions for energy valuation, resource planning, and/or energy risk studies (including the energy risk register), Collaborate with trading, forecasting, and accounting teams to streamline data workflows and reporting processes Facilitate the exchange of data between internal and external groups.
Assisting with the implementation of new financial models, analysis, and parameters used in the Power Portfolio model, Automate routine data tasks and reporting pipelines using tools such as SQL, Python, or Power BI Assisting with research for energy valuation, resource planning, and/or energy risk and communication of research to internal and external stakeholders, Assists with coordination with other Grant PUD business units for gathering information and data on work that impacts energy valuation, resource planning, and/or energy risk, and Occasional presenting to the key stakeholders including the Grant PUD’s Executive Leadership, the Commission, and ESM’s Leadership Team.
Assists the monitoring, tracking, and reporting for risk analytics that support the improvement in accuracy and maturity of the energy risk register.
Key responsibilities and tasks for managing the energy risk register include, but are not limited to: Develop, maintain, and enhance data models and dashboards to support power supply planning. Ensure data integrity and accuracy across internal systems and external data sources. Assisting with the process for updating and modifying assumptions for energy valuation, resource planning, and/or energy risk studies, Assisting with the implementation of new financial models, analysis, and parameters used in the Power Portfolio model, Collaborate with trading, forecasting, and accounting teams to streamline data workflows and reporting processes, Assists with coordination with other Grant PUD business units for gathering information and data on work that impacts portfolio modeling, resource planning, and/or energy risk, and Occasional presentation to the key stakeholders including the Grant PUD’s Executive Leadership, the Commission, and ESM’s Leadership Team.