Data Analytics Support Associate

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

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.