Data Analyst, Bureau of Mental Health
About The Position
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.
Requirements
- Experience processing, cleaning, manipulating, and analyzing large program or administrative datasets using statistical software such as 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.
- Excellent written and oral communication skills.
- Experience in quantitative analytical methods.
- Strong organizational skills.
- 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.
- Three years of responsible full-time research experience in the appropriate field of specialization.
- At least two years of experience described in '2' above.
Nice To Haves
- 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.
- Experience with public mental health systems and recovery-oriented practices
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.
Benefits
- Federal/state loan forgiveness and repayment assistance programs
- Premium-free health insurance plan
- Additional health, fitness, and financial benefits may be available based on the position’s associated union/benefit fund.
- Public sector defined benefit pension plan
- Tax-deferred savings program
- Robust Worksite Wellness Program
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
