Transportation Data Analyst

SALARY RANGE: $55,000-$58,000 (position level & salary commensurate with education & experience)

LOCATION: Office of Travel Monitoring

CLOSING DATE: When position is filled

AREAS OF CONSIDERATION: All sources

The Delaware Valley Regional Planning Commission (DVRPC) is the Philadelphia region’s Metropolitan Planning Organization (MPO). We believe DVRPC provides a stimulating environment that values diversity, innovation, and collaboration, where conscientious professionals can contribute to the betterment of society. If your background and experience overlap the needs of the following vacancy, we would like to hear from you. 

DVRPC seeks a skilled and organized data analyst to join our industry-leading travel monitoring team. This candidate will support traffic, bicycle, pedestrian, and transit data collection and data management for projects and initiatives across two states, nine counties, and on behalf of a wide range of partners. For examples of the types of travel monitoring data collected by DVRPC, see https://www.dvrpc.org/traffic/. 

This job involves a number of activities ranging from assisting in the collection and processing of data, preparation of reports, and supervision of data processing and data entry. It requires demonstrated skill in using, developing, and maintaining a large database. Must be able to pull and aggregate necessary data and file types to report completed work to agency partners, outside stakeholders and internal project managers. Work is performed in accordance with professional standards and is carried out under the supervision of the unit manager. 

Responsibilities 

• Maintain various traffic count data files, including records of counts taken and processed. 
• Use and maintain the Traffic Count database, ensuring data integrity and accuracy. 
• Assist in preparing and maintaining metadata for traffic count data. 
• Review existing or incoming data for currency, accuracy, quality, or completeness including documentation and metadata.
• Pull and manipulate large data files, generating reports from the traffic count database in response to data requests. 
• Conduct data quality control checks to ensure the accuracy and reliability of data. 
• Assist in developing and implementing extract, transform, load ETL processes for data integration and reporting. 
• Provide support to staff in the travel monitoring office, and across the organization to advance agency projects and goals. 
• Communicate and coordinate work requests and inquiries about traffic-related information from public and private agencies.
• Prepare and transmit traffic data to member agencies and governments. 

Qualifications 

• Experience/Training in using databases; knowledge and proficiency in SQL and Python. Experience using Oracle a plus.
• Knowledge of the principles and practices of database development and maintenance. 
• Experience with Microsoft Office suite (or similar productivity tools). 
• Familiarity with geographic information systems (GIS) and their application to transportation planning. 
• Strong organizational, analytical, quantitative, and problem-solving skills. 
• Ability to learn the basic concepts of transportation planning and traffic count/volume data. 
• Ability to communicate in a clear and concise oral, written, and graphic form. 
• Ability to work independently as well as in a team. 

Experience & Training 

To classify as a Level TS I, a minimum of ONE YEAR experience in specified field and/or research and analysis work; graduation from a four-year college/university, with major course work in a related discipline; or an equivalent combination of experience and training. A Master’s degree can be substituted for one year of experience.

DVRPC IS AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER. FULL CONSIDERATION WILL BE GIVEN TO ALL ELIGIBLE, QUALIFIED APPLICANTS WITHOUT REGARD TO AGE, ANCESTRY, COLOR, DISABILITY, DOMESTIC OR SEXUAL VIOLENCE VICTIM STATUS, ETHNICITY, FAMILIAL STATUS, GENDER IDENTITY OR EXPRESSION, GENETIC INFORMATION, MARITAL STATUS, MEDICAL CONDITION (INCLUDING PREGNANCY), NATIONAL ORIGIN, RACE, RELIGION, SEX, OR SEXUAL ORIENTATION, MINORITY, DISABLED, & VETERANS CANDIDATES ARE ENCOURAGED TO APPLY. NOTE: YOU MUST BE LEGALLY ELIGIBLE TO WORK IN THE US.