Allegheny County

Analyst, Multiple Positions

Allegheny County
Posted 10/19/2026full-timePittsburgh • Pennsylvania • United StatesJuniorMid-Level💰 $80,000 - $88,000 per yearWebsite
Apply

Core Competencies

Role fit
Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data analysis, automation, and quality improvement within healthcare and behavioral health programs. Proficient in building reusable tools and dashboards, while effectively communicating insights to drive operational and strategic decisions.

Highest-signal resume keywords
Python ProgrammingSQL Query LanguageData Pipeline DevelopmentQuality Improvement ProjectsHealthcare Data Analysis

Tech Stack

Tools & technologies
PythonSQL

About the role

Key responsibilities & impact
  • Gives program leaders a trustworthy picture of how services are performing and where they break down
  • Partners with program staff to find bottlenecks, test improvements, and inform operational and strategic decisions
  • Builds reusable, documented tools so recurring reporting runs reliably and partners can answer routine questions themselves
  • Supports child welfare, prevention and community services, aging, and Medicaid and behavioral health programs
  • Works closely with program managers and leadership, Analytics and Technology teams, and academic and foundation research partners
  • Defines measures, reviews them routinely with program leaders, and turns results into action
  • Designs and runs quality improvement projects, including process mapping, root cause analysis, and PDSA cycles, and measures their impact
  • Models capacity, caseload, queueing, and workflow to find bottlenecks and test alternatives before rollout
  • Automates recurring reporting with scheduled pipelines and certified data sources
  • Builds and maintains automated dashboards and self-serve tools for program staff
  • Writes clean, tested, version-controlled Python and SQL and builds reusable data pipelines
  • Owns analytics on program performance, service access, population health, finance, and quality within behavioral health programs
  • Works with healthcare and behavioral health datasets, including Medicaid claims, to understand access, utilization, cost, and quality
  • Translates findings for program, finance, and leadership audiences

Requirements

What you’ll need
  • Breaks ambiguous problems down, questions assumptions, weighs alternatives, and reaches sound conclusions from imperfect data
  • Learns how programs actually operate and finds the real need behind a request
  • Designs the right solution for that need (an analysis, dashboard, pipeline, or self-serve tool) and can justify the choice
  • Communicates insights clearly and turns them into recommendations that leaders, program staff, and technical peers can act on
  • Builds trusted working relationships with program staff and becomes a go-to voice in operational and strategic decisions
  • Brings creative ideas for improving practice
  • Has two or more years of related analytical experience, or equivalent transferable experience
  • Has working proficiency in Python or R and a query language such as SQL
  • Writes clean, documented, reusable code, and has project work they can share and explain
  • Balances speed with quality and validates results before they ship
  • Holds a bachelor’s degree in an aligned field, or an equivalent combination of education and experience
  • Handles sensitive data on vulnerable populations responsibly and embraces the DHS mission
  • Must be authorized to work in the U.S. without restriction
  • Must obtain or hold Act 33, Act 34 and FBI clearances
  • Ability to sit 2+ hours
  • Ability to carry up to 10 pounds
  • Reliable transportation for community work

Benefits

Comp & perks
  • Work that directly shapes services for families in Allegheny County
  • Ownership of a defined portfolio and the freedom to redesign how that work gets done
  • A modern stack (Python/R, Oracle SQL data warehouse, Tableau, ArcGIS, Git, Airflow, Docker, Power Apps) and approved AI tools
  • Rich integrated human-services data, experienced mentors, and academic research partners

ATS Keywords

✓ Tailor your resume
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills
Data AnalysisProcess MappingRoot Cause AnalysisPDSA CyclesAutomated ReportingVersion-Controlled CodeDashboard DevelopmentData ModelingBottleneck IdentificationPerformance Measurement
Soft Skills
Problem SolvingCommunicationRelationship BuildingCreative ThinkingDecision Making
Tools & Technologies
Automated DashboardsSelf-Serve ToolsData PipelinesReporting ToolsAnalytics Software
Certifications & Qualifications
Act 33 ClearanceAct 34 ClearanceFBI Clearance
Industry Keywords
Child WelfareCommunity ServicesMedicaid ProgramsBehavioral HealthOperational Decisions