Manager, Rebate Forecast Tools Management

Overview

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.

The Manager, Rebate Forecast Tools Management is responsible for supporting the development, maintenance, and execution of rebate forecasting tools and processes within Caremark Underwriting. This role plays a key part in ensuring accurate and reliable forecasting outputs by managing model inputs, supporting analysis of rebate-related assumptions, and coordinating cross-functional activities tied to pricing and forecasting deliverables.

The Manager will serve as a subject matter resource for rebate forecasting processes, contributing to both ongoing operational execution and broader strategic initiatives related to underwriting tools and methodologies. This role requires strong analytical capabilities, attention to detail, and the ability to operate effectively in a fast-paced, highly cross-functional environment.

• Rebate Forecasting & Model Support
• Support the execution and maintenance of rebate forecasting processes, including updates to model inputs, tables, and supporting assumptions.
• Assist with ongoing maintenance of forecasting tools, including updates to rates, modifiers, and override logic as needed.
• Contribute to coding and troubleshooting within forecasting tools (e.g., formula-based logic and model structures).

• Analysis & Reporting
• Perform ad hoc analyses and reporting to support rebate forecasting decisions, including evaluation of formulary changes, pricing strategies, and forecasting assumptions.
• Support factor analysis and investigation of changes in forecast outputs, including identification of key drivers and validation of results.
• Assist in developing materials and summaries to support leadership review and decision-making processes.

• Forecasting Process & Seasonal Support
• Support key forecasting cycles and periodic processes (e.g., bid support, annual refreshes, and assumption reviews), ensuring timelines and deliverables are met.
• Review and validate updates to forecasting assumptions, including confirmation of new or retiring strategies.

• Testing & Quality Assurance
• Participate in cross-team testing efforts, including end-to-end validation of forecasting outputs with underwriting and partner teams.
• Support quality control processes, including review of model outputs, reconciliation activities, and issue identification/tracking.

• Cross-Functional Coordination
• Partner with stakeholders across Underwriting, Trade, Pricing Strategy, and tool development teams to gather requirements, resolve issues, and ensure alignment on deliverables.
• Coordinate feedback intake and issue tracking processes, ensuring timely follow-up and resolution of identified items.
• Support communication and alignment across teams involved in rebate forecasting tool development and execution.

• Process Improvement & Documentation
• Maintain and update documentation related to rebate forecasting tools, assumptions, and processes.
• Identify opportunities to improve efficiency, reliability, and transparency of rebate forecasting processes and tools.
• Support team-level metrics, reporting, and tracking of key activities where required.

• 5+ years of experience in analytics, underwriting, actuarial, forecasting, or a related quantitative field.
• Strong proficiency in Microsoft Excel, including complex formulas and model-based analysis.
• Experience working with structured datasets and performing data validation and reconciliation across multiple inputs.
• Demonstrated ability to manage multiple priorities and operate effectively under tight timelines.
• Strong communication skills, including the ability to summarize complex analytical findings and support cross-functional discussions.

• Experience in PBM, healthcare, underwriting,…