Fairview Health Services  Sr. Specialty Consulting Analyst in Twin Cities, Minnesota

JobTitle Sr. Specialty Consulting Analyst

Specialty IT Professionals

Location Fairview offices at Kasota

Department Technical Services - IS

Hours per 2 weeks 80

Shift Day

Date Posted 06/08/2018

Job Number 18-73396

Job Description:

Position Summary:

This is a hands-on position that performs the data analysis, coding and presentation. The prior work was done in SAS and expertise in SAS is a must-have, but this role should be thought of as an analyst who uses SAS (vs a SAS programmer), the created information is often output and then packaged and presented in Powerpoint. The ideal candidate has worked for a large payer / PBM as a data analyst working with pharmacy claims, is very familiar with the business and operations of specialty pharmacy, SAS is the primary analysis tool and his/her passion is discovering and presenting business and clinical insights from the data environment and from the relationship with business / clinical partners.

Position Responsibilities:

Using Medical and Pharmacy claims as input, the person in this role leverages their experience in healthcare (medical, pharmacy, PBM, Specialty pharmacy) to perform complex analysis to provide valued information to Fairview account teams and clients. This roles also investigates key drivers of benefit/physician/drug performance and proposes changes to improve performance, delivery or management. The focus of the role is often to access performance of the healthcare levers, processes, and controls in place, to manage specialty drug delivery and then provide recommendations and identify opportunities for Fairview, our Payers and/or our PBM partners.

More specifically, this person will play a lead role in the development/creation and completion of highly-complex analysis to validate, support, and/or report outcomes on various Fairview initiatives. This will be accomplished by the development/creation of new reports, analytical models, and tools, which may include items to be packaged and offered as new products to Fairview's clients. This role will work collaboratively across the Fairview organization to develop appropriate new approaches and analyses techniques, resulting in new reporting, models, and tools for the organization

II. Accountabilities and Primary Skills

Leads the development of analytic methodologies, models, reports and/or new products.

Manipulate large sets of medical and/or pharmacy data to achieve desired results

Creates new queries which include multiple table joins, understanding of table structures, creation of detailed lengthy formulas

Creates complex formulas (nested statements) and be able to manipulate and then present data using SAS.

Analyzes and interprets client pharmacy and medical benefit data.

Analyzes, interprets and summarizes data and/or reports related to the Specialty drug, the pharmaceutical market and/or Healthcare trends

Act as a champion of specialty analytic methodologies and mentor team members on best

Practices related to analysis, report creation and/or presentation

Proactively looks for new ways to do things that enhance performance, results and outcomes.

Responds with information available at hand; has consultative style with internal and external clients.

Articulate the industry trends to clients and the impact of trends and changes to the client financials.

Consults with and present results of analyses to account management teams and clients.

Provides recommendations to clients based on knowledge of the business and trend drivers.

Ownership role in responsibility for success of client analytics and ad hoc reporting.

Ability to apply strong knowledge related to specialty financial levers of a Specialty Pharmacy and/or industry standards/trends, in support of recommendations and business case development.

Advanced troubleshooting skills, including in-depth client data research, which may involve research and drivers of utilization. Understands resources needed and steps/processes on how to complete the problem. When an issue arises, able to understand how to navigate to a resolution.

Ability to understand and address the complexities of integrating medical and pharmacy data.

Knowledge of pharmacy and medical metrics and clinical quality measures, with critical thinking skills to apply variations of methods based on business needs

Demonstrated success in analytic or healthcare related consulting engagements.

Requires demonstrated analytic skills and creativity to quickly integrate information and develop proposals for new analytic initiatives. Demonstrate curiosity and determination in pursuing complex and innovative approaches to data needs. Progressive experience and leadership in clinical analytics in healthcare environment is essential.

Leads and guides complex client analytical work and serves as a knowledge expert for other analysts.

Maintains and runs code to create ad hoc, quarterly and other reporting in support of client expectations

Teamwork and Proactive Communication

Effective at proactively creating teamwork.

Ability to identify common goals and create win-win solutions, when working with people of differing viewpoints

Excellent at keeping team members up to date on information that impacts the team.

Consistently volunteers ideas and opinions.

Anticipates questions and issues and can articulate those answers in written and verbal form.

Ability to work in a fast paced environment and be flexible

Other duties as assigned.

Job Qualifications:


3-5 years of work experience in pharmacy benefits management, benefits consulting, heath care, or medical field.

Four year college degree or equivalent. Healthcare, mathematics, economics, science or finance background and Master's degree in math, statistics, computer science, or Public Health or related field with training qualitative analysis and research methods


Experience conducting data analyses, reporting, and forecasting on pharmaceutical, medical and/or financial data.

Advanced/significant hands-on experience using SAS/SASEG to analyze large administrative claims databases (e.g. over 5 million records), as defined as at least 3 years SAS/SASEG

Experience retrieving data from relational databases Oracle and MS SQL Server

Experience with managing and manipulating large sets of claims data.

Proficient in Microsoft Office, with advanced proficiency in Excel and/or MS Access

Healthcare Related:

Experience working in the specialty healthcare environment, both pharmacy and medical knowledge and experience is preferred.

Experience working in a hospital, health system, pharmacy, or provider practice setting is preferred.

Hands-on familiarity with administrative claims data and standard medical/pharmacy coding schemes (e.g. ICD-9, HCPCS, and CPT-4)

Competency with Microsoft office application and Access

Strong written and verbal communication skills

Demonstrated problem solving and organizational skills, with strong attention to detail

Ability to manage multiple, diverse projects in a fast-paced environment with tight deadlines

Business Related

Strong written and verbal communication skills are needed, including

ability to "translate" complex concepts, approaches and results to executive or lay audiences

to communicate to small and/or large audiences (both internal and external).

Experience communicating to senior management and drive decisions on complex, controversial issues.

Ability and preference to work in a team environment.

Key traits

Customer Focus

Critical Thinking

Learning Agility

Build Collaboration

About Fairview Health Services

Fairview Health Services (fairview.org) is an award-winning, nonprofit health system providing exceptional care across the full spectrum of health care services. Joined by HealthEast in June 2017, Fairview is one of the most comprehensive and geographically accessible systems in the state, with 11 hospitals—including an academic medical center and long-term care hospital—serving the greater Twin Cities metro area and north-central Minnesota.

Its broad continuum also includes 56 primary care clinics, specialty clinics, senior living communities, retail and specialty pharmacies, pharmacy benefit management services, rehabilitation centers, counseling and home health care services, medical transportation, an integrated provider network and health insurer PreferredOne. In partnership with the University of Minnesota, Fairview’s 32,000 employees and 2,400 affiliated providers embrace innovation to drive a healthier future through healing, discovery and education.

EEO/AA Employer/Vet/Disabled

All qualified applicants will receive consideration without regard to any lawfully protected status.