College Aide

City of New York • New York City, NY

7d

About The Position

The College Aide will support NYC DOT’s transition toward strategic, data-driven citywide mobility analysis by developing a data quality control, standardization, and visualization toolkit. Working with the Data Systems & Counts Management team, the aide will build and modify workflows for ingesting, cleaning, and validating multimodal traffic counts and third-party location-based mobility data. The work may include identifying spatial errors, automating data-cleaning pipelines, and mapping anomalies across citywide networks. Findings and pipelines will support validation of major data streams, tracking of program performance metrics, and regional planning models intended to promote equitable and efficient mobility.

The student will gain hands-on experience in public-sector data science and transportation planning under the direct mentorship of data professionals. They will develop technical skills in Python, SQL, and GIS while working with large-scale mobility datasets, and gain exposure to metropolitan planning data infrastructure. The experience may also support the development of a portfolio piece connecting data engineering with urban policy.

Requirements

• Remain matriculated at an accredited college or graduate school during employment.
• For Assignment Level II (Information Technology), pursue a specific course of study in information technology, computer science, management information systems, data processing, or a closely related field, including or supplemented by 9 semester credits in an acceptable course of study.
• For Assignment Level III (Information Technology Fellow), pursue a specific course of study in information technology, computer science, management information systems, data processing, or another area relevant to the assigned information technology project(s), including or supplemented by 9 semester credits in an acceptable course of study.
• Students may not be employed more than half-time during weeks when their classes are in session; they may be employed full-time during vacation periods.
• Maximum tenure in the College Aide title is 6 years.

Responsibilities

• Review existing Python-based data workflows and counts management platform metrics.
• Assist in drafting data documentation standards.
• Script automated data quality control checks using Python and SQL.
• Manipulate large spatial datasets and cross-reference field counts with third-party mobility matrices.
• Translate complex data errors into actionable insights.
• Compile findings into maps, dashboard components, and technical presentations for engineering and planning teams.

What This Job Offers

• Job Type: Part-time
• Career Level: Intern
• Education Level: No Education Listed