Data and Information Analyst (Court Clinic)

PMHCC, Inc. is seeking a Data and Information Analyst to support its Behavioral Health and Justice Division. The role researches, collects, cleans, and analyzes data related to behavioral health and criminal justice programs, while developing and maintaining information management systems. The Analyst also produces reports, visualizations, and actionable insights for internal and external partners.

What you'll do:

• Serve as a liaison between the clinical/administrative/justice partners and the Business Intelligence Unit for all research, data, and database needs
• Consult with various departments (internal and external) to understand the sources of available data and address the administrative, clinical, and legal data needs of BHJD
• Performs quality assurance of computer databases and the information contained within
• Design new or recommend modifications to current systems and programs, based on an initiative’s needs using Microsoft SQL Server, Qlik Sense, R, and Excel
• Create source and output documents, schedules for data entry, and training for new programs and initiatives
• Clean and transform data sources into a usable and compatible format for analysis
• Design research questions and projects; prepare comprehensive reports, graphs and tables; track and report on key performance indicators for programs and projects
• Initiate research projects that are data-driven, which directly address incoming questions from internal staff and external partners
• Conduct analytical and statistical research; make recommendations on data collection and analysis methods to ensure data is reliable and understandable
• Design and construct computer files and analytical processes and output reports for research projects
• Conducting research projects and determining appropriate research methods utilizing current research techniques
• Analyze the reporting needs in and between several departments (internal and external) and develop efficient methods of acquiring, formatting, and distributing information to the appropriate audience

What they're looking for:

• Experience with SQL databases and analysis software is required
• Possess an understanding of specific data-driven questions and build and manipulate queries in SQL
• Complex statistical analysis
• Computer software packages to manage and produce data such as tables, maps and/or graphic displays
• Excellent written analysis and oral presentation
• Ability to translate complicated data into useful information
• Advanced understanding of R and Excel
• Advanced understanding of queries and data tables
• Quantitative and Qualitative analysis skills
• Understanding of data management and storage infrastructures
• Ability to initiate and drive projects to completion with minimal guidance
• Ability to build key data sets to empower operation and exploratory analysis