Manager of Business Reporting & Analytics

CVS Health is dedicated to building a more connected and compassionate health experience. They are seeking a Manager of Business Reporting & Analytics to design, develop, and deliver AI-enabled reporting and analytical solutions, playing a critical role in advancing reporting capabilities within the healthcare sector.

Responsibilities:

• Design, develop, and maintain enterprise-grade dashboards using Tableau
• Develop and optimize BigQuery-based datasets and views to support scalable analytics and reporting
• Apply best practices in data modeling, query optimization, and dashboard performance tuning
• Partner with business stakeholders to translate requirements into scalable analytics solutions
• Own SQL-based analysis and data validation within BigQuery and GCP environments as the foundation for all reporting and insight delivery
• Design and manage analytics-ready data structures in BigQuery, optimized for downstream Tableau consumption
• Define and standardize business logic, KPIs, and metric definitions within the data layer
• Partner closely with data engineering teams to influence upstream ETL design and ensure alignment to reporting needs
• Ensure efficient use of GCP resources through optimized query design and data partitioning strategies
• Enable AI-ready data structures and datasets with clear naming conventions, metadata, and business-friendly definitions
• Support development of AI-assisted insight generation using modern tools and platforms (e.g., generative AI, conversational analytics)
• Design and validate AI-generated insights, ensuring outputs are accurate, explainable, and aligned with business context
• Guide the integration of AI capabilities into dashboards and reporting workflows, focusing on practical business use cases
• Build analytics automation using GCP-native tools and SQL-based workflows
• Enable proactive insight delivery through automated queries, alerts, and scheduled reporting pipelines
• Design processes that support AI-assisted decision-making with human validation
• Reduce manual reporting and enable scalable, repeatable analytics solutions
• Ensure analytics solutions adhere to enterprise governance, data quality, and compliance standards
• Design reporting solutions that align with data access controls and security models within GCP
• Validate outputs against regulated data constraints, particularly within healthcare/PBM environments
• Apply responsible AI practices, including awareness of bias, hallucination risk, and validation requirements
• Translate analytical and AI-generated outputs into clear business narratives
• Explain the 'why' behind trends, patterns, and data insights
• Frame insights appropriately for executive and operational audiences
• Ensure consistency between reported metrics, dashboards, and business definitions

Requirements:

• 5+ years of advanced Tableau expertise, including design of executive-ready dashboards, performance optimization, and scalable visualization design
• 3+ years of strong experience working with Google Cloud Platform (GCP), particularly BigQuery, for large-scale data analysis and querying
• 3+ years of strong command of SQL, independently performing analysis, validation, and issue resolution across multiple data sources
• 3+ years of demonstrated ability to exercise analytical judgment when validating dashboards, datasets, and AI-generated outputs—knowing when results are decision-ready versus investigatory
• Bachelor's degree in data analytics, computer science or equivalent experience required
• Advanced Power BI expertise, including ownership of semantic models, complex DAX, and executive‑ready dashboards; sets quality standards and influences best practices
• Experience applying AI-enabled reporting capabilities (e.g., generative AI, conversational analytics, or AI-assisted insights) in production environments
• Experience in healthcare, PBM, or other regulated data environments
• Understanding of business process improvement, project management, and quality practices
• Experience designing scalable, governed reporting environments with strong emphasis on data standardization and 'single source of truth' principles