Overview

Philadelphia Gas Works

Looking for a challenge and ready to light up your career?

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 - Hybrid Work Environment

PGW does not provide sponsorship. OPT candidates are not eligible for full time employment.

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. 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 dedicated to becoming the Greenest Natural Gas Delivery Company in the region.

Make a difference in your future – Become part of the PGW Team!

We offer a strong benefit package that includes free basic health and dental insurance. 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

The job is on site. Compressed work week may be available after six months.

Business Intelligence Developer

Responsibilities

Business Intelligence Developer I (BID-I) is a member of a team responsible for the technical functions associated with creating and maintaining data visualizations. The incumbent will build charts, create custom calculations, requirement gathering and providing data insights. The incumbent performs data loading, connects to multiple data sources, must be knowledgeable of SQL scripts, and follow defined best practices to produce data visualization and provide valuable insights.

Key responsibilities include:

Using the company's Bl platform and other reporting tools to assist with operational and analytical reporting solutions consistent with the vision and direction of the Director, Analytics Development and the VP, Data Analytics.

Collaborating with end users, Bl developers, data analysts, and business analysts in business units as well as both local and enterprise technology units to meet reporting needs of stakeholders and grow Bl capabilities.

Assist customers with submission requests, server navigation and understanding the framework and concepts of Tableau Server.

Escalate verified issues and failures to the Tableau team.

Assisting in data analysis for data quality issues by identifying data integration errors and working with data integration teams to provide solutions and improve data quality.

Supporting holistic business analysis and reporting of vital KPls.

Assisting in identifying business rules and requirements for data integration processes, providing guidance and support to data integration developers by documenting rules and procedures required to transform, process and load data into reporting solutions.

Using and maintaining the business glossary, data dictionary, and source-to-target data mapping documentation as necessary.

Identify business opportunities or expand ideas obtained from management to conceptualize and define and model operational problems to assess feasibility and impact.

Identify performance improvement opportunities via data analysis and develop decision support tools to ensure the most cost conscience, efficient use of company resources that supports service objectives.

Develop concepts into business plans utilizing appropriate research techniques, methodologies, and experience and present them to the department with recommendations for implementation.

Perform extensive analysis of the problem, model, and resources available and alternative solutions.

Identify, analyze, interpret, and visualize trends or patterns in complex data sets.

Build dashboards, based on identified metrics, to support business decisions for both strategic and operational needs.

Perform other special projects and assignments as directed.

Qualifications

BS/BA degree in Computer Science, Information Technology, or other relevant field of study. Coursework in Data Analysis, Information Management or Information Technology preferred.

3 - 5 years of experience working in Business Intelligence and reporting solutions (preferably Tableau), demonstrate capabilities with database management software such as Oracle and SQL Server.

The ability to design visualizations using Tableau Desktop.