Business Analytics Consultant

CVS Health is a healthcare company focused on creating a more connected, convenient, and compassionate health experience. The Business Analytics Consultant will deliver analytics, reporting, dashboards, and insights for Aetna’s Medicaid business, supporting quality incentives, performance management, forecasting, and strategic decision-making across Medicaid markets. The role involves analyzing healthcare data, collaborating with cross-functional and executive stakeholders, and documenting governed, reproducible methodologies.

Responsibilities:

• Data Engineering & Analysis: Write robust, efficient code in SQL/GCP to extract, manipulate, and analyze large healthcare datasets across diverse data pipelines
• Dashboard Development & Data Visualization: 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
• Strategic Partnership: 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
• Stakeholder Consultation: Develop and participate in presentations and consultations with health plan leaders on data capabilities, methodologies, and performance results
• Documentation & Governance: Document data logic and plan methodology used in analyses; ensure reproducibility and transparency of results
• Business Acumen: Understand Medicaid business operations and state plan methodologies to enable smooth partnership with business leaders across 10+ markets
• Cross-Functional Collaboration: Partner with Finance, Healthcare Quality, IT, BIS, Medical Affairs, and Market & Organizational leadership on data integration and quality initiatives

Requirements:

• 3+ years of data analytics experience (healthcare/Medicaid preferred)
• 3+ yearsof experience with healthcare data (e.g., enrollment, claims, HEDIS) in a data warehouse environment; GCP/BigQuery preferred
• 3+ yearsusing advanced SQL to query and manipulate large datasets in a relational database environment, including integrating multiple data sources
• 3+ yearscreating dashboards and data visualizations that drive decisions (Tableau preferred)
• 3+ yearscreating 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
• Bachelors ok
• Healthcare quality measure familiarity (e.g., HEDIS, CAHPS, P4P/quality incentive programs) preferred
• Masters in related field preferred