Business Analytics Consultant

CVS Health•Washington, DC

1d•$54,300 - $159,120•Remote

About The Position

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. Position Summary This role in the Informatics team within Aetna’s Medicaid Business Unit (MBU) delivers analytics, reporting, and insights that support the growing P4P Quality Incentive Portfolio and related strategic initiatives. In this individual contributor role, you will partner with cross-functional stakeholders to translate evolving business questions into governed datasets, repeatable analytic methods, and clear, actionable insights across 10+ Medicaid markets. You will execute complex data queries, integrate and validate healthcare data from multiple sources, and assess health and economic outcomes to inform decisions. What success looks like Publish trusted KPI dashboards and recurring reports used by Quality, Finance, and Market & Organizational leadership for performance management and incentive forecasting Produce reproducible, well-documented analyses (logic, assumptions, methodology) that stand up to stakeholder review and audit needs Turn ambiguous questions into clear requirements, appropriate analytic approaches, and actionable recommendations Deliver high-quality work in fast-moving environments. This role supports a portfolio of enterprise and market-facing analytics products that drive performance management, incentive forecasting, and strategic decision support across Medicaid markets. Examples include: P4P & Quality Incentive Dashboard: Dashboards for quality incentive tracking, P4P projections, and enterprise-wide performance visibility Medicaid Optimizer Dashboard: Market-level modeling and reporting (e.g., dollar-per-compliant-member estimates) to support prioritization and investment decisions Off-Cycle CAHPS Survey Dashboard: a centralized view of member experience insights collected between annual CAHPS fielding periods, enabling health plans to proactively monitor performance and respond faster to emerging issues. Engagement & Campaign Performance Dashboard: Performance tracking to support cross-functional outreach initiatives Ad hoc Strategic Analysis: Rapid-turn analysis for P4P scenarios, ROI projections, and executive decision support

Requirements

3+ years of data analytics experience (healthcare/Medicaid preferred)
3+ years of experience with healthcare data (e.g., enrollment, claims, HEDIS) in a data warehouse environment; GCP/BigQuery preferred
3+ years using advanced SQL to query and manipulate large datasets in a relational database environment, including integrating multiple data sources
3+ years creating dashboards and data visualizations that drive decisions (Tableau preferred)
3+ years creating reports and pivot tables in Excel
Ability to interpret technical specifications and communicate technical concepts to non-technical audiences (written and verbal)
Strong problem-solving and critical-thinking skills; adept at probing into granular details of big data and complex technical processes
Strong collaboration and communication skills across teams; organized, attentive to detail, able to manage conflicting priorities, work independently under general direction, and meet commitments

Nice To Haves

Healthcare quality measure familiarity (e.g., HEDIS, CAHPS, P4P/quality incentive programs) preferred

Responsibilities

Write robust, efficient code in SQL/GCP to extract, manipulate, and analyze large healthcare datasets across diverse data pipelines
Design, deploy, and maintain data visualizations and dashboards to calculate vital KPIs (P4P dollar projections, quality incentive tracking, ROI analysis) and recommend actionable insights for leaders
Work closely with executive leadership and health plan leaders to provide project updates, flag barriers, build advanced trend and ad hoc reports, and deliver robust insights
Develop and participate in presentations and consultations with health plan leaders on data capabilities, methodologies, and performance results
Document data logic and plan methodology used in analyses; ensure reproducibility and transparency of results
Understand Medicaid business operations and state plan methodologies to enable smooth partnership with business leaders across 10+ markets.
Partner with Finance, Healthcare Quality, IT, BIS, Medical Affairs, and Market & Organizational leadership on data integration and quality initiatives.