Leverage a variety of data sources including electronic medical records, claims, dispense records, etc. to provide valuable and actionable information to Fairview Pharmacy Services (FPS). Analyses will help to inform stakeholders on how FPS activities and initiatives provide value to our patients and to the organization by increasing quality and safety, decreasing costs, and/or increasing patient & provider satisfaction. To this end, the Senior Outcomes Consulting Analyst will lead development and completion of highly-complex analyses. Analyses may be designed by the analyst or in partnership with resources throughout FPS. The analyst will regularly be responsible for curating (gathering, cleaning, validating, etc.) the proper data for analyses, as well as providing insight into those data.
Lead the development of advanced analytic efforts relating to FPS outcomes of interest
Manipulate large sets of medical and pharmacy data to achieve desired results
Create multifaceted queries, primarily coding in SAS and SQL (Oracle & MS), that properly leverage multiple table joins and incorporate complex logic requirements
Analyze and interpret medical, pharmacy, and benefit data
Present findings to technical and non-technical audiences
Create data visualizations that communicate results and impact of analyses
Find creative solutions to the challenges of working with healthcare data
Minimum: 4-year college degree in statistics, mathematics, computer science, economics, finance, healthcare, or otherwise related field
Preferred: Advanced degree in the same
Minimum: 3 years of experience in an analytic position where duties involved both the curation of datasets and analysis thereof
Preferred: 5+ years of experience as noted above, or 3+ years in an analytic position dealing directly with healthcare and pharmacy data
2+ years of SAS coding experience must be able to code manually (i.e. applicants whose experience with SAS is limited to point and click interfaces will not be considered)
2+ years of SQL coding experience (any)
2+ years of experience with relational databases
Experience leveraging Excel for mathematical functions and data manipulation
Proficiency with the MS Office suite
4+ years of SAS, SQL, and relational database experience
Experience with Oracle SQL Developer & SSMS
Experience with MS Power BI
Proficiency in other advanced analytic tools/software such as R, Python, etc.
Together with the University of Minnesota and University of Minnesota Physicians we have created M Health Fairview. M Health Fairview is the newly expanded collaboration among the University of Minnesota, University of Minnesota Physicians, and Fairview Health Services. The healthcare system combines the best of academic and community medicine — expanding access to world-class, breakthrough care through our 10 hospitals and 60 clinics.Fairview Health Services (fairview.org) is an award-winning, nonprofit health system providing exceptional care across the full spectrum of health care services. Fairview is one of the most comprehensive and geographically accessible systems in the state, with 10 hospitals—including an academic medical center and long-term care hospital—serving the greater Twin Cities metro area.Its broad continuum also includes 60 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.