The Behavioral Health and Justice-Related Services (BHJRS) Division seeks to reduce stigma, increase behavioral health awareness across systems, strengthen community and cross-system capacity, support recovery and resilience, and increase early intervention and access to behavioral health services. To fill this position, BHJRS 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, BHJRS has developed the new and important position of Research and Information Analyst. In this position, the Information 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 is required.
The Information 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 modify 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 modifying computer databases, designing source and output documents, developing schedules for the input of data, and testing new programs.
Build and maintain a data architectural system to identify, track, and monitor all individuals who are found incompetent to stand trial and other related forensic populations in Philadelphia (including those hospitalized, incarcerated, and in the community) in Microsoft SQL Server.
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.
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.
Produce tracking systems and clinical screenings into database that will ultimately be integrated into the overarching BHJRS database for current and future grants.
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.
Coordinate with IS for improvement in data-storage, access, and utilization methodology.
Serve as a liaison between the clinical/administrative/justice partners and the Data Unit for all research, data, and database needs.
Possess an understanding of specific data-driven questions and build and manipulate queries in SQL to answer such questions.
Conducting research projects and determining appropriate research methods utilizing current research techniques; Performing complex statistical analysis; Using computer software packages to manage and produce data such as tables, maps and/or graphic displays; Written analysis and oral presentation; Ability to translate complicated data into useful information; Expertise with SQL databases; authoring pipelines via SQL; Advanced understanding of Excel; Advanced understanding of queries and data tables; Excellent quantitative and data analysis skills; Advanced 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; Ability to write queries to extract data for reporting or information requests; Extremely strong attention to detail and accuracy; Knowledge of statistics and experience using statistical packages for analyzing large datasets (Excel, SAS, SPSS ). Excellent written and verbal communication skills with the ability to collaborate and work with others; share information in a clear and concise manner. Ability to effectively communicate theoretical and analytical concepts and findings, both orally and in writing. Ability to prioritize and respond to requests with speed and agility; and Proficiency in critical thinking and usage of problem-solving skills.
Education and Experience:
Familiarity with health data is a plus.
All candidates must have the following:
Bachelor’s Degree in Information Management, Statistics, Criminology, Criminal Justice, Psychology, Political Science, Sociology or a related field of study. At least one year of experience in a technical field performing data analytics, modeling, and statistical analyses. At least one year of experience producing detailed data-driven reports and analyses, which has included utilizing a database program and spreadsheets for information reporting and analysis. At least one year of experience acquiring and using data in various formats (JSON, XML, CSV, Excel, etc.) from various sources (APIs, files downloaded from the web, hand-curated datasets, packages of scripts, etc.). At least one year of experience using SQL databases. At least one year of experience with data warehousing and data pipelines. At least one year of experience checking data for accuracy at both individual data point and summary level.
Ability to physically perform the duties and to work in the environmental conditions required such as maneuvering in office space – reaching file cabinets, fax and copier machines when necessary. Must be able to sit for up to 2 hours looking at a computer monitor and using a keyboard and mouse to perform data entry functions. Able to travel locally via public transportation and on foot from 123 S. Broad Street to 1101 Market Street, CBH, and various other destinations as needed. Ability to pass all background checks required by the Philadelphia Prison System.