Program Analytics & Reporting Lead, Bureau of Mental Health

City of New York • New York, NY

3h • $98,159 - $112,883

About The Position

The Bureau of Mental Health (BMH) works to improve mental health and wellness for people in New York City and address racial and other long-standing societal disparities through services, resources, and opportunities grounded in accurate, data-driven information and community participation. BMH contracts for supportive housing, crisis intervention, mental health treatment, care coordination, and psychiatric rehabilitation services. It also directly operates the City’s Assisted Outpatient Treatment program, Single Point of Access to mobile treatment and care coordination, and NYCSTART for young adults experiencing a first episode of psychosis. The bureau evaluates mental health services and conducts population-level surveys and behavioral health care system surveillance to identify gaps and inform decision-making, advocacy, and policy.

The Office of Research and Evaluation supports bureau leadership and offices through surveillance, needs-assessment research, program evaluation, data-system development and maintenance, and program data reporting. It also informs the public through publications and presentations. The Program Analytics & Reporting Lead guides program data activities, including data-system development, data quality, analysis, reporting, and performance measurement. The role collaborates with program staff and leadership, communicates findings to technical and non-technical audiences, responds to stakeholder requests, supervises and mentors junior staff, and manages multiple projects with interdisciplinary teams. The position is with the NYC Department of Health and Mental Hygiene. The appointment is subject to a minimum one-year probationary period.

Requirements

• At least a master's degree in an appropriate field of specialization is required under the stated City Research Scientist qualifications.
• For Assignment Level II and above, qualify through one of the stated pathways: a doctorate in an appropriate field and one year of full-time responsible supervisory, administrative, or research experience; a master's in an appropriate field and three years of responsible full-time research experience; or equivalent education and experience. The equivalency pathway requires at least a master's degree and at least two years of the described experience. Two years as a City Research Scientist Level I may substitute for the experience specified in the first two pathways.
• The preferred skills section specifies 3+ years of full-time experience processing, cleaning, manipulating, and analyzing large program or administrative datasets using SAS, SQL, or R.
• Strong written and oral communication skills; the preferred skills section also calls for experience with scientific writing and superior writing skills.
• Competency with Microsoft Word, Excel, and PowerPoint.
• Ability to manage multiple priorities and diverse assignments, work independently and collaboratively, adapt to multiple programmatic or functional areas, and follow up effectively.
• The job description identifies project management skills and the ability to manage a wide range of projects in a fast-paced environment.
• Appointments are subject to a minimum probationary period of one year.

Nice To Haves

• Experience supervising a team of data analysts.
• Experience working with relational databases.
• Experience with Power BI or similar data visualization tools.
• Prior experience in mental health and substance use program analytics and evaluation.
• Experience managing competitive procurements for a government agency.
• Experience writing specifications or scopes of work for competitive procurements or contracts.
• Experience using the PASSPort system.

Responsibilities

• Lead program data activities, including development of data collection systems, dashboards, reporting, ad hoc analysis, and report writing.
• Work with program staff to identify business needs and translate them into quantifiable data requirements for data collection and management systems.
• Lead management of data in the Mental Health Maven Data System, monitor data quality, initiate quality-improvement projects, and develop Maven reports and workflows.
• Lead the processing, cleaning, and preparation of data for analysis.
• Maintain technical written documentation, including data reports, data dictionaries, data access rules, methods, and business rules.
• Work with program leadership and staff to develop process and outcome indicators for tracking program performance and informing operations; recommend data-driven tracking and refinement of metrics.
• Lead the design and execution of analyses for program oversight, using SQL, SAS, or R to clean and analyze data from multiple sources and generate tables, figures, and reports.
• Prepare reports and presentations of program performance data and clearly communicate analytical results orally and in writing to program staff, leadership, and non-technical audiences.
• Respond accurately and promptly to ad hoc data requests from internal and external stakeholders.
• Incorporate an equity lens into all aspects of the work.
• Supervise and mentor junior staff.
• Manage multiple projects and collaborate with interdisciplinary teams.

Benefits

• Potential eligibility for federal or state student loan forgiveness and repayment assistance programs.
• Premium-free health insurance plan, described as saving employees over $10,000 annually according to a 2024 assessment.
• Additional health, fitness, and financial benefits may be available depending on the position’s associated union or benefit fund.
• Public-sector defined-benefit pension plan.
• Tax-deferred savings program.
• Worksite Wellness Program.
• Depending on the position, the ability to work from home up to two days during the week.
• Job security compared with private-sector employment.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior