Rebate Forecast - Senior Manager

At CVS Health, we're building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care.As the nation's leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues - caring for people where, when and how they choose in a way that is uniquely more connected, more convenient and more compassionate. And we do it all with heart, each and every day.Do you have a passion for financial analysis, analytics, and problem solving? Would you like to make a significant impact in your next role? CVS Health is seeking a strategic and detail-oriented Senior Manager to join our dynamic PBM Forecasting team. In this high-impact role, you'll serve as a subject matter expert on pharmaceutical rebates, supporting forecasting efforts through tool maintenance, contract interpretation, and cross-functional collaboration.Key Responsibilities

• Serve as a subject matter expert on rebate contract interpretation, ensuring accurate and timely updates to forecasting models.
• Maintain the legacy forecasting tools using VBA, SQL, and Microsoft Excel.
• Interpret rebate contracts and update forecast model inputs accordingly.
• Ensure quality control with testing of existing tools and resources.
• Collaborate with Trade Finance, iTools, Underwriting, Data Science and PUMA support teams.
• Translate business needs into technical solutions and implement new assumptions as required.
• Consult on the development and implementation of Integrated Rebate Forecast (IRF), a new cloud-based forecasting tool to aid in the legacy tool decommission efforts.
• Communicate complex findings clearly and effectively to stakeholders.
• Provide ongoing business product support for speculative rates used in forecasts.

• 5+ years of experience in financial analysis, analytics, underwriting, or forecasting.
• 2+ years of experience using SQL to analyze and manipulate large datasets.
• 2+ years of advanced Excel modeling experience, including VBA proficiency.
• Experience with Excel formulas (e.g., INDEX/MATCH, nested IFs, array formulas, etc.).
• Experience extracting, manipulating, and analyzing large data sets to draw actionable insights.

• Experience in PBM underwriting or healthcare contracting.
• Strong presentation and communication skills.
• Ability to manage multiple priorities and meet tight deadlines.

• Bachelor's degree in Finance, Economics, Data Analytics, Business Administration, or a related field.

• 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.