CAPS Data Scientist — Coordinated Entry Analytics

NYC Department of Social Services; New York (NY); On-site; USD 90,000 - 120,000; Full time

Job summary

NYC Department of Social Services seeks a City Research Scientist II to support the Coordinated Entry system by providing research, data analysis and evaluation for CAPS. You will work with leadership to develop performance measures and respond to cross‑agency data requests.

The role requires strong SQL and statistical software skills, experience with CAPS/CARES data, and clear written communication. NYC residency is expected; one-year probation applies.

Qualifications

• Master's degree required for Assignment Level I in physical, biological, environmental sciences or public health.
• For Assignment Level II and above, doctorate with 1 year supervisory/research experience; or Master's with 3 years' research experience; or equivalent.
• Two years as City Research Scientist Level I can substitute for experience in 1 and 2 above.

Responsibilities

• Perform evaluation and research using CAPS data to identify operational efficiencies and inform performance measures.
• Design and analyze analyses of CAPS data; create non-automated SQL code for extraction and analysis of complex data sets; present findings.
• Monitor CAPS data for survey, application, determination, rapid-housing and vacancy control modules; develop new recording and visualization methods.
• Prepare responses to legal and media requests by extracting CAPS data with SQL.
• Support HUD reporting, validate and upload file sets from CAPS into HMIS data warehouse; collaborate to refine file generation logic.
• Conduct data sharing for intra- and interagency research and evaluation.
• Review literature and data to inform research questions and methodologies.
• Perform other related duties as directed.

Skills

SQL programming

SPSS

STATA

SAS

Tableau

MS Excel

Word

PowerPoint

CAPS data systems

CARES data systems

Local Law 3 of 2022

Local Law 135 of 2025

Strong writing

Communication skills

Education

Master's degree in physical, biological, environmental or social science or public health

Doctorate degree in physical, biological, environmental or social science and 1 year supervisory/research experience

Master's degree plus 3 years of full-time research experience

Tools

Non-automated SQL

Job description

NYC Department of Social Services seeks a City Research Scientist II to support the Coordinated Entry system by providing research, data analysis and evaluation for CAPS. You will work with leadership to develop performance measures and respond to cross‑agency data requests.

The role requires strong SQL and statistical software skills, experience with CAPS/CARES data, and clear written communication. NYC residency is expected; one-year probation applies.