Program Analytics & Reporting Lead, Bureau of Mental Health

City of New York • Long Island City, NY

5d

About The Position

The Bureau of Mental Health (BMH) works to improve mental health and wellness for New Yorkers and address racial and other long-standing societal disparities through services and resources grounded in accurate, data-driven information and community participation. BMH contracts for supportive housing, crisis intervention, mental health treatment, care coordination, and psychiatric rehabilitation. 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 leads programmatic data activities, including data collection systems, dashboards, reporting, analysis, and written reports. The role partners with program staff and leadership to define data requirements and performance measures, manage and improve data in the Mental Health Maven Data System, and use data analysis to support program oversight and operations. The lead communicates findings to technical and non-technical audiences, responds to stakeholder requests, incorporates an equity lens, supervises and mentors junior staff, and manages multiple projects with interdisciplinary teams.

Requirements

• For appointment to Assignment Level II and above, a master's degree in an appropriate field and at least two years of qualifying research experience are required, subject to the stated education and experience substitution provisions.
• The listed City Research Scientist qualifications also allow a doctorate in an appropriate field plus one year of responsible supervisory, administrative, or research experience; or a master's degree in an appropriate field plus three years of responsible full-time research experience; or equivalent education and experience, with the stated minimum master's degree and experience requirements.
• At least 3 years of full-time experience processing, cleaning, manipulating, and analyzing large program or administrative datasets using statistical software such as SAS, SQL, or R is identified as preferred.
• Excellent written and oral communication skills and experience with scientific writing.
• Competency in Microsoft Word, Excel, and PowerPoint.
• Ability to manage multiple priorities and diverse assignments, work independently and collaboratively, and adapt to multiple programmatic or functional areas.

Nice To Haves

• Experience supervising a team of data analysts.
• Experience working with relational databases.
• Experience with Power BI or similar data visualization tools.
• Project management skills and adaptability across multiple programmatic or functional areas.
• 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.
• Superior writing skills and ability to manage a wide range of projects in a fast-paced environment.

Responsibilities

• Lead programmatic 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 data management in the Mental Health Maven Data System; monitor data quality, initiate quality improvement projects, and develop reports and workflows.
• Lead 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 performance and informing program operations; recommend data-driven tracking and refinement of metrics.
• Lead the design and execution of data analysis projects using SQL, SAS, or R to clean and analyze program data from multiple sources and generate tables, figures, and reports.
• Prepare reports and presentations of program performance data and communicate analytical results clearly to program staff, leadership, and non-technical audiences.
• Respond quickly and accurately to ad hoc data requests from internal and external stakeholders.
• Incorporate an equity lens in all aspects of work.
• Supervise and mentor junior staff.
• Manage multiple projects and collaborate with interdisciplinary teams.

Benefits

• Potential eligibility for federal or state loan forgiveness and repayment assistance programs.
• Premium-free health insurance plan.
• 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: Mid Level