Data and Analytics Intern

Philadelphia Gas Works; Philadelphia (Philadelphia County); On-site; USD 28,000 - 34,000; Full time

Job summary

Philadelphia Gas Works (PGW) invites ambitious graduate students to join its Data & Analytics Internship. You'll work on dashboards, data integration, and analytics projects to support business decisions.

You'll develop reporting, ensure data quality, document processes, and potentially automate recurring reports using Power BI, SQL, and Python. This internship offers hands-on experience in a major municipal utility in Philadelphia.

Qualifications

• Currently enrolled in a graduate program (MBA, MS in Business Analytics, Data Science, Statistics, CS, Finance, or related quantitative field).
• Ideally 1+ year of professional work experience following undergraduate graduation.
• Prior experience or school study in analytics, finance, operations, technology, or other analytical/business areas.
• Effective communication and writing skills are required.

Responsibilities

• Develop, maintain, and enhance dashboards, reports, and performance metrics.
• Assist with data collection, cleaning, validation, and integration from multiple sources.
• Improve accessibility, consistency, and usability of business reporting.
• Evaluate data quality and identify opportunities to improve accuracy and consistency.
• Document data and analytics processes, methodologies, and reporting requirements.
• Help automate recurring reports and streamline data and analytics workflows.

Skills

Analytical mindset

Effective communication

Written communication

Education

MBA or MS in Business Analytics / Data Science

Tools

SQL

Tableau

Power BI

Excel

PowerPoint

Python

R

Job description

Overview

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.

The PGW Internship Program is designed for students currently enrolled FULL-TIME at an accredited college or university with a sophomore classification or above ONLY. If you are not a full-time student, please refer to our other current employment opportunities.

The Role

We are seeking a highly motivated, analytically minded Data & Analytics Intern to help work on data and analytics requests and projects as well as perform other duties as required. This is a great opportunity for student to gain work experience and business knowledge, learn and apply data and analytics tools and techniques to support business decision-making, and contribute to the success of the team.

Responsibilities

• Develop, maintain, and enhance dashboards, reports, and performance metrics.
• Assist with data collection, cleaning, validation, and integration from multiple sources.
• Improve the accessibility, consistency, and usability of business reporting.
• Evaluate data quality and identify opportunities to improve accuracy and consistency.
• Document data and analytics processes, methodologies, and reporting requirements.
• Help automate recurring reports and streamline data and analytics workflows.

Qualifications

• Currently enrolled in a graduate program, preferably an MBA, MS in Business Analytics, Data Science, Statistics, Computer Science, Finance, or a related quantitative discipline.
• Ideally 1+ years of professional work experience following undergraduate graduation.
• Prior experience or school study in analytics, finance, operations, technology, or other analytical or business areas.
• Effective communication and writing skills.
• Proficiency in Microsoft 365, especially Excel and PowerPoint.
• Knowledge or experience with SQL and querying relational databases.
• Knowledge or experience with data visualization tools such as Tableau, Power BI.
• Experience with Python, R, or other programming languages is a plus.