Models and Data Analysis Intern

Job Summary: 

Regional Planning Intern – Models & Data Analysis

The Southwestern Pennsylvania Commission is the official Metropolitan Planning Organization (MPO) for the ten-county region including the City of Pittsburgh and the counties of Allegheny, Armstrong, Beaver, Butler, Fayette, Greene, Indiana, Lawrence, Washington, and Westmoreland.

SPC is seeking an intern for its Models & Data Analysis Unit to assist with various ongoing projects in need of transport modeling, data collection, data management, database development, data analysis, and related activities.

Key Responsibilities:

• Assist in coding of scripts (R, Python, etc.) to automate current manual processes.
• Help develop and review content for SPC’s Regional Data Center webpage.
• Database management to integrate data from new sources into existing libraries.
• Data analysis including preparation of charts, maps, tables, and infographics in support of other SPC Departments and projects.
• Data entry and analysis to develop and update GIS layers to visualize characteristics of the region’s transportation network including roads, bridges, and freight facilities; public transportation routes and service levels; and bike and pedestrian infrastructure.
• Assist with analysis of data from the US Census Bureau and other public data providers.

Qualifications:

• Preferred candidates would be enrolled in an undergraduate or graduate program in Regional/Urban Planning, Geography, Civil Engineering, Information Science, Data Analytics, or related field with interests in Programming, Transportation Planning, Geographic Information Systems, and Transport Modeling. 
• Working knowledge and application of programming languages (such as R, Python, or similar) as well as completion of a college-level GIS course is strongly preferred.
• Excellent written/oral communication and computer skills are also preferred.

Learning Objectives:

• At the end of the internship, the intern will have a strong foundation in Models & Data Analysis.
• Gain hands-on experience in a real business setting and learn key tasks.
• Understand and contribute to team goals.

Physical Requirements:

75% Sitting, 10% Walking, 15% Standing, 80% Use of hands, 5% Reaching 90% Talking / Hearing; Lifting < 10 lbs.; Near vision, Color vision

Work Environment:

Works in an environmentally controlled clean office. Working outdoors in inclement weather and a variety of environments may be required.

SPC is proud to be an Equal Opportunity employer. We value diversity among our applicants, staff, and commission, and invite applications from all qualified individuals regardless of race, ethnicity, color, religion, gender identity, sexual orientation, age, nationality, genetics, disability, or Veteran status. 

SPC is committed to providing reasonable accommodation when necessary throughout our interview process. Please address these accommodations to our HR Director.  

Creating an inclusive, engaged, and dynamic atmosphere is core to SPC’s mission. Service, Resiliency, Innovation, and Accountability are the core values that unite the SPC team, inspiring one another to work and support others as they seek to reach new levels of excellence.