Analyst, Business Analytics

CVS Health

20h

About The Position

We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time. Position Summary The Client Performance Management Analyst supports the financial and operational management of pricing and Discount Guarantees by performing detailed reconciliations, validating data accuracy, and preparing reporting that reflects customer financial outcomes. The Analyst contributes to audit readiness by maintaining clear and accurate documentation and assisting in the resolution of data discrepancies. The role collaborates closely with Finance, Underwriting, Account Management, and operational partners to uphold the integrity of Discount Guarantee processes, tools, and customer deliverables.

Requirements

• 4 years of professional experience in analytics, finance, operations, or another quantitative, data‑driven environment; exposure to pharmacy claims data is a plus.
• Advanced proficiency in Microsoft Excel (formulas, pivot tables, lookups) and comfort analyzing large datasets and performing data‑driven modeling to support reconciliations and performance reporting.
• Experience with Microsoft Access or similar data tools (e.g., queries/joins, basic SQL) used alongside reconciliation models, MAC analysis tools, or data‑warehouse sources.
• Understands (or can quickly learn) relational data‑warehouse structures and data flow—how fields, tables, and keys relate—and how similar datasets are produced at different levels of detail (e.g., transaction, member, plan).
• Ability to read and interpret basic contracts related to Discount Guarantees, pricing schedules, and client obligations.
• Strong analytical and problem‑solving skills, including the ability to investigate data discrepancies, identify root causes, and produce clear, audit‑ready documentation.
• High attention to detail and accuracy to support reconciliations, quarterly reporting, and refund processing.
• Ability to manage multiple recurring deliverables (e.g., annual, quarterly, and audit cycles) in a fast‑paced environment.
• Effective written and verbal communication to collaborate with Finance, Underwriting, Account Management, and operational teams on routine financial and operational inquiries.

Nice To Haves

• Healthcare/PBM exposure — e.g., familiarity with benefit configuration, pricing constructs (AWP, MAC), channel differences, and pharmacy claims.
• Intermediate SQL for analysis (e.g., multi‑table joins, window functions, CTEs).
• Experience building dashboards or reports with BI tools (e.g., Power BI, Tableau).
• Certifications preferred in Microsoft Office Specialist (MOS), SQL, Certified Pharmacy Benefits Specialist (CPBS), or relevant to position

Responsibilities

• Perform annual reconciliations of customer Discount Guarantees and address related inquiries to ensure accuracy and completeness.
• Prepare quarterly customer claims and performance reports with high attention to detail and data accuracy.
• Assist in responding to auditor requests by analyzing discrepancies, preparing clear documentation, and helping resolve issues promptly.
• Support the use and maintenance of reconciliation models, MAC analysis tools, and data‑warehouse sources to ensure consistent and reliable outputs.
• Provide analytical and data support for maintaining and improving departmental tools, reporting processes, and related documentation.
• Support Open Enrollment activities by updating Discount Guarantees configurations and ensuring accuracy of related data and documentation.
• Prepare and submit customer refund requests in accordance with established guidelines and required documentation.
• Collaborate with Finance, Underwriting, Account Management, and operational teams to support routine financial and operational inquiries.
• Provide data and analytical support for maintaining Discount Guarantees configurations under the direction of senior team members.

Benefits

• Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan.
• No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching.
• Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level