Pittsburgh Regional Transit is seeking a Transit Data Intern to, during the academic year, conduct data analysis projects assisting Port Authority of Allegheny County d/b/a Pittsburgh Regional Transit (PRT) in determining how to best deploy transit resources across the system.

Essential Functions

• Assist the Transit Analysis team through applying data manipulation, analysis and visualization in one or more of the following projects: • Analyze ridership patterns to inform service decisions. • Assess effectiveness of service changes, including monitoring ridership per trip, on time performance, and ridership by geographic area. • Develop interactive maps and dashboards that allow end users to explore transit data and discover insights. • Assist with internal and external reporting and data requests as needed. • Institute back-end data management processes such as automated Extract-Transform-Load operations and developing functions for commonly used data preparation techniques.

Job Requirements

• At minimum, candidates must be in their Junior or Senior year of study in a public policy, data analysis, computer science or related degree program. Recent graduates of same programs will also be considered. • Data manipulation skills, including ability to retrieve data, clean it, join to other datasets, and export in a clean format. • Strong data visualization skills that communicate a clear message to the end user. • Intellectual curiosity and the ability to identify and solve problems independently. • Interest and familiarity with public transit (even just as a rider) and the desire to make public services better for everyone. • Ability to work independently. • Excellent communications skills. • Planning and organization.

Preferred Attributes

• Candidate enrolled in or recently graduated from a master’s degree program in public policy, data analysis, computer science or related field. • Knowledge of a coding language such as R or Python. • Knowledge of a dashboarding tool such as Tableau or PowerBI. • Knowledge of a spatial analysis tool such as ArcGIS. • Ability to write basic SQL queries.

Salary

0-0/Year    

Apply   Back