Job Description

Job Title: Business Analyst II
Job ID: 61089822
Status: Full-Time
Regular/Temporary: Regular
Hours:
Shift: Day Job
Facility: UPMC Health Plan
Department: Payor Provider
Location: 600 Grant St, Pittsburgh PA 15219

Description

UPMC Health Plan has an exciting opportunity for a Business Analyst II in its Payor Provider department, located in downtown Pittsburgh at the U.S. Steel Tower.


This role will perform comprehensive analyses of data and information for various UPMC products. The Business Analyst II will take a leadership role in the enhancement, development, documentation, and communication of identified variances and processes. To successfully perform the role, the Business Analyst II must understand the causes of financial & clinical trends and identify anomalies.


Furthermore, the position requires relational database experience and critical thinking skills to identify how the methodology used to extract, aggregate, and present data impacts all analyses, conclusions, and anomalies. The ability to articulate findings to internal and external audiences is required. All responsibilities must be performed while weighing the practical considerations and potential barriers that need to be overcome.

 
Responsibilities:
  • Apply SQL programming to build data sets and ensure accuracy and consistency in reporting measures.
  • Compose advanced SQL queries to manipulate, extract, store, and quality check data.
  • 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.
  • Author SSRS reports and automate report creation with SSIS.
  • Design Power BI dashboards.
  • Utilize advanced excel skills to create financial models and present analyses.
  • Meet deadlines and turnaround times set by managers and department director (these deadlines and turnaround times will, at times, require the employee to work until the project is completed, meaning extended daily work hours, extended work weeks, or both).
  • Investigate variances and derive solutions to cost increases and quality issues.
  • Perform statistical analyses, and then explain this analysis to a non-technical audience of both internal and external customers and, at times, senior management.
  • Perform cost/benefit analysis.
  • Identify trends in expenses, utilization, medical quality, and other areas.
  • Manage special projects.
  • Monitor business unit operating performance against regional, national and international benchmarks.

Qualifications

  • Bachelor's degree in mathematics, statistics, health care, management, or related business field required. Master's degree preferred. Extensive related experience will be considered.
  • Minimum of two years of related work experience in financial and/or medical analysis required.
  • Experience in health care insurance or health care industry preferred.
  • Strong computer skills, with expert knowledge in Access, Excel, Crystal Reports, Cognos Reports, and other financial & statistical software packages.
  • Ability to work in a fast-paced environment a must. Ability to manage multiple tasks and projects, and forge strong interpersonal relationships within the department, with other departments, and with external audiences.
  • Attention to detail is critical to the success of this position.Excellent planning, communication, documentation, organizational, analytical, and problem solving abilities.
  • Advanced mathematical skills. Ability to interpret and summarize results of various analyses in a timely and meaningful way.
  • Ability to effectively approach problem solving. Ability to re-engineer processes to positively impact productivity in terms of timeliness and accuracy.
  • Ability to analyze financial & clinical results and to comprehend forecasting models. Knowledge and good understanding of all products and benefit designs of UPMC Health.

    Licensure, Certifications, and Clearances:

    UPMC is an Equal Opportunity Employer/Disability/Veteran

Salary Range: $23.28 to $40.28 / hour

Union Position: No

Apply Current Employee?

UPMC VALUES

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!

QUALITY & SAFETY
DIGNITY & RESPECT
CARING & LISTENING
RESPONSIBILITY & INTEGRITY
EXCELLENCE & INNOVATION

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.


WORKING HERE



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 2019


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

Share:
Talent Network