Manager of Business Reporting & Analytics

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 of Business Analytics & AI Reporting is a senior individual contributor responsible for designing, developing, and delivering modern, AI‑enabled reporting and analytical solutions across Specialty Mail Operations. This role is designed for a versatile professional capable of independently owning the full analytics lifecycle—from SQL‑based data validation and semantic modeling through executive‑ready dashboards and AI‑assisted insight delivery.

This position plays a critical role in advancing reporting from static dashboards to continuous, automated, and well‑governed insight delivery. It combines strong analytical judgment with emerging AI capabilities to enable timely, trusted decision‑making within a regulated healthcare environment.

• Design, develop, and maintain enterprise‑grade dashboards using Power
  
  BI and Tableau
• Build and manage Power BI semantic models optimized for both human and AI consumption
• Apply DAX best practices, data modeling standards, and documentation practices
• Partner with business stakeholders to translate requirements into scalable analytics solutions
• Own SQL‑based analysis and data validation as the foundation for all reporting, semantic models, and AI‑assisted insight

• Design AI‑ready semantic models with business-friendly naming, descriptions, and classifications
• Define trusted measures, verified answers, and visibility rules to support Copilot usage
• Leverage Power BI Copilot and Copilot Studio to create AI‑assisted insights and guided analytics experiences
• Design effective prompts and conversational analytics experiences aligned to business questions
• Validate and refine AI-generated insights, understanding where outputs are reliable versus exploratory

• Build analytics automation and workflows using Power Automate
• Orchestrate AI‑enabled workflows that trigger insights, summaries, or alerts based on data changes
• Design human‑in‑the‑loop processes for AI‑assisted decision support
• Enable proactive insight delivery rather than passive dashboard consumption

• Ensure analytics solutions adhere to enterprise governance, data quality, and compliance standards
• Design reporting and AI experiences that respect row‑level security, object‑level security, and sensitivity labels
• Understand how AI inherits security context and validate outputs against regulated data constraints
• Apply responsible AI practices, including awareness of bias, hallucinations, and validation requirements

• Translate analytical and AI-generated outputs into clear business narratives
• Explain the “why” behind trends, patterns, and AI‑identified insights
• Frame insights appropriately for executive and operational audiences
• Design AI-generated summaries that align with established business language and definitions

• 3+ years of advanced Power BI expertise, including ownership of semantic models, complex DAX, and executive‑ready dashboards; sets quality standards and influences best practices
• 3+ years of strong command of SQL, independently performing analysis, validation, and issue resolution across multiple data sources with sound analytical judgment
• 5+ years of demonstrated ability to exercise analytical judgment when validating dashboards, datasets, and AI‑generated outputs—knowing when results are decision‑ready versus investigatory
• 5+ years of demonstrated depth in analytics, business intelligence, and reporting, delivering impactful dashboard solutions that support and solve complex business problems with limited guidance
• 2+ years of experience designing and delivering…