College Aide

City of New York; New York (NY); On-site; USD 70,000 - 95,000; Full time

Job summary

City of New York seeks a Data Team Support professional to help collect, clean, and analyze financial datasets for the OCP SPI unit. You will query databases using SQL, Python, or R, produce descriptive analyses and KPI insights, and support data-driven decisions across city agencies.

The role emphasizes collaboration with senior analysts, creating dashboards in Excel and Power BI, and providing clear documentation to stakeholders to improve procurement and reporting processes.

Qualifications

• Gather data from primary and secondary sources and clean it to ensure accuracy, consistency and usability.
• Use SQL, Python, or R to query databases and perform gap analysis, and descriptive analyses to find trends.
• Create dashboards and charts to present findings to stakeholders using Excel or Power BI.

Responsibilities

• Data Collection & Cleaning: Gathering data from various sources and cleaning it for accuracy and usability.
• Data Acquisition & Analysis: Query databases with SQL, Python, or R and perform diagnostic analyses.
• Data Visualization & Reporting: Build dashboards and charts in Excel or Power BI to convey findings.
• Collaboration: Support senior analysts and departments with data-driven insights for improvements.
• Documentation: Maintain clear documentation of data sources, methods and results.

Skills

SQL

Python

R

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