Apply on Employer Site

Philadelphia Gas Works · 18 hours ago

Sr. Data Analytics & Partnering Specialist

US-PA-Philadelphia

Full-time

Onsite

Senior Level

5+ years exp

Philadelphia Gas Works (PGW) is the largest municipally owned gas utility in the nation, supplying gas service to over 500,000 customers in the City of Philadelphia. The Senior Data Analytics & Partnering Specialist is responsible for collecting, analyzing, and reporting data related to customer programs, providing policy recommendations, and managing data for the Customer Affairs department.

EnergyOil and Gas

Comp. & Benefits

Responsibilities

Collecting, analyzing, and reporting data related to programs under PGW’s Customer Affairs departments, and providing policy recommendations

Managing all the department’s data, including designing reports, building databases, analyzing outcomes, and developing/maintaining standardized reporting tools (scorecard, metrics, dashboard, etc.)

Handling highly confidential assignments and information and conducting qualitative and quantitative data analysis pertaining to various PGW’s programs

Providing data analytics including segmentation and statistical models

Applying analytics and research skills to proactively identify customer programs and regulatory patterns and opportunities

Analyzing specific customer information system issues, identified by the business, to determine the business impacts (cost & volume), the complexity, the priority, and the root cause of the issues

Preparing reports of findings, illustrating data graphically and translating complex findings into written text

Managing annual LIHEAP/Crisis outreach and customer communications, including tracking of results of such outreach and recommendations regarding modifications to outreach and Commonwealth/federal policy recommendations

Assisting in implementing and managing new and existing grant programs to ensure PUC budgets are met, including assessment of performance of such programs and providing recommendations for modifications

Designing, implementing and spearheading Universal Service outreach campaigns, and harnessing data to evaluate the overall effectiveness of efforts

Participating as universal service policy analyst in Universal Service and rate case proceedings, including serving as a witness in proceedings

Preparing, reviewing, analyzing, and maintaining records, metrics, reports, and directives related to Customer Affairs’ programs

Performing financial analysis, including projections and model creation

Providing timely and accurate reports on grants such as LIHEAP, CRISIS and Hardship Funds

Investigating and performing root cause analysis of complex nature

Leading comprehensive research and analysis projects searching for meaning in the data and information that drives the decision-making process, constructing appropriate financial models to help predict/forecast future events that impact the enterprise

Leading cross-functional projects using advanced data modeling and analysis techniques to discover insights that will guide strategic decisions and uncover optimization opportunities

Creating reports and data driven presentations with impact - identifying trends and occurrences in data and translating findings into various mediums including text, charts, graphs, displays and tables

Serving as policy contact at the Commonwealth level on low-income utility programs

Performing other special projects and assignments as directed

Partnering with business units within Customer Affairs to bridge the gap between data analysis and business strategy, translating business needs into actionable data driven analyses

Utilizing company and publicly available data to identify trends, patterns, and opportunities for improvement, and communicating these findings to stakeholders

Developing data-driven solutions, providing strategic recommendations, and supporting cross-functional business decisions to achieve financial savings in credit & collections, rates, and other areas

Creating dashboards, reports, and analytical models to assess performance of initiatives within Customer Affairs and achieve measurable cost savings

Coordinating analytics across PGW business units to share strategies, data results, and other data insights in order to collaborate across silos

Organizing and leading executive presentations with relevant information and actionable recommendations

Leading analyses targeted end-to-end business processes to improve efficiency and cost savings

Managing and providing directions to a team of analysts on various projects and assignments

Supervising and coordinating 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

Assessing employees’ needs, ensuring subordinates are properly trained and adhere to company policies, practices and procedures including collective bargaining agreement when applicable

Evaluating and meeting 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

Preparing and tracking 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

Keeping abreast of current trends data and economic analysis, as it relates to the utility industry

Performing other special projects and assignments as directed

Qualification

Data analysisMS ExcelData visualizationFinancial analysisData-driven solutionsAbstract reasoningRegulationsAssistance programsGenerative AI softwareVerbal communicationWritten communicationPresentation skillsTime managementTeam managementAttention to detailCollaboration

Required

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

Must have a high degree of accuracy and attention to detail

Must have a 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

Must have experience with interactive data visualization software such as Tableau

Must have ability to utilize abstract reasoning techniques to build reporting logic and establish creative solutions

Must possess excellent verbal, written and presentation skills

Must have time management skills with the ability to handle multiple projects simultaneously

Must have 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

Must have prior experience partnering across multiple business units

Must have prior experience developing data-driven solutions to end-of-the-end business processes