Manager of Business Reporting & Analytics

Role Description

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.

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

Qualifications

• Advanced Tableau expertise, including design of executive-ready dashboards, performance optimization, and scalable visualization design (5+ years)
• Strong experience working with Google Cloud Platform (GCP), particularly BigQuery, for large-scale data analysis and querying (3+ years)
• Strong command of SQL, independently performing analysis, validation, and issue resolution across multiple data sources (3+ years)
• Demonstrated ability to exercise analytical judgment when validating dashboards, datasets, and AI-generated outputs—knowing when results are decision-ready versus investigatory (2+ years)

Preferred Qualifications

• 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

Education

• Bachelor’s degree in data analytics, computer science or equivalent experience required

Anticipated Weekly Hours

• 40

Time Type

• Full time

Pay Range

The typical pay range for this role is: $60,300.00 - $132,600.00. This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above.

Benefits

• Comprehensive benefits package designed to support the physical, emotional, and financial well-being of colleagues and their families
• Medical, dental, and vision coverage
• Paid time off
• Retirement savings options
• Wellness programs and other resources, based on eligibility