UPMC Health Plan's Medicare/SNP Product team is seeking a Strategy Analyst!

This person will work as a vital member of various project teams that address strategy and planning issues across all of UPMC's divisions (Hospital and Community Services, Physician Services, Health Plan, and International and Commercial Services). This position provides (1) research (e.g., conduct literature reviews to understand changing clinical treatments), (2) reporting (e.g., calculate market share), and (3) analysis (e.g., identify trends underlying volume changes) to support a portfolio of projects.

Hiring team preferences:

• Microsoft Office Proficient, especially Excel and PowerPoint
• Comfortable researching competeting data
• Health Care Industry experience

This role is a combination of work-from-home and in-office.

Responsibilities:

• Develop validation and testing protocols to ensure the accuracy and quality of final deliverables. Ensures the quality of others' analytical work through a formal review/quality check process. Identify technical errors and limitations, as well as potential methodological and logic deficiencies in final deliverables.
• Provide analytical expertise in the development and support of various projects that focus on environmental and market assessments, new business development, and clinical utilization patterns.
• Complete projects within the constraints of scope, quality, time, and cost, to produce specified deliverables and meet customer expectations.
• Actively research new trends and dynamics; identify market dynamics that may affect UPMC and convey these to the Departments' leaders; learn about UPMC's full spectrum of operations and markets served.
• Synthesize findings and implications of data work into reports and exhibits that can be used by clients.
• Support a portfolio of multiple active projects simultaneously (typically three to five).
• Selected duties include, but are not limited to: the preparation and formatting of standard and customized data reports; the creation of decision support tools such as utilization models-primarily descriptive in nature; profiles and assessments of market trends; profiles and assessments of new markets; profiles and assessments of competitors and complimentors; profiles and assessments of clinical capacity and patient throughput; literature reviews; complete maps using software tools; analysis of patient satisfaction data. Understand data sources and tools that exist throughout UPMC (e.g., financial and quality data systems); apply this knowledge to the Department's projects; act as a liaison to the owners of these data systems to ensure they are applied to the Department's projects. Fully document and understand the definitions, limitations, and applicability of different data sources; convey these parameters to clients/consultants during the formulation of data requests. Utilize Cognos reporting tools, SQL programming and advanced Excel capabilities (e.g., program macros) to build data sets for analysis which would include: health care volume and utilization trends, predictive modeling, basic modeling, and general research and decision support activities.

• Bachelor's level degree with 3 years of relevant experience or Master's level degree with 1 year of relevant experience required.
  • Preference is given to analytically oriented programs such as economics, statistics, information sciences, or mathematics.
  • Experience with Excel and Visual Basic is required; experience with Access and SQL is preferred; experience with Cognos and econometric analysis experience is preferred.
• Relevant experience in the following areas is required: (1) market research (2) experience using quantitative, business intelligence and/or relational database. (3) manipulation of data
• Microsoft Office Proficient, especially Excel and PowerPoint
• Health Care Industry experience

Licensure, Certifications, and Clearances:

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