PMHCC Inc.-posted about 12 hours ago
Full-time • Entry Level
Philadelphia, PA
501-1,000 employees

The Behavioral Health and Justice Division (BHJD) seeks qualified candidates who are passionate about using data and information to effectively and efficiently inform policy, program, and intervention creation and evaluation for Philadelphia’s who find themselves at the intersection of the behavioral health and criminal justice system. 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/cleaning data, and performing statistical analysis needed to monitor trends and patterns of individuals served by this division. The Analyst will additionally support the design, implementation, and maintenance of computer-based information management systems necessary for the evaluation and analysis of ongoing trends in programs and initiatives. This position will take primary responsibility for “getting the data right,” managing and preparing data from the First Judicial Court Evaluation Clinic and various other contributors into a variety of formats including web applications, reports, graphs, charts, and other visual representations. Analysts will organize raw data, produce actionable insights, and effectively communicate this new information through data visualizations and messaging.

  • 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.
  • 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 audience with varying levels of data interpretation experience.
  • Other duties as assigned
  • Miscellaneous and project-based duties of a time-limited nature
  • 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
  • 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
  • Proficiency in critical thinking and usage of problem-solving skills
  • 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
  • Familiarity with health and forensic data is a plus.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service