Business Analytics Analyst

About the Role

Join CVS Health in shaping a more integrated, accessible, and compassionate healthcare experience for individuals and communities. As a Business Analytics Analyst, you will be instrumental in supporting the financial and operational oversight of pricing and Discount Guarantee programs through detailed reconciliations, data validation, and comprehensive reporting reflecting customer financial outcomes. Your efforts will uphold audit readiness by maintaining detailed documentation and resolving data discrepancies, collaborating closely across Finance, Underwriting, Account Management, and operational divisions to ensure the integrity of Discount Guarantee processes and tools.

Key Responsibilities

• Conduct annual reconciliations of customer Discount Guarantees and manage related inquiries to confirm completeness and accuracy.
• Develop quarterly reports detailing customer claims and performance with a meticulous focus on data accuracy.
• Assist auditors by analyzing discrepancies, creating clear documentation, and facilitating prompt issue resolution.
• Maintain and support reconciliation models, MAC analysis tools, and data-warehouse resources to ensure consistent, reliable data outputs.
• Contribute analytical support for enhancing departmental tools, reporting methods, and documentation procedures.
• Participate in Open Enrollment activities by updating Discount Guarantee configurations and verifying accuracy of related data and documentation.
• Prepare and process customer refund requests aligned with established protocols and documentation standards.
• Collaborate with relevant teams to address routine financial and operational queries.
• Support maintenance of Discount Guarantee configurations under guidance from senior team members.

Qualifications and Experience

• Minimum of 4 years professional experience in analytics, finance, operations, or other quantitative, data-driven roles; exposure to pharmacy claims data is advantageous.
• Advanced skills in Microsoft Excel including formulas, pivot tables, and lookups; proficient in handling large datasets and conducting data-driven modeling for reconciliations and reporting.
• Experience with Microsoft Access or comparable data tools (e.g., SQL queries and joins) utilized alongside reconciliation and analysis tools.
• Understanding or ability to quickly learn relational data-warehouse design, data flow, and multi-level dataset structures.
• Capability to read and interpret basic contracts related to Discount Guarantees and pricing commitments.
• Strong analytical and problem-solving aptitude, capable of investigating data variances, identifying causes, and documenting findings for audits.
• Attention to detail and precise execution in supporting reconciliations, quarterly reports, and refund procedures.
• Ability to juggle multiple regularly scheduled deliverables in a demanding environment.
• Effective communication skills for coordinating with Finance, Underwriting, Account Management, and operations.

Preferred Skills and Certifications

• Familiarity with healthcare or Pharmacy Benefit Manager (PBM) domains including benefits configuration and pharmacy pricing models (e.g., AWP, MAC).
• Intermediate SQL skills such as multi-table joins, window functions, and common table expressions (CTEs).
• Experience creating dashboards and reports using business intelligence tools like Power BI or Tableau.
• Relevant certifications such as Microsoft Office Specialist (MOS), SQL credentials, or Certified Pharmacy Benefits Specialist (CPBS) are desirable.

Educational Background

A Bachelor's degree in a quantitative or analytical discipline (examples include Data Analytics, Statistics, Mathematics, Finance, Accounting, Economics, Computer Science, Information Systems, Health Informatics, or Health Information Management) or equivalent practical experience.

Additional Information

• Expected weekly work hours: 40 hours.
• Employment type: Full-time onsite position.
• Compensation range: Annual base salary typically between $43,888 and $102,081, varying by experience, education, and location, with eligibility for bonus or incentive programs.
• Comprehensive benefits package covering medical, dental, vision, paid time off, retirement plans, and wellness resources tailored to employee eligibility.
• Commitment to an inclusive work environment valuing diversity and belonging.
• Application deadline is August 21, 2026.
• Compliance with employment laws regarding applicants with criminal histories.