Program Analytics & Reporting Lead, Bureau of Mental Health

Job Description The Bureau of Mental Health’s (BMH) mission is to improve mental health and wellness for people in New York City, and to eliminate racial and other long-standing societal disparities by providing services, resources, and opportunities to New Yorkers that are grounded in accurate, data-driven information that fosters community participation, thus reducing the stigma around mental health. To accomplish this mission, the Bureau of Mental Health contracts for supportive housing, crisis intervention, mental health treatment, care coordination and psychiatric rehabilitation services. The bureau directly operates the City’s court-mandated Assisted Outpatient Treatment (AOT) program, Single Point of Access (SPOA) to mobile treatment and care coordination, and the NYC Supportive Transition and Recovery Team(NYCSTART) for young adults experiencing a first episode psychosis. The bureau also evaluates mental health services and conducts population level surveys and behavioral health care system surveillance to identify gaps care and inform decision making, advocacy and policy. The Office of Research and Evaluation (ORE) support Bureau Leadership and Bureau Offices by providing surveillance, needs assessment research, program evaluation, data system development and maintenance, and program data reporting to support the work of the bureau. In addition, it informs the general public through publications and presentations.

DUTIES WILL INCLUDE BUT NOT BE LIMITED TO:

• Lead programmatic data activities including the development of data collection systems, dashboards, reporting, ad hoc data analysis, and report writing.
• Work with program staff to identify business needs and translate these needs into quantifiable data requirements for data collection/management systems.
• Lead the management of data in our Mental Health Maven Data System. Monitor data quality and initiate QI projects to improve programmatic data. Develop Maven reports and workflows to meet program needs.
• Lead the processing, cleaning, and preparation of data for analysis.
• Maintain technical written documentation such as data reports, data dictionaries, data access rules, methods, and business rules.
• Work closely with program leadership and staff to develop process and outcome indicators to track program performance and inform program operations. Offer ongoing recommendations for data-driven tracking and refinement of program metrics.
• Lead the design and execution of data analysis projects to inform program oversight. 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; Clearly communicate(oral and written) results of analyses to program staff/leadership and other non-technical audiences.
• Respond quickly and accurately to ad hoc data requests from internal(e.g. Directors, Assistant Commissioner) and external stakeholders (e.g. CityHall, public hearings).
• Incorporate an equity lens in all aspects of work.
• Supervise and mentor junior staff.
• Manage multiple projects and collaborate with interdisciplinary teams.

PREFERRED SKILLS:

• The successful candidate will have 3+ years full time experience processing, cleaning, manipulating, and analyzing large program or administrative datasets using statistical software such as SAS, SQL or R.
• Experience supervising a team of data analysts preferred.
• Experience working with relational databases preferred.
• Experience with Power BI or similar data visualization tools preferred.
• Possess project management skills as well as an ability to easily adapt to multiple programmatic and/or functional areas.
• Highly motivated, creative, flexible, able to work independently and collaboratively, able to handle multiple and diverse work assignments.
• Self-starter with ability to follow-up effectively and manage multiple priorities.
• The candidate will have excellent written and oral communication skills, and experience with scientific writing.
• Competency in the use of Microsoft Word, Excel, and PowerPoint is needed.
• Prior experience in Mental Health and Substance use program analytics and evaluation a plus.

Why you should work for us:

• Loan Forgiveness: As a prospective employee of the City of New York, you may be eligible for federal/state loan forgiveness and repayment assistance programs that lessen your payments or even fully forgive your full balance. For more information, please visit the U.S. Department of Education’s website (
• Benefits: City employees are entitled to unmatched benefits such as:

o a premium-free health insurance plan that saves employees over $10K annually, per a 2024 assessment. o additional health, fitness, and financial benefits may be available based on the position’s associated union/benefit fund. o a public sector defined benefit pension plan with steady monthly payments in retirement. o a tax-deferred savings program and o a robust Worksite Wellness Program that offers resources and opportunities to keep you healthy while serving New Yorkers.

• Work From Home Policy: Depending on your position, you may be able to work up to two days during the week from home.
• Job Security - you could enjoy more job security compared to private sector employment and be able to contribute to making NYC a healthy place to live and work.

Preferred Skills: Experience managing competitive procurements for a government agency Experience writing specifications or scopes of work (SOWs) for competitive procurements or contracts Experience using the PASSPort system Superior writing skills. Ability to manage a wide range of projects in a fast-paced environment. Established in 1805, the New York City Department of Health and Mental Hygiene (NYC Health Department) is the oldest and largest health department in the U.S., dedicated to protecting and improving the health of NYC. Our mission is to safeguard the health of every resident and cultivate a city where everyone, regardless of age, background, or location, can achieve their optimal health. We provide a wide array of programs and services focused on food and nutrition, anti-tobacco support, chronic disease prevention, HIV/AIDS treatment, family and child health, environmental health, mental health, and social justice initiatives. As the primary population health strategist and policy authority for NYC, with a rich history of public health initiatives and scientific advancements, from addressing the 1822 yellow fever outbreak to the COVID-19 pandemic, we serve as a global leader in public health innovation and expertise. Come join us and help to continue our efforts in making a difference in the lives of all New Yorkers! The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy. The NYC Health Department is an inclusive equal opportunity employer committed to providing access and reasonable accommodation to all individuals. To request reasonable accommodation to participate in the job application or interview process, contact Sye-Eun Ahn, Director of the Office of Equal Employment Opportunity, at [email protected] or View phone number on click.appcast.io.

CITY RESEARCH SCIENTIST - 21744

Qualifications 1. For Assignment Level I (only physical, biological and environmental sciences and public health) A master's degree from an accredited college or university with a specialization in an appropriate field of physical, biological or environmental science or in public health. To be appointed to Assignment Level II and above, candidates must have:

1. A doctorate degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and one year of full-time experience in a responsible supervisory, administrative or research capacity in the appropriate field of specialization; or
2. A master's degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and three years of responsible full-time research experience in the appropriate field of specialization; or
3. Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least a master's degree in an appropriate field of specialization and at least two years of experience described in "2" above. Two years as a City Research Scientist Level I can be substituted for the experience required in "1" and "2" above.

NOTE:

Probationary Period Appointments to this position are subject to a minimum probationary period of one year. Additional Information The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy. Agency: DEPT OF HEALTH/MENTAL HYGIENE Job Category: Health Salary Band: $100,000 to $125,000 Compensation: USD 98159 - USD 112883