Data Analyst; 4155-205-N

at  Catholic Charities Brooklyn and Queens

• Far Rockaway, NY 11691
  When you join the CCBQ Team, you will have an impact on the lives of many. For over 125 years, Catholic Charities Brooklyn and Queens has been providing quality social services to the neighborhoods of Brooklyn and Queens, and currently offers 160-plus programs and services for children, youth, adults, seniors, and those struggling with mental illness. Our Clinics are community-based which offer a professional and welcoming environment for both clients and staff. The Clinics provide psychotherapeutic and psychopharmacological therapy, as well as individual, group, family therapy, crisis intervention, medication management, case management and collateral sessions. Our staff members follow an approach to health care that emphasizes wellness, recovery, trauma-informed care, and physical-behavioral health integration.

QUALIFICATIONS

• Master’s degree in social work, public health, public policy, public administration, statistics, quantitative research methods or related field, with substantive focus on quantitative research methods/statistics/epidemiology or Bachelor’s Degree with an additional 2 years’ experience with statistics
• At least 2 years of experience in research / monitoring & evaluation / data analysis in support of programs in health and human services (social services, public health, healthcare, mental health, education etc.,)
• Advanced Excel skills, knowledge of pivot tables, advanced functions such as VLOOKUP and charts.
• Experience or interest in macros is a plus.
• Experience with writing SPSS syntax or translatable experience with other statistical software
• Advanced knowledge of statistics (multivariate statistical models)
• Experience with data visualization (tables, charts, data dashboards)
• Experience working with large datasets
• Familiarity with the nuances/complications/imperfections of real-world program / administrative data (that are often not explicitly collected for research purposes) and ability to work with imperfect data)
• Analytical Skills: Data analysts work with large amounts of data: facts, figures, and number crunching.
• Attention to Detail: Data is precise.
• Bilingual Spanish/English; Russian/English; Creole/English; Chinese/English; Korean/English speaking preferred.
• Frequently lifts and/or moves up to 10 pounds.
• Ability to travel throughout the five boroughs from site to site.
• Able to work flexible hours and days – including weekends/evenings/holidays according to needs of a 24/7 programs.

• The Data Analyst will collect and analyze data and prepare all data reports and analyses in support of SAMHSA requirements and expectations around performance assessments and quality improvement.
• Develop automated processes to generate routine quarterly reports on measures of efficiency and effectiveness for senior leadership and program teams
• Communicate data findings via reports and presentations to staff with varying levels of familiarity with data
• Conduct quality checking to ensure completeness and validity of data
• Match large internal datasets on client characteristics and services with large external datasets on hospitalizations among Medicaid clients extracted from New York State Office of Mental Health (OMH)’s Psychiatric Services and Clinical Knowledge Enhancement System for Medicaid (PSYCKES-Medicaid).
• Work closely with EHR (Electronic Health Record) specialists, clinical leadership and direct service staff to develop an Excel-based risk tool that’s practical for use in the field by direct service providers.
• Support with other projects, tasks and events as needed by the department