Senior Analyst, FP&A (Financial Planning & Analysis)

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.Position Summary

The Senior Analyst, FP&A plays a pivotal role in transforming how data drives strategic decisions across ABHIL. This role blends technical acumen with business curiosity and thrives on improving processes, automating reporting, and translating insights into action. You will collaborate cross-functionally with Finance, Operations, Compliance, Medical Management, Vendor Management, and other internal and external partners to support strategic initiatives and meet regulatory reporting requirements.

You will be responsible for developing both recurring and ad-hoc analyses that empower executive leadership with the insights needed to make critical decisions. Your work will span financial impact assessments, ROI analyses, regulatory reporting for the State of Illinois, and strategic business opportunity tracking. You'll also contribute to the development of dashboards, predictive models, and performance metrics that support ABHIL's Medicaid goals and cost-of-care initiativesJob description

The Senior Analyst, FP&A is a strategic partner in transforming how data powers decisions across ABHIL.

This role blends technical skill, business understanding, and creative problem-solving to deliver insights that matter. You'll lead efforts in connecting data across systems, building dashboards, identifying trends, and telling compelling stories that drive action.

You'll collaborate cross-functionally with Finance, Operations, Compliance, Medical Management, Vendor Management, and other internal and external stakeholders to support strategic initiatives and meet regulatory reporting requirements. Your work will help executive leadership make informed decisions, track strategic opportunities, and ensure compliance with State of Illinois Medicaid regulations.Key Responsibilities:

• Analyze data trends and performance drivers to uncover actionable insights that support strategic and regulatory initiatives.
• Design, develop, and maintain executive-level dashboards and reporting solutions using SQL, Power BI, Tableau, and Excel.
• Automate recurring reports and enable self-service analytics to improve efficiency and accessibility.
• Conduct ROI and financial impact analyses for new programs, pilots, and operational changes.
• Prepare monthly FP&A reports for ABHIL CEO, Central Division CEO, and Medicaid CEO.
• Support State of Illinois regulatory reporting (monthly, quarterly, semi-annual) and ensure compliance with Medicaid requirements.
• Lead Scorable Action Items (SAIs) sizing, validation, reporting, and tracking to drive performance improvement.
• Translate ambiguous business needs into clear reporting specifications and deliverables.
• Validate data integrity and ensure quality across all outputs, including ad hoc analyses for executive decision-making.
• Monitor vendor performance and support related reporting and analytics needs.
• Engage in data audits, workflow validations, and resolution of data quality issues.
• Champion innovation through AI, predictive analytics, and automation platforms (e.g., Nadia, Artey).
• Escalate issues proactively and collaborate across teams to mitigate risks and ensure timely delivery.
• Support change management efforts and promote a culture of continuous improvement and data-driven decision-making.

• Advanced SQL skills and the ability to connect data across multiple sources
• Experience building interactive dashboards and visuals using Power BI, Tableau, or equivalent tools.
• Strong analytical thinking with the ability to extract insights from complex datasets.
• A strong grasp of healthcare or financial metrics and what drives cost
• Ability to validate, QA, and audit data for accuracy and consistency
• Experience supporting or enabling self-service analytics solutions
• Adaptability and learning agility in fast-paced environments
• Strong critical thinking and problem-solving skills
• Clear communication skills with the ability to present to both technical and non-technical audiences.
• Strong organizational and time management skills with attention to detail.
• Self-motivation, initiative, and accountability from concept to delivery.
• Collaboration mindset and experience working cross-functionally with business and technical teams.
• Experience or strong Interest in AI, automation, and predictive analytics technologies.

• 4+ years of experience in reporting, analytics, or automation roles, including financial reporting.
• 4+ years of experience in financial acumen and data analytics work.
• 4+ years experience working with SQL, Power BI and Excel.
• Strong knowledge of SQL and motivation to continue to use various solutions.

• Experience in health insurance, managed care, or the pharmaceutical industry.
• Project management experience or equivalent work experience.
• Knowledge and Experience using Healthcare datasets, healthcare analysis, and/or health economics

• Bachelor's degree or equivalent work experience.

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