College Aide

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

Minimum Qualifications

For Assignment Level I:

DCAS's mission is to make city government work for all New Yorkers. From managing New York City’s most iconic courthouses and municipal buildings, to purchasing over $1 billion annually in goods and services for more than 80 City agencies what we do ensures that all agencies can deliver on their mission. Our reach touches every facet of city government and is instrumental to the successful day-to-day operations of the City of New York.

Our Commitment To Equity, Effectiveness, And Sustainability Guides Our Work Providing City Agencies With The Critical Resources And Support Needed To Succeed, Including:

• Recruiting, hiring, and training City employees.
• Managing 56 public buildings.
• Acquiring, selling, and leasing City property.
• Purchasing over $1 billion in goods and services for City agencies.
• Overseeing the greenest municipal vehicle fleet in the country.
• Leading the City's efforts to reduce carbon emissions from government operations.

When you work at DCAS, you're not just working for one agency, but in service of them all. It's an opportunity to provide impactful support, quality customer service, and help protect the future of New York City for generations to come.

Visit our website at nyc.gov/DCAS to learn more about the work we do.

The Office of Citywide Procurement (OCP) is the centralized procurement line of service with various external and internal functions, including ensuring that procurement processes comply with all applicable rules and mandates. In support of all City agencies, OCP is responsible for citywide contract management, quality assurance, and supply chain management. This work helps maintain the public trust and ensures that all products and services support the City’s overarching environmental and economic justice goals.

The OCP Data Team works collaboratively within the Strategic Performance and Innovation (SPI) unit to collect, clean, interpret and process extensive financial datasets for analysis and reporting to agency-wide and external stakeholders. This consists of the analysis and reporting of contract awards, spending, Key Performance Indicators (KPIs), budget tracking and modification, PASSPort catalog maintenance, Turnaround-Documents, and ad-hoc reporting to help OCP make data-driven decisions.

The Responsibilities For The Data Team Support Position Are:

• Data Collection & Cleaning: Gathering data from various sources (primary and secondary) and cleaning it to ensure accuracy, consistency and overall usability.
• Data Acquisition & Analysis: Utilizing SQL, Python, or R to query databases and perform gap analysis, and diagnostic and descriptive analysis to find trends.
• Data Visualization & Reporting: Creating dashboards, graphs, and charts using tools like Excel or Power BI to present findings to stakeholders.
• Collaboration: Supporting senior analysts and departments by providing data-driven insights for business improvements.
• Documentation: Maintaining documentation of data workflows and processes, as well as all report instructions.
• Extract data from various sources such as PASSPort, the Warehouse Management System (WMS) and Financial Management System (FMS).
• Process reports using Microsoft Excel with strong understanding of using Pivot Tables and Xlookups.
• Demonstrate excellent verbal and written communications.
• Maintain a professional appearance, exhibit regular punctuality and attention to detail.

COLLEGE AIDE (ALL CITY DEPTS) - 10209

Minimum Qualifications

For Assignment Level I:

Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school.

For Assignment Level II (Information Technology):

Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school with a specific course of study in information technology, computer science, management information systems, data processing, or closely related field, including or supplemented by 9 semester credits in an acceptable course of study.

For Assignment Level III (Information Technology Fellow):

Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school with a specific course of study in information technology, computer science, management information systems, data processing, or other area relevant to the information technology project(s) assigned, including or supplemented by 9 semester credits in an acceptable course of study. Appointments to this Assignment Level will be made by the Technology Steering Committee through the Department of Information Technology and Telecommunications.

SPECIAL NOTE

Maximum tenure for all Assignment Levels in the title of College Aide is 6 years. No student shall be employed more than half-time in any week in which classes in which the student is enrolled are in session. Students may be employed full-time during their vacation periods.

Preferred Skills

• Technical Skills: Proficiency in Microsoft Office Suite, especially Excel, required with strong understanding of using Pivot Tables and Xlookups. - Familiarity in Python, R, or data visualization tools (Tableau, Power BI) are a plus. - Analytical Ability: Strong analytical skills with the ability to collect, organize, and analyze significant amounts of information.

Public Service Loan Forgiveness

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.

Residency Requirement

New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview.

Additional Information

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.