College Aide

City of New York • New York City, NY

3d • Onsite

About The Position

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.

Requirements

• Matriculation at an accredited college or graduate school.
• Employment is conditioned upon continuance as a student in a college or graduate school.
• Matriculation at an accredited 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.
• Matriculation at an accredited 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.

Nice To Haves

• Strong understanding of using Pivot Tables and Xlookups.

Responsibilities

• Gathering data from various sources (primary and secondary) and cleaning it to ensure accuracy, consistency and overall usability.
• Utilizing SQL, Python, or R to query databases and perform gap analysis, and diagnostic and descriptive analysis to find trends.
• Creating dashboards, graphs, and charts using tools like Excel or Power BI to present findings to stakeholders.
• Supporting senior analysts and departments by providing data-driven insights for business improvements.
• 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.

What This Job Offers

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