UPMC | Business Analyst II- Remote | Pittsburgh, PA | United States | BigDataKB.com | 2023-01-15

Description

UPMC’s Medicare HCC Team is seeking a Business Analyst II

The selected individual will perform in-depth data analytics and reporting in support of our provider-focused HCC incentive campaigns, which directly support Medicare and Affordable Care Act revenue. On a daily basis the analyst will perform a variety of ad hoc data analyses of core data sources, including membership and claims data, to interpret and report campaign activity. This role provides extensive experience in SQL and Power BI, an understanding of data sources and tools used throughout UPMC and developing skills for advancement within healthcare data analytics.

Someone with a proficient to advanced skillset in the below areas is preferred:

• MS Excel experience including graphing, macros, and data analysis
• SQL
• MS ACCESS
• Econometric/statistical data analysis experience

This position can be completely Remote

Responsibilities:

• Maintain portfolio of projects/reports as assigned and produce per required cadence
• Identify and display, using tables and graphics as appropriate, trends in expenses, utilization, revenue, membership, quality, and other decision areas
• Perform analyst duties to include: proactively reviewing of data and trends, highlighting unusual/unexpected results, offering/deriving suggestions for improvement, implementing agreed-to solutions, increasing knowledge of existing processes, and seeking to learn new tools
• Develop validation and testing protocols to ensure accuracy and quality of final deliverables
• Identify technical errors and limitations of analysis
• Explain analysis to a non-technical audience of both internal and external customers and, at times, senior management.
• Must document all processes performed following departmental standards and review/execute documentation of other’s processes to provide backup support
• Meet deadlines and turnaround times set by managers and department directors (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)
• Self-manage diverse set of projects as assigned, and be able to multitask several projects at once

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.
• 
  Other preferences:
  • 
    MS Excel experience including graphing, macros, and data analysis
  • 
    SQL
    
  • MS ACCESS
    
  • Econometric/statistical data analysis experience
• 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 is 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:

• Act 34
• 
  UPMC is an Equal Opportunity Employer/Disability/Veteran