Energy Forecast Analyst II

Summary

The Energy Forecast Analyst II role provides hydro model expertise and analysis supporting and enhancing the operational performance of NYPA’s Energy Portfolio Modeling & Forecasting team.  This position requires working with NYPA’s Engineering department to enhance the accuracy of Hydro flow and internal generation models, with specific focus on the revenue forecasts for the Niagara and St. Lawrence projects that are used for financial planning purposes.  Relevant hydro data such as monthly precipitation, water levels, outflows, and analysis of the various Great Lakes basin supply will need to be stored and evaluated to ensure model results consistent with current conditions.  The hydro forecasts, and their accuracy, will be tracked and presented to executive management.  

In addition, the Energy Forecast Analyst II will help support the Energy Commodity Risk Management System (ECRM) used for valuing NYPA’s assets, trade capture, risk, and settlement functions.  The analytics associated with these tasks will support strategic business decisions around the asset portfolio and revenue preservation. Overseeing the day-to-day operation of the ECRM includes analysis of routine daily/weekly studies, adhoc evaluations of new products and configurations, working in concert with NYPA IT/contracted vendors, troubleshooting, prepping and implementing annual updates and new model assumptions, etc.     

Candidates for this role should possess insightful research capabilities, strong technological skills (experience with MS Office, PowerPoint, Excel, and Power BI with knowledge of Python programming a plus), and communication/presentation skills. In addition, the position is responsible for consistent reporting, monitoring performance and managing special projects that will enable the Energy Portfolio Management team to better align with NYPA’s VISION 2030 and business objectives. #LI-VB1
 

Responsibilities

• Support NYPA’s annual/monthly LFRP (Long Range Financial Plan) & COS (Cost of Service) process & deliver required generation dispatch, load forecasts, revenue forecast, fuel expense forecast, capacity forecasts 
• Develop PowerPoint Slides, Scatter Plot Analysis, Box and Whisker Charts, Line/Bar Graphs, Tableau Dashboards, Power BI and Excel Macros based on critical information relevant to ERM business line.
• Review & report past transaction performance metrics, variances and KPIs as they relate to NYPA’s portfolios & targets
• Stay current with NYISO procedures, market issues and reports.
• Provide support to internal/external stakeholders for all Market transaction & forecasting related matters, inquiries, and analytics; this includes, Accounting, Financial Planning, Enterprise Risk, Demand Response, Pricing, NYISO, FERC, NERC, NPCC, IOUs, etc
• Work with NYPA’s Engineering department to enhance the accuracy of Hydro flow and internal hydro generation models.
• Track and evaluate relevant hydro data to ensure hydro model results are consistent with current conditions.
• Help oversee and support the Energy Commodity Risk Management System’s (ECRM) deal capture, asset models, and portfolio risk analytics. 
• Research, test, & assist in the implementation of updates and changes to the ECRM system.

Knowledge, Skills and Abilities

• Knowledge of Wholesale Electricity Market, Fuel Markets and/or associated Financial products.
• Strong business, statistical, financial and reasoning skills
• Advanced analytical and communication skills 
• General knowledge of accounting practices 
• Strong understanding of the economic impact of decisions within the position’s scope of authority.
• Skilled at adapting, multitasking and performing under pressure
• Able to work independently with minimal daily supervision
• Ability to apply Statistical Analysis and Financial Modeling on relevant data sets
• Knowledge of corporate strategies and goals, market rules and regulations, risk management protocols, and trade life cycle.
• Ability to propose strategies to react to a changing marketplace 
• Preferred experience of SAP, Allegro, Ascend, Tableau, Power BI & GE-MAPS
• Preferred experience in database programming and querying using SQL, MS Access, VBA, SAS, Oracle or other.

Education, Experience and Certifications

• Bachelor's degree in Business Analytics, Economics, Finance, Accounting, Mathematics, Computer Science, Statistics or related discipline required. 
• Minimum of 4 years of related experience in an analytical role or equivalent combinations of education & experience. 
• Utility or Energy Company experience preferred 
   

Physical Requirements