2,386,859open jobs
148,900companies
288,896added this week
Browse all
Salary
up to $61k per year
Location
In office (Philadelphia)
Seniority
Junior · 1+ year exp
Employment
Full-Time

Confirmed on the employer's own hiring board on Nov 19, 2026. First seen by Alion on Nov 19, 2026. Substance Use Philly scores B on the Alion truth index.

Overview
Company
Impact
Profile match
The Substance Use Prevention and Harm Reduction program provides information about substance use in Philadelphia. Learn how to get harm reduction supplies or treatment, get overdose and drug supply data, and more.

Position Summary:

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 population 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 ofcomputer-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 BHJD 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.

Duties and Responsibilities:

General Duties

  • 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
  • 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.

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,386,859 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Analytics
Remote, many countries
Similar stack
Same company
Philadelphia
$58k – $85k per year · Remote (United States) · Full-Time · 2+ years exp · Bachelor's Degree · United States
SQL
Apply
$75k – $95k per year · Remote (United States) · Full-Time · 3+ years exp · Bachelor's Degree · United States
Databases
Snowflake
DevOps
Azure
CI/CD
Cybersecurity
HIPAA
Management
Agile
Scrum
Apply
$125k – $200k per year · Equity · In office · 1+ year exp · Somerville
Python
SQL
AI/ML
dbt
DevOps
Git
GitHub
Analytics
Tableau
Power BI
Looker
Apply
In office · Secret · Full-Time · 2+ years exp · Bachelor's Degree · Huntsville
Python
MATLAB
Apply
$126k – $132k per year · In office · Contractor · 3+ years exp · Bachelor's Degree · Houston
Apply
Remote (EAEU) · Moscow
Python
SQL
Databases
PostgreSQL
Greenplum
Trino
AI/ML
Great Expectations
DevOps
Rest API
Git
Analytics
Power BI
QlikSense
Superset
Management
Confluence
Jira
Apply
Remote (EAEU) · Bachelor's Degree · Saint Petersburg
Python
SQL
AI/ML
SciPy
LLM
Analytics
Matplotlib
Apply
Remote (EAEU) · 2+ years exp · Moscow
Management
UML
BPMN
Apply
Remote (APAC) · Full-Time · Singapore
SQL
Analytics
Microsoft Excel
Management
Confluence
Jira
Apply
Remote (Europe) · Contractor
Databases
Databricks
DevOps
AWS
Amazon S3
Management
Confluence
Life Sciences
GLP
Apply
$248k – $372k per year · Hybrid · Full-Time · 10+ years exp · Bachelor's Degree · Philadelphia · Saint Louis
Apply
In office · 2+ years exp · Philadelphia
Apply
$127k – $167k per year · In office · 2+ years exp · PhD · Philadelphia
Python
Life Sciences
PCR
Flow Cytometry
ELISA
Apply
$76k – $96k per year · In office · 2+ years exp · Bachelor's Degree · Philadelphia
JavaScript
Java
TypeScript
SQL
Java
Spring Boot
Frontend
Vue.js
DevOps
Rest API
CI/CD
Management
Agile
Apply
≈ $44k – $94k per year (Estimated) · In office · 2+ years exp · High School Diploma · Philadelphia
Apply
See all jobs
This is one of many
2,386,859 more open roles from verified company boards, updated every day.