This person will work as a vital member of a Medicare Stars team and across enterprise business partners to shape strategy and drive tactical planning for Medicare Stars Program. This position provides: (1) research (e.g., conduct literature reviews to understand programmatic and regulatory changes), (2) reporting (e.g., competitive analysis), and (3) analysis (e.g., identify and explain trends, generate actionable insights) to support a portfolio of initiatives.

The ideal candidate for this role will have experience in the following: MS Office Skills, SQL, Kognos, market research, data manipulation, and SAS.

Responsibilities:

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.

Complete projects within the constraints of scope, quality, time, and cost, to produce specified deliverables and meet customer expectations.

Develop validation and testing protocols to ensure 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.

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.

Support a portfolio of multiple active projects simultaneously (typically three to five).

Synthesize findings and implications of data work into reports and exhibits that can be used by clients.

Qualifications

Bachelors level degree with 3 years of relevant experience or Masters 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 required; 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.

Due to fluid nature and visibility of the departments work, flexible work hours are required and often exceed 50 hours per week.

Licensure, Certifications, and Clearances:UPMC is an equal opportunity employer. Minority/Females/Veterans/Individuals with Disabilities

Salary Range:
$22.60
to
$39.11

Union Position: No

For the best application experience, we encourage you to apply for this job from a non-mobile device.

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!

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.

This person will work as a vital member of a Medicare Stars team and across enterprise business partners to shape strategy and drive tactical planning for Medicare Stars Program. This position provides: (1) research (e.g., conduct literature reviews to understand programmatic and regulatory changes), (2) reporting (e.g., competitive analysis), and (3) analysis (e.g., identify and explain trends, generate actionable insights) to support a portfolio of initiatives.

The ideal candidate for this role will have experience in the following: MS Office Skills, SQL, Kognos, market research, data manipulation, and SAS.

Responsibilities:

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.

Complete projects within the constraints of scope, quality, time, and cost, to produce specified deliverables and meet customer expectations.

Develop validation and testing protocols to ensure 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.

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.

Support a portfolio of multiple active projects simultaneously (typically three to five).

Synthesize findings and implications of data work into reports and exhibits that can be used by clients.

Qualifications

Bachelors level degree with 3 years of relevant experience or Masters 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 required; 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.

Due to fluid nature and visibility of the departments work, flexible work hours are required and often exceed 50 hours per week.

Licensure, Certifications, and Clearances:UPMC is an equal opportunity employer. Minority/Females/Veterans/Individuals with Disabilities

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!

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.