At UPMC, we are committed to keeping our community safe and healthy as the COVID-19 pandemic unfolds. As our team continues to provide Life Changing Medicine to our patients, our recruiters will continue to fill positions throughout this time. Interviews and other processes may be modified to protect the safety of our candidates and employees. Thank you for your patience.

For more information about UPMC's response to COVID-19, please visit

Job Description

Job Title: Business Analyst, Health Plan - Behavioral Integration
Job ID: 664001516
Status: Full-Time
Regular/Temporary: Regular
Shift: Day Job
Facility: UPMC Health Plan
Department: Behavioral Integration
Location: 600 Grant St, Pittsburgh PA 15219


UPMC Health Plan is hiring a full-time Business Analyst to support the Behavioral Integration department. This position will have a Monday through Friday daylight schedule and will be based out of downtown Pittsburgh, PA.  

The Business Analyst will provide SQL coding and reporting support for various UPMC programs and product lines (including Quality, Finance and Operations). The Business Analyst will take a role in the enhancement, development, documentation and communication of various processes and programmatic outcomes.  

Experience with writing SQL queries and working with Power BI and/or Tableau is highly preferred. A background working with health care data is also preferred. 

  • Effectively prioritize and complete all assigned tasks.
  • Work with users and developers to identify problems and propose solutions.
  • Identify areas of concern that may compromise client satisfaction.
  • Maintain employee/insured confidentiality.
  • Meet deadlines and turnaround times set by managers and department director.
  • Apply SQL programming to build data sets and ensure accuracy and consistency in reporting measures.
  • Execute recurrent data processes and create exception reports for those recurrent processes.
  • Identify, develop, and integrate new sources of data into existing databases.
  • Develop validation and testing protocols to ensure accuracy and quality of final deliverables.
  • Develop new reporting capabilities, reporting automation, and analytical dashboards.
  • Design/update Power BI and Tableau dashboards.
  • Utilize advanced Excel skills to create financial models and present analyses.
  • Investigate variances and derive solutions to cost increases and quality issues.
  • Perform analyses, and then explain this analysis to a non-technical audience of both internal and external customers and, at times, senior management.
  • Identify trends in expenses, utilization, medical quality, and other areas.
  • Manage special projects.
  • Monitor business unit operating performance against benchmarks.


  • Bachelor's degree or equivalent related work experience required.
  • Minimum of two years of general business experience required.
  • Minimum of two years of experience in business/industry specialty required.
  • Knowledge of commercial, Medicaid, and Medicare products preferred.
  • Competent in MS Office and PC skills preferred.
  • Working knowledge of COB (Coordination of Benefits) preferred. 
  • Organizational, interpersonal, and communication skills required.

Licensure, Certifications, and Clearances:

UPMC is an Equal Opportunity Employer/Disability/Veteran

Salary Range: $21.64 to $37.36 / hour

Union Position: No

Apply Current Employee?


At UPMC, our shared goal is to create a cohesive, positive, experience for our employees, patients, health plan members, and community. If you too are driven by these values, you may be a great fit at UPMC!


UPMC provides a total rewards package that can help you achieve the goals you have for your career and your personal life. Whether you want to learn a new skill through a training course, reach personal health and wellness targets, become more involved in your community, or follow a career path that provides you with the right experience to be successful, UPMC can help you get to where you want to be.


Now more than ever, YOU can help us shape our communities and UPMC into a better place for everyone to work, study, play, and thrive.

Learn more about working here and check out our policies and recent updates.

UPMC Health Plan Named Best Places to Work for LGBTQ Equality in 2020

UPMC Ranked #1 Best Places for Women and Diverse Managers in 2019

Talent Network