College Aide

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.

To Apply

Please go to www.nyc.gov/jobs, or www.nyc.gov/ess for current NYC employees, and search for Job ID # 797777. No phone calls, faxes or personal inquiries permitted. Only those candidates under consideration will be contacted.

To Apply

Please go to www.nyc.gov/jobs, or www.nyc.gov/ess for current NYC employees, and search for Job ID # 797777. No phone calls, faxes or personal inquiries permitted. Only those candidates under consideration will be contacted.

COLLEGE AIDE (ALL CITY DEPTS) - 10209

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.

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.