Data and Analytics Intern

Philadelphia Gas Works; Pennsylvania; On-site; USD 25,000 - 39,000; Full time

Job summary

Philadelphia Gas Works in Philadelphia is offering a Data & Analytics Internship designed for full-time students in advanced programs. You will develop dashboards, clean and integrate data, and improve reporting usability to support business decisions.

Ideal candidates are graduate students in MBA or related fields with SQL, Tableau/Power BI, Excel, Python or R; strong communication; 1+ year experience preferred.

Qualifications

• Enrolled in a graduate program (MBA/MS in a quantitative discipline)
• Strong foundation in data analytics, finance, or operations
• Experience with data collection, cleaning, validation, and integration
• Proficient in SQL queries and relational databases
• Familiarity with data visualization tools (Tableau, Power BI)
• Proficiency in MS Excel and PowerPoint; strong written communication

Responsibilities

• Develop, maintain, and enhance dashboards and reports
• Assist with data collection, cleaning, validation, and integration
• Improve accessibility, consistency, and usability of reporting
• Evaluate data quality and identify improvement opportunities
• Document data processes and reporting requirements
• Automate recurring reports and streamline analytics workflows
• Support business decision-making with data insights

Skills

SQL

Tableau

Power BI

Excel

PowerPoint

Python

R

Communication

Education

Graduate program enrollment

Tools

SQL

Tableau

Power BI

Excel

PowerPoint

Python

R

Job description

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.

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.

• 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.
• 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.