Gas Supply Senior Planning - Data Analyst

Rhode Island Energy is seeking a Gas Supply Senior Planning Analyst in Cumberland, RI. This role involves executing procurement transactions, building gas supply data models, and conducting data analysis for gas supply procurement and portfolio optimization. Responsibilities include managing data analysis, developing reports, and supporting regulatory submissions. A bachelor's degree in a relevant field and five years of analytical experience are required. Proficiency in Excel, PowerBI, and Python is preferred.
Company Summary Statement : Rhode Island Energy provides essential energy services to over 770,000 customers across Rhode Island through the delivery of electricity or natural gas. Our team is dedicated to helping Rhode Island customers and communities thrive while supporting the transition to a cleaner energy future. Rhode Island Energy is part of the PPL Corporation (NYSE: PPL) family of companies addressing energy challenges head-on by building smarter, more resilient, and more dynamic power grids and advancing sustainable energy solutions. PPL is a positive force in the cities and towns where we do business, providing support for programs and organizations that empower the success of future generations by helping to build and maintain strong, diverse communities today. Overview:

The Rhode Island Energy Gas Supply Senior Planning Analyst position will report to the Manager of Gas Supply Planning & Analytics and is responsible for executing the necessary procurement and supply related transactions in accordance with approved Gas Supply department policies and procedures. The Gas Supply Senior Planning Analyst will be responsible for building and maintaining gas supply data models required to manage the portfolio requirements and subsequent regulatory filings and fulfilling requests for dashboards and reports.

The Gas Supply Senior Planning Analyst will lead and manage various data analysis to support the assessment and evaluation of potential commercial transactions associated with gas supply procurement and portfolio optimization strategies to ensure reliable, least cost service to customers.

Responsibilities:
• Executing and managing the daily, monthly, and seasonal procurement and gas supply related transactions.
• Use mathematical and analytical methodologies to assess and evaluate gas supply commercial arrangements for natural gas pipeline, storage and peaking capacity procurement, including cost projections and summaries of operational characteristics for alternative resources.
• Analyze large amounts of data to interpret patterns and trends, assess data quality, and communicate results and uncertainties associated with analysis.
• Updates, maintains, and performs analysis on various and complex spreadsheet models.
• Provide specialized analysis to support responses to internal and external data requests.
• Develop customized reports using newly installed gas management system.
• Support portfolio optimization analysis by conducting various spreadsheet analysis.
• Provide analytical support for regulatory submissions to the Rhode Island Public Utilities Commission and Division of Public Utilities and Carriers, including the Long-Range Resource and Requirements Plan (LRP) and Gas Cost Recovery (GCR) filings.
• Sponsor and support testimony with respect to various data analyses.
• Respond to discovery with respect to submitted data analysis.
• Monitor and perform special analysis, as needed, of natural gas market dynamics and regulatory developments that may affect natural gas supply planning and procurement objectives.
• Perform other duties as assigned.

Qualifications:
• Bachelor’s degree in data analytics, econometrics, quantitative finance, mathematics, or other analytical discipline.
• Five years of analytical experience.
• Proficient with Excel, PowerBI, Python, or other data analytical tools.
• Problem solving and analytical skills to work in this data intensive position.
• Excellent interpersonal and communication skills.
• Must be able to work in a team environment and particularly with the trading team to assist with deal evaluation.

Preferred Qualifications
• Master’s degree (or equivalent experience) in data analytics, econometrics, quantitative finance, mathematics, or other analytical discipline.
• Experience working for a gas utility in the gas procurement function or experience in gas supply and procurement for a market participant.
• Knowledge of New England natural gas markets and infrastructure, including gas supply, storage, and pipeline transportation.
• Experience with portfolio optimization modeling software (e.g., SENDOUT® or Plexos).
• Experience presenting to groups.
• Experience with technical report writing.