Data Analytics Aide - College Student (IT)

NYC Department of Citywide Administrative Services; New York (NY); On-site; USD 20,664,000 - 30,307,000; Full time

Job summary

NYC Department of Citywide Administrative Services is seeking a College Aide to support the OCP Data Team in collecting, cleaning, and analyzing large datasets. You will build dashboards and reports to inform procurement and operations across City agencies.

The role emphasizes data integrity, cross-team collaboration, and clear communication. Responsibilities include performing SQL/Python/R analyses, creating Power BI/Excel visuals, and documenting workflows while maintaining a professional work

Qualifications

• Matriculation at an accredited college or graduate school.
• Employment conditioned upon continuance as a student in college or graduate school.
• For IT-focused levels, study in information technology, CS, MIS, data processing, or related field, with 9 credits in related study.

Responsibilities

• Data collection & cleaning from multiple sources to ensure accuracy and usability.
• Data acquisition & analysis using SQL, Python, or R to identify gaps and trends.
• Data visualization & reporting using Excel, Power BI to present findings to stakeholders.
• Collaborate with senior analysts to provide data-driven insights for improvements.
• Maintain documentation of data workflows and report instructions.
• Extract data from PASSPort, WMS, and FMS.
• Process reports in Excel with Pivot Tables and XLOOKUPs.
• Demonstrate strong verbal and written communication and professional appearance.

Skills

SQL

Python

R

Excel

Power BI

Tableau

Data analysis

Pivot Tables

XLOOKUPS

Education

Enrollment in college or graduate school

Course in information technology or related field

Tools

Excel

Power BI

Job description

NYC Department of Citywide Administrative Services is seeking a College Aide to support the OCP Data Team in collecting, cleaning, and analyzing large datasets. You will build dashboards and reports to inform procurement and operations across City agencies.

The role emphasizes data integrity, cross-team collaboration, and clear communication. Responsibilities include performing SQL/Python/R analyses, creating Power BI/Excel visuals, and documenting workflows while maintaining a professional work