Data and Information Analyst

PMHCC Inc.•Philadelphia, PA
•$0 - $61,361•Onsite

About The Position

The Behavioral Health and Justice Division (BHJD) seeks a Data and Information Analyst to use data and information to inform policy, program, and intervention creation and evaluation for Philadelphia residents at the intersection of the behavioral health and criminal justice systems. The Analyst researches, collects, cleans, and analyzes data to monitor trends and patterns among individuals served by the division and supports the design, implementation, and maintenance of computer-based information management systems used to evaluate programs and initiatives. The Analyst takes primary responsibility for data quality and prepares information from BHJD and other contributors in formats such as web applications, reports, graphs, charts, and other visualizations. The role organizes raw data, produces actionable insights, and communicates findings through visualizations and clear messaging. It also serves as a liaison between clinical, administrative, justice, and Business Intelligence partners, and supports their research, data, database, and reporting needs. The position requires a bachelor's degree in a relevant field and at least one year of experience in data analytics and statistical analysis, data-driven reporting, acquiring data from multiple sources and formats, SQL databases, R and Excel, and data accuracy checks. Familiarity with health and forensic data is a plus. The employee must live within Philadelphia city limits, meet driving requirements for work-related travel, and be able to perform the stated office and travel duties.

Requirements

  • Bachelor's degree in Information Management, Computer Science, Statistics, Criminology, Criminal Justice, Psychology, Public Health, Sociology, or a related field.
  • 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 using a database program and spreadsheets for reporting and analysis.
  • At least one year of experience acquiring and using data in various formats, such as JSON, XML, CSV, and Excel, from sources such as APIs, downloaded files, curated datasets, and script packages.
  • 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 accuracy at both individual data-point and summary levels.
  • Experience with SQL databases and analysis software.
  • Ability to understand data-driven questions and build and manipulate SQL queries.
  • Complex statistical analysis skills and knowledge of statistics, including experience using statistical packages to analyze large datasets.
  • Advanced understanding of R, Excel, queries, and data tables.
  • Ability to use software packages to manage and produce data, including tables, maps, and graphic displays.
  • Quantitative and qualitative analysis skills.
  • Understanding of data management and storage infrastructures.
  • Ability to build key datasets for operational and exploratory analysis and write queries to extract data for reports and information requests.
  • Ability to initiate and drive projects to completion with minimal guidance.
  • Excellent attention to detail and accuracy.
  • Excellent written and verbal communication, analysis, and presentation skills, including the ability to explain complex data and analytical concepts clearly.
  • Ability to collaborate, share information clearly and concisely, prioritize requests, and respond with speed and agility.
  • Must live within the city limits of Philadelphia.
  • Must have a valid driver's license and an acceptable driving record when operating a vehicle for work-related activities; permission to drive for job duties is contingent on insurability under PMHCC policy.
  • Must be able to pass all background checks required by the Philadelphia Prison System.
  • Must be able to physically perform the duties and work in the required environmental conditions, including office tasks and local travel.

Nice To Haves

  • Familiarity with health and forensic data.

Responsibilities

  • Serve as a liaison between clinical, administrative, and justice partners and the Business Intelligence Unit for research, data, and database needs.
  • Consult with internal and external departments to identify available data sources and address BHJD's administrative, clinical, and legal data needs.
  • Perform quality assurance on computer databases and their contents.
  • Design new systems or recommend modifications to current systems and programs based on initiative needs, using Microsoft SQL Server, Qlik Sense, R, and Excel.
  • Create source and output documents, data-entry schedules, and training for new programs and initiatives.
  • Clean and transform data from multiple sources into usable, compatible formats for analysis.
  • Design research questions and projects; prepare comprehensive reports, graphs, and tables; and track and report program and project key performance indicators.
  • Initiate data-driven research projects addressing questions from internal staff and external partners.
  • Conduct analytical and statistical research and recommend data collection and analysis methods to ensure data is reliable and understandable.
  • Design and construct computer files, analytical processes, and output reports for research projects.
  • Conduct research projects and determine appropriate methods using current research techniques.
  • Assess reporting needs across internal and external departments and develop efficient methods for acquiring, formatting, and distributing information.
  • Synthesize and interpret information and translate quantitative and qualitative data into visuals and reports.
  • Provide data and graphics efficiently and on time, presenting information in a succinct, creative format accessible to audiences with varying levels of data interpretation experience.
  • Travel locally to work sites as needed using public transportation, on foot, or a personal licensed and insured vehicle.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service