Senior Consulting Analyst

Overview

The Senior Consulting Analyst will leverage a variety of data sources to perform complex analyses that provide valuable information to Fairview Pharmacy Services (FPS). Investigate data and deliver insights in order to enhance decision-making, increase efficiency, achieve better patient outcomes, and reduce cost. Help identify the levers that affect a variety of healthcare performance outcomes and metrics and provide recommendations to key stakeholders that enable improvements. Lead the development and execution of efforts to validate, support, and report the value provided by Fairview Pharmacy Services' suite of products, services, and initiatives.

Some of the benefits we offer at Fairview include medical insurance - as low as $0, dental insurance - also a $0 option, PTO (up to 24 days per year starting), and 403B with up to a 6% employer match; click here to learn more.

When working at M Health Fairview, we want to support our employees growth, honor their strengths and give them the freedom to feel empowered to make a difference in the lives of others.

Responsibilities Job Description

• Lead advanced analytic efforts, including development of methodologies, models, reports, etc.
• Manipulate large sets of pharmacy and medical data to provide insights
• Create multifaceted SQL queries that properly leverage multiple table joins and incorporate complex logic requirements
• Analyze and interpret pharmacy, medical, 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

Organization Expectations, as applicable:

• Demonstrates ability to provide care or service adjusting approaches to reflect developmental level and cultural differences of population served.
• Partners with patient care giver in care/decision making.
• Communicates in a respective manner and ensures a safe, secure environment.
• Individualizes plan of care to meet patient needs.
• Modifies clinical interventions based on population served.
• Provides patient education based on as assessment of learning needs of patient/care giver.
• Fulfills all organizational and learning requirements relevant to the role.
• Follows and maintains knowledge of all relevant laws, regulation, policies, procedures and standards.
• Supports improvement, efficiency and innovative thinking.
• Other duties as assigned.

Qualifications

Required Qualifications

• Bachelor's degree in statistics, computer science, mathematics, economics or otherwise related field or combination of relevant experience and education
• 3 years of experience in an analytic position where duties involved both the curation of datasets and analysis thereof
• 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
• 2+ years of experience working with and querying data via Epic Clarity

Preferred Qualifications

• Advanced degree as outlined above
• 5+ years of experience as noted above, or 3+ years in an analytic position dealing directly with healthcare and pharmacy data
• 4+ years of SQL and relational database experience
• Experience with SSMS & Oracle SQL Developer
• Experience with MS Power BI
• Epic Clarity Certification
• Experience with pharmacy-related Epic data

EEO Statement

EEO/AA Employer/Vet/Disabled: All qualified applicants will receive consideration without regard to any lawfully protected status