Senior Regulatory Programs Data Analyst- ONSITE

Philadelphia Gas Works•Philadelphia, PA

1d•Onsite

About The Position

The Philadelphia Gas Works (PGW) is seeking a Senior Regulatory Programs Data Analyst to serve as a business partner to the functions within Customer Affairs. This role involves translating business needs into data requirements, identifying business problems addressable through data analysis, and collecting, analyzing, and reporting data related to Customer Affairs programs, including low-income bill assistance and regulatory analytics. The position is responsible for managing all department data, designing reports, building databases, analyzing outcomes, and developing/maintaining standardized reporting tools. This role operates using data sets curated from the data team and does not involve programming.

Requirements

Bachelor’s degree in business, Business Intelligence, Finance, Economics, Statistics, or other quantitative analytical fields of study.
5 - 7 years’ experience in data analysis or other related fields.
High degree of accuracy and attention to detail.
Strong knowledge of MS Office.
Expert level knowledge of MS Excel, including the ability to write advanced formulas and use pivot tables to perform calculations.
Experience with interactive data visualization software such as Tableau.
Ability to utilize abstract reasoning techniques to build reporting logic and establish creative solutions.
Excellent verbal, written and presentation skills.
Time management skills with the ability to handle multiple projects simultaneously.
Prior experience working with significant data sets and be comfortable manipulating such data to identify trends and be able to provide recommendations to senior management.
Prior experience partnering across multiple business units.
Prior experience developing data-driven solutions to end-of-the-end business processes.

Nice To Haves

Advance degree preferred.
Knowledge of utility regulatory requirements and processes is strongly preferred.
Knowledge of utility low-income energy assistance programs is strongly preferred.
Experience with generative AI software such as ChatGPT preferred but not necessary.

Responsibilities

Provide data analytics including segmentation and statistical models.
Apply analytics and research skills to proactively identify customer programs and regulatory patterns and opportunities.
Analyze specific customer information system issues to determine business impacts, complexity, priority, and root cause.
Prepare reports of findings, illustrate data graphically, and translate complex findings into written text.
Manage annual LIHEAP/Crisis outreach and customer communications, including tracking results and providing recommendations for modifications and policy recommendations.
Assist in implementing and managing new and existing grant programs to ensure PUC budgets are met, including assessment of performance and providing recommendations for modifications.
Design, implement, and spearhead Universal Service outreach campaigns, and harness data to evaluate the overall effectiveness of efforts.
Participate as a universal service policy analyst in Universal Service and rate case proceedings, including serving as a witness.
Prepare, review, analyze, and maintain records, metrics, reports, and directives related to Customer Affairs’ programs.
Perform financial analysis, including projections and model creation.
Provide timely and accurate reports on grants such as LIHEAP, CRISIS and Hardship Funds.
Investigate and perform root cause analysis of complex nature.
Lead comprehensive research and analysis projects searching for meaning in the data and information that drives the decision-making process, construct appropriate financial models to help predict/forecast future events that impact the enterprise.
Lead cross-functional projects using advanced data modeling and analysis techniques to discover insights that will guide strategic decisions and uncover optimization opportunities.
Create reports and data driven presentations with impact - identify trends and occurrences in data and translate findings into various mediums including text, charts, graphs, displays and tables.
Serve as policy contact at the Commonwealth level on low-income utility programs.
Partner with business units within Customer Affairs to bridge the gap between data analysis and business strategy, translating business needs into actionable data driven analyses.
Utilize company and publicly available data to identify trends, patterns, and opportunities for improvement, and communicate these findings to stakeholders.
Develop data-driven solutions, provide strategic recommendations, and support cross-functional business decisions to achieve financial savings in credit & collections, rates, and other areas.
Create dashboards, reports, and analytical models to assess performance of initiatives within Customer Affairs and achieve measurable cost savings.
Coordinate analytics across PGW business units to share strategies, data results, and other data insights in order to collaborate across silos.
Organize and lead executive presentations with relevant information and actionable recommendations.
Lead analyses targeted end-to-end business processes to improve efficiency and cost savings.
Supervise and coordinate subordinate work activities by defining tasks, developing timelines, defining milestones, analyzing business processes and financial impacts, prioritizing activities, assigning work, monitoring progress, and providing direction and assistance as needed.
Assess employees’ needs, ensuring subordinates are properly trained and adhere to company policies, practices and procedures including collective bargaining agreement when applicable.
Evaluate and meet with subordinates to discuss work performance providing appropriate commendations and disciplinary actions to ensure employees are well equipped to meet and/or exceed job expectations.
Prepare and track regular reports on team performance, project status, and key metrics for senior leadership.
May manage temporary and/or contracted staff in support of department projects.
Keep abreast of current trends data and economic analysis, as it relates to the utility industry.
Perform other special projects and assignments as directed.