Client Experience Reporting Analyst

MedImpact Healthcare Systems, Inc.; San Diego (CA); Remote; USD 71,000 - 120,000; Full time

Job summary

An established industry player is seeking a Client Experience Reporting Analyst to enhance healthcare value through advanced analytics. This role involves preparing detailed reports, analyzing client data, and collaborating with teams to optimize plan performance. You will leverage your analytical skills and proficiency in tools like SQL and Python to drive insights that support client goals. Join a forward-thinking company that values innovation and teamwork, and make a meaningful impact in the healthcare sector. If you are passionate about data and its role in improving healthcare outcomes, this opportunity is perfect for you.

Qualifications

• 3+ years of experience in analytics, preferably in healthcare or PBM.
• Strong proficiency in SQL and Python for data analysis and reporting.

Responsibilities

• Prepare client-specific cost and utilization analyses for national accounts.
• Collaborate with account teams to identify strategic recommendations.

Skills

Analytical Skills

Communication Skills

Problem Solving

Customer Service

Education

Bachelor’s Degree

Tools

Microsoft Office Suite

SQL

Python

BI Software

Cognos

Job description

Client Experience Reporting Analyst page is loaded

Client Experience Reporting Analyst

Apply remote type Remote locations Remote time type Full time posted on Posted Yesterday job requisition id JR101539

Exemption Status:

United States of America (Exempt) $71,614 - $95,784 - $119,953

“Pay scale information is not necessarily reflective of actual compensation that may be earned, nor a promise of any specific pay for any selected candidate or employee, which is always dependent on actual experience, education, qualifications, and other factors. A full review of our comprehensive pay and benefits will be discussed at the offer stage with the selected candidate.”

This position is not eligible for Sponsorship.

MedImpact Healthcare Systems, Inc. is looking for extraordinary people to join our team!

Why join MedImpact? Because our success is dependent on you; innovative professionals with top notch skills who thrive on opportunity, high performance, and teamwork. We look for individuals who want to work on a team that cares about making a difference in the value of healthcare.

At MedImpact, we deliver leading edge pharmaceutical and technology related solutions that dramatically improve the value of health care. We provide superior outcomes to those we serve through innovative products, systems, and services that provide transparency and promote choice in decision making. Our vision is to set the standard in providing solutions that optimize satisfaction, service, cost, and quality in the healthcare industry. We are the premier Pharmacy Benefits Management solution!

Job Description

The Client Experience Reporting Analyst (CERA) supports client teams by producing advanced analytic reporting that identifies opportunities to optimize plan performance. Focus is on plan utilization, trends, and outliers compared to a benchmark at multiple levels (drug category/class, disease state, drug, pharmacy, provider, etc.) by employing analytical tools and an evidence-based approach. The CERA works with the core client account team to support client financial goals and achieve MedImpact business results. The CERA relies on data and performance indicators, input from the client, and core account team, to identify and promote plan opportunities. The CERA manages reporting and analytic needs to collaborate with and support account management, strategic initiatives, projects, and/or programs. This position focuses on supporting analytic and technical aspects of clinical and plan management.

Core Responsibilities: include the following. Other duties may be assigned.

• Prepare client-specific cost, trend, and utilization analyses for a premier national account on a recurring and ad-hoc basis.
• Combine large volumes of data into meaningful conclusions by utilizing a variety of business intelligence tools and data sources. Assists with all analytic needs, directly or in collaboration with other internal stakeholders to support recommendations being considered by assigned clients that align with both the clients’ and MedImpact’s mutual goals. Work in collaboration with account teams and internal stakeholders to identify strategic recommendations regarding client pharmacy benefit utilization and performance trends.
• Supports clinical and non-clinical data needs and/or contractual commitments. The CERA is an integral part of designing, developing, and driving the clinical components of their assigned account team’s strategic and financial goals. The CERA’s focus will be centered on using a variety of analytical tools and resources to create meaningful performance and utilization reporting. Identify opportunities which simultaneously improve the plan sponsor’s quality-focused and financial performance metrics.
• Identify opportunities to enhance existing and/or develop new analytic processes.
• Create analyses that drive overall strategy and demonstrate MedImpact’s value proposition to help the client make informed decisions.
• Supports analytics necessary for MedImpact’s evidence-based interventions and communication programs to clients. Provides documentation of recommendations for clinically appropriate and financially beneficial clinical initiatives (e.g., lower net cost, generic programs, QA programs, clinical and specialty programs, and applicable rebate management).
• Provides clinical utilization analyses and plan performance statistics in collaboration with the Clinical Program Manager(s) (Client Team) to support presentations to clients. Ensures timely and accurate review of plan data, according to policy, with appropriate intervention recommendations.
• Supports recommended clinically appropriate initiatives to optimize the value of MedImpact’s rebate administration program for clients while delivering on the lower net cost goal.

Detailed Analysis of Client Data

• Support selected marquee clients in synthesizing data to answer complex disease state and/or therapeutic category, specialty and non-specialty, demographic, prevalence, adherence, outlier, and other statistical related questions.

Supervisory Responsibilities

This job has no supervisory responsibilities.

Client Responsibilities

This is an internal position that requires collaborative service skills and interpersonal communication skills (listening/verbal/written). One must be able to collaborate and respond promptly to (Client Team) needs; Solicit client feedback to improve plan performance insights and output of information; occasionally join meetings with clients and professionally present to local and national leadership.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and/or Experience

• Bachelor’s Degree or equivalent combination of education and experience. Requires 3+ years of related experience and/or training.

• Pharmacy Benefit Management (PBM) and/or health plan experience required.

Computer Skills

To perform this job successfully, an individual should have knowledge of Microsoft Office Suite and a proficient knowledge of Access, Excel and relational databases (SQL, Python, Oracle, BI Software, Cognos, etc.).

Computer Skills

• Extensive experience using Microsoft Office applications, especially Excel, writing SQL, or PL/SQL (intermediate to advanced level) queries involving multiple table joins and nested queries.
• Python (intermediate to advanced) to merge and clean data from disparate sources (e.g., databases, Excel files, text files) to conduct analyses and to create reports and custom data visualizations (e.g., Plotly) that may be exported in a variety of formats including Excel, Word, and PowerPoint.

Other Skills and Abilities

• Analytical skills with Health Informatics.
• Receive business and clinical direction for objectives then translate into actionable reporting data.
• Create protocols and workflows to validate and document accuracy of reporting provided.
• Expand on existing reports and develop new plan ready reports and visuals (tables, histograms, starburst charts, etc.).

Reasoning Ability

Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

Mathematical Skills

Candidates must understand pharmaceutical calculations including fractions, decimals, ratios, proportions, percentages, and medication dosing. In addition, candidates must have the ability to calculate and/or interpret market shares and graphs.

Language Skills

Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, policies and procedures, and business correspondence. Ability to effectively present information and respond to questions from groups of managers, clients, and customers.

Competencies To perform the job successfully, an individual should demonstrate the following competencies:

Analytical - Synthesizes complex or diverse information; Collects and researches data; Uses intuition and experience to complement data.

Business Acumen - Understands business implications of decisions; Displays orientation to profitability; Demonstrates knowledge of market and competition; Aligns work with strategic goals.

Reasoning Ability

Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

Customer Service - Responds promptly to deliverable needs; Solicits feedback to improve service; Responds to requests for service and assistance; Meets commitments.

Oral Communication - Speaks clearly and persuasively in all internal and external situations; Listens and gets clarification; Responds well to questions; Demonstrates group presentation skills; Actively participates in meetings.

Problem Solving - Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions; Uses reason even when dealing with emotional topics.

Written Communication - Writes clearly and informatively; Edits work for spelling and grammar; Varies writing style to meet needs; Presents numerical data effectively; Able to read and interpret written information.

Physical