Philadelphia Gas Works Data Analytics Specialist in Philadelphia, Pennsylvania
Philadelphia Gas Works
Looking for a challenge and ready to energize up your career?
The Philadelphia Gas Works (PGW) is the largest municipally-owned gas utility in the nation, supplying gas service in the City of Philadelphia to over 500,000 customers. We manage and maintain a system of over 6,000 miles of gas mains and service pipes that deliver an annual 78 billion cubic feet of safe, reliable natural gas. From its humble beginnings in 1836, PGW has grown into the large, modern facility that exists today. As one of the nation's leading natural gas providers, PGW prides itself on stability and continual growth. PGW is the Greenest Natural Gas Delivery Company in the region. Make a difference in your future – Become part of the PGW Team!
Free Health Insurance Options– Free Dental Insurance – Flex Spending - Commuter Benefits - Pension Plan – Free Parking – Wellness Programs – Onsite Gyms – Tuition Assistance- PSLF Eligible Employer- Parental Leave
Make a difference in your future – Become part of the PGW Team!
Senior Data Analytics Specialist
The Senior Data Analytics Specialist is responsible for collecting, analyzing, and reporting data related to programs under PGW’s Customer Affairs departments. This position will manage all of the department’s data, including, but not limited to: designing reports, building databases, analyzing outcomes, and developing/maintaining standardized reporting tools (scorecard, metrics, dashboard, etc.). The incumbent will also handle highly confidential assignments and information, and will conduct qualitative and quantitative data analysis pertaining to various PGW’s programs and will be looked upon to provide recommendations as a result of analysis of available data.
Provides data analytics including segmentation and statistical models.
Applies analytics and research skills to proactively identify patterns and opportunities.
Analyze specific customer information system issues, identified by the business, in order to determine the business impacts (cost & volume), the complexity, the priority, and the root cause of the issues.
Prepares reports of findings, illustrating data graphically and translating complex findings into written text.
Designs, implements and spearheads outreach campaigns, and harness data to evaluate the overall effectiveness of efforts.
Prepares, reviews, analyzes, and maintains records, metrics, reports and directives related to Customer Affairs’ programs.
Performs financial analysis, including projections and model creation.
Provides timely and accurate reports on grants such as LIHEAP, CRISIS and UESF.
Investigates and performs root cause analysis of complex nature.
Oversees and provides direction to a team of analysts on various projects and assignments.
Leads comprehensive research and analysis projects searching for meaning in the data and information that drives the decision making process, constructs appropriate financial models to help predict/forecast future events that impact the enterprise.
Leads cross-functional projects using advanced data modeling and analysis techniques to discover insights that will guide strategic decisions and uncover optimization opportunities.
Creates reports and data driven presentations with impact - identifies trends and occurrences in data and translate findings into various mediums including text, charts, graphs, displays and tables.
May oversee temporary and/or contracted staff in support of department projects. Performs other special projects and assignments as directed
Bachelor’s Degree in Business, Business Intelligence, Finance, Economics, Statistics or other quantitative analytical field of study. Advanced degree preferred
5 - 7 years’ experience in data analysis or other related field.
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 ability to utilize abstract reasoning techniques in order 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 extract useful information.
Must have proven ability in translating and integrating data/research from different data sources to provide clarity and direction, as well as develop reports.
Must have the ability to work independently and effectively without a great deal of direction.
Must have the ability to present ideas in a well-organized and logical manner.
Must be a results oriented individual.
COVID-19 Vaccination: Effective November 8, 2021,PGW requires all new employees to be fully vaccinated against COVID-19 as a condition of employment, subject to reasonable accommodations.
PGW is proud to be an Equal Opportunity and Affirmative Action Employer, M/F/D/VAAP/EEO.
Location: 800 W Montgomery Ave, Philadelphia, PA 19122
While we appreciate all responses, only those who are uniquely qualified will be contacted.
Department for Portal Display: VP, Reg Compliance & Cust Prog
External Company URL: www.pgworks.com
ADP Department #: VP, Reg Compliance & Cust Prog 
Street: 800 West Montgomery Avenue