Data Analyst, NYC Mental Health Insights

City of New York; New York (NY); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Loan forgiveness

Health benefits

Public sector pension

Tax-deferred savings

Wellness program

Job summary

The Bureau of Mental Health (BMH) in City of New York seeks a data analyst to advance data collection, quality, and reporting. You will collaborate with program staff and IT to refine instruments and dashboards used for performance tracking.

Responsibilities include building metrics, using SAS/SQL/R for data preparation, and communicating results to non-technical audiences. You will support ad hoc requests and training, with a strong equity focus across initiatives.

Qualifications

• Experience processing, cleaning, manipulating, and analyzing large program or administrative datasets using SAS, SQL, and/or R is required.
• Ability to work independently and problem solve.
• Experience in querying, cleaning, and maintaining large relational databases.
• Willingness to be flexible and work as part of a team.
• Experience working with an electronic health, social service, or case management record system such as Maven.
• Experience with data visualization tools such as Power BI, and /or Tableau.
• Excellent written and oral communication skills.
• Experience in quantitative analytical methods.
• Experience with public mental health systems and recovery-oriented practices
• Strong organizational skills.

Responsibilities

• Collaborate with program staff and IT to develop and refine data collection instruments and improve data systems and processes.
• Work with program stakeholders to develop specific and measurable program metrics for operational and performance management.
• Using SQL, SAS, or R to process, clean, and prepare data for analysis and reporting; data check; document data management procedures (e.g., data dictionaries, business rules); monitor data quality, identify issues, and work with program staff to resolve.
• Prepare routine reports and presentations of program performance with data graphs/service trends; Clearly communicate (oral and written) results of analyses to program staff/leadership and other non-technical audiences.
• Maintain and update existing dashboards as needed using software such as Power BI; assist in developing new dashboards as needed.
• Respond quickly and accurately to ad hoc data requests for internal (e.g., Directors, Assistant Commissioners) and external audiences (e.g., public hearings, City Hall).
• Work with leadership and program stakeholders on interpretation and limitations of data analysis results and provide actionable recommendations.
• Develop training materials and conduct trainings on updates to the data collection system as needed. Create guidance documents for internal staff and external users detailing updates to the system.
• Manage multiple projects and collaborate with other research and program staff.
• Incorporate an equity lens in all aspects of work.
• Conduct special projects and perform other duties as assigned.

Skills

SAS

SQL

R

Power BI

Tableau

Data cleaning

Data visualization

Communication

Equity

Teamwork

Tools

Maven

Job description

The Bureau of Mental Health (BMH) in City of New York seeks a data analyst to advance data collection, quality, and reporting. You will collaborate with program staff and IT to refine instruments and dashboards used for performance tracking.

Responsibilities include building metrics, using SAS/SQL/R for data preparation, and communicating results to non-technical audiences. You will support ad hoc requests and training, with a strong equity focus across initiatives.