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
Perform 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
Data 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
Conduct research projects and determine appropriate research methods utilizing current research techniques
Reporting
Analyze the reporting needs within and between several departments (internal and external) and develop efficient methods for acquiring, formatting, and distributing information to the appropriate audience.
Synthesize and interpret information, translate quantitative and qualitative data into visuals and reports
Provide data and graphics for projects in an efficient and timely manner and present information in a succinct and creative format that is digestible by an audience with varying levels of data interpretation experience.
Skills Required
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 operations 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, R)
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
Education and Experience
Familiarity with health and forensic data is a plus.
All candidates must have the following
Bachelor's Degree in Information Management, Computer Science, Statistics, Criminology, Criminal Justice, Psychology, Public Health, 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 R and Excel
At least one year of experience checking data for accuracy at both individual data point and summary level
Physical Demands/Working Conditions
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 1601 Market Street to 1101 Market Street, CBH, and various other destinations as needed. Valid driver's license and use of personal licensed and insured vehicle during work hours to travel from Center City to other sites (e.g., Norristown State Hospital, jails, Philadelphia Police Academy). Ability to pass all background checks required by the Philadelphia Prison System. Ability to effectively utilize computers, databases, and related common office software packages such as Microsoft Office
Other Job Requirements
Must live within the city limits of Philadelphia. Must have a valid driver's license and an acceptable driving record when operating a company/personal vehicle during work hours for work-related activities. Permission to operate a vehicle as part of your job duties will be contingent on your insurability as a driver consistent with PMHCC policy.
Must be able to work in an office environment that may include varying levels of distraction, noise, lighting, and privacy.
Equal Opportunity Employment
PMHCC, Inc. is committed to equal opportunity. It is our policy to support equal employment for all employees and applicants without regard to race, religion, color, sex, sexual preferences, age, national origin, disability, behavioral health status, military status, or any other characteristic protected by law.
Americans with Disabilities Act
Employees as well as applicants who are currently, or become disabled, must be able to perform the functions of the job with either reasonable accommodation or unaided. PMHCC, Inc. will examine reasonable accommodations on a case-by-case basis in accordance with the law.