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.

Job Summary

The Manager of Business Analytics & 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 data modeling within Google Cloud Platform (GCP) through executive-ready Tableau 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 cloud-based data expertise and emerging AI capabilities to enable timely, trusted decision-making within a regulated healthcare environment.

Key Responsibilities

Analytics & Dashboard Development

• 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

Data Modeling & Cloud Analytics

• 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

AI-Enabled Analytics & Design

• 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

Automation & Insight Orchestration

• 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

Governance, Security & Compliance

• 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

Narrative & Insight Communication

• 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

Required Qualifications

• 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