Data and Information Analyst

Job Description  

Job Description

Position Summary:

Behavioral Health and Justice Division (BHJD) seeks to provide equal opportunities for treatment, support, and community integration for justice involved Philadelphians with behavioral health challenges.
To fill this position, BHJD seeks qualified candidates who are passionate about making Philadelphia’s behavioral health and justice systems more efficient and effective in responding to individuals with mental health issues and substance abuse disorders.
To assist in accomplishing these goals, BHJD has developed the position of Data and Information Analyst. In this position, the Analyst will be responsible for researching, collecting data, and performing statistical analysis needed to monitor trends and patterns. Responsibility for the design, implementation, and maintenance of computer-based management information systems necessary for the evaluation and analysis of ongoing programs or trends is an important aspect of the work.

Experience with SQL databases and analysis software is required.
The Analyst is also required to have an advanced understanding of the function and utilization of queries and data tables. This position will take primary responsibility for “getting the data right,” managing and preparing data from various contributors for a variety of web applications, reports, graphs, charts, and other pertinent documentation. Candidates must be able to organize raw data, produce actionable insights, and effectively communicate this new information through data visualizations and messaging.

Duties and Responsibilities:

Conduct analytical and statistical research; make recommendations on data collection and analysis methods to ensure data is reliable and understandable; synthesize and interpret information, translate quantitative and qualitative data into visuals and reports for varying audiences
Design research questions and projects; prepare comprehensive reports, graphs and tables; track and report on key performance indicators for programs and projects
Design and construct computer files and analytical processes and output reports for research projects
Design new or recommend modifications to current systems and programs, based on assessed needs using query languages, report writers, interactive database programs, spreadsheets and/or application generators; performs related duties which include quality assurance of computer databases, designing source and output documents, developing schedules for the input of data, and testing new programs
Design and improve the process by which data is collected and stored to identify, track, and monitor all individuals served by the behavioral health system in Philadelphia (including those hospitalized, incarcerated, and in the community) using Microsoft SQL Server, Qlik Sense, R, and Excel.
Consult with various departments (internal and external) to understand the sources of incoming raw data and address the administrative, clinical, and legal needs of forensic individuals
Determine database structural requirements by analyzing and programming multiple sources of data, configuring the operationalization of such data, and determine the optimal presentation, and evaluation systems via SQL, Qlik Sense, R, and Excel.
Transform various incoming data sources into usable and compatible format for SQL importing
Follow database architectural and design projects to completion and provide continued training and support regarding functionality
Analyze the reporting needs in and between several departments (internal and external) and develop the most efficient methods to utilize the current data, identifying additional needs, and building additional reporting by collecting raw data and translating the information to IS for standardized and novel reporting purposes
Provide data and graphics for projects in an efficient and timely manner and present information in a succinct and creative manner
Initiate research projects that are data-driven, which directly address incoming questions from internal staff and external partners
Serve as a liaison between the  clinical/administrative/justice  partners and the Data Unit for all…