College Aide
About The Position
The College Aide will work with NYC DOT’s Data Systems & Counts Management team to develop data quality control, standardization, and visualization tools that support the agency’s data-driven analysis of citywide mobility. The role involves creating and modifying workflows for ingesting, cleaning, and validating multimodal traffic counts and third-party location-based mobility data. Where the data permits, the project will identify spatial errors, automate repetitive data-cleaning processes, and map anomalies across citywide networks. The work will inform how NYC DOT validates major data streams, monitors program performance, and supports regional planning models. The student will gain hands-on experience in public-sector data science and transportation planning under the mentorship of data professionals. The role provides experience with Python, SQL, GIS, large-scale mobility datasets, and metropolitan planning data infrastructure, while offering the opportunity to develop a portfolio piece connecting data engineering with urban policy.
Requirements
- For Assignment Level I: Matriculation at an accredited college or graduate school; continued student status is required during employment.
- For Assignment Level II (Information Technology): Matriculation at an accredited college or graduate school with a 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; continued student status is required during employment.
- For Assignment Level III (Information Technology Fellow): Matriculation at an accredited college or graduate school with a course of study in information technology, computer science, management information systems, data processing, or another area relevant to the assigned IT projects, including or supplemented by 9 semester credits in an acceptable course of study; continued student status is required during employment. Appointments at this level are made by the Technology Steering Committee through the Department of Information Technology and Telecommunications.
- Maximum tenure in the College Aide title is 6 years.
- Students may not be employed more than half-time in any week when their enrolled classes are in session; they may be employed full-time during vacation periods.
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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Intern
Education Level
No Education Listed
