2027 Spring/Summer Internship: Business Analytics Intern

About the role

Allegheny County Department of Human Services (ACDHS) is the largest agency with a $1 billion+ budget, supporting over 200,000 residents annually through community partnerships. The ACDHS Internship Program offers students practical experience in public service, involving meaningful projects that enhance social services. ACDHS seeks undergraduate and graduate students to apply their skills, work with professionals, and impact programs serving vulnerable groups. Interns contribute to projects that improve lives across Allegheny County, gain experience with one of the nation’s leading human services agencies, work alongside experienced professionals and community partners, and build practical skills while exploring careers in public service.

Responsibilities

• Support business unit functions, including billing support, report running, and data monitoring.
• Complete analytics projects such as dashboard development, fee‑for‑service program evaluation, and process optimization.
• Support the initial development and stabilization of the aging business unit.
• Assist the aging analytics team with projects and critical processes during a period of significant project backlog as new work begins.

Requirements

• Enrolled in an accredited U.S. college or university (undergraduate or graduate).
• Available to work up to 29 hours per week (actual hours vary by role and term).
• Able to work in person at an assigned ACDHS office.
• Must maintain an Allegheny County address for the duration of the internship.
• International candidates must meet federal I‑9 employment eligibility requirements.

Skills

• Proficiency in Excel (required).
• Experience with dashboarding tools such as Tableau or Power BI (highly preferred).
• Experience or training in SQL or programming languages (required).
• Background in business or business‑adjacent majors (preferred, given the business‑core focus of the internship).

Benefits

• Learn how analytics are applied in a human services setting and complete projects from start to finish.
• Gain exposure to real business problems and processes for deeper learning.
• Acquire practical hands‑on experience and the ability to make a direct impact on the local older adult population.

Schedule

The internship runs from January 2027 through Summer 2027, with a commitment of 20‑29 hours per week. Hours are flexible within standard business hours (8:30 a.m.–4:3