Medicaid Analytics & Insights Consultant

CVS Health; Kentucky; Hybrid; USD 54,000 - 159,000; Full time

Benefits offered by this job

Comprehensive benefits package

Medical, dental, and vision coverage

Paid time off

Retirement savings options

Wellness programs

Job summary

CVS Health in Kentucky is seeking a data analytics professional to join the Informatics team within Aetna’s Medicaid Business Unit. You will translate business questions into governed datasets, run queries in SQL/GCP, and deliver actionable insights across 10 Medicaid markets.

You will publish KPI dashboards, support incentive forecasting, collaborate with senior leaders, and ensure documentation and governance of data logic.

Qualifications

• 3 years of data analytics experience (healthcare/Medicaid preferred)
• 3 years healthcare data experience 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
• Healthcare quality measure familiarity (e.g., HEDIS, CAHPS, P4P/quality incentive programs) preferred
• 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

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

Skills

SQL

BigQuery

Tableau

Excel

Data Visualization

Data Pipelines

Healthcare Analytics

Education

Masters preferred

Bachelor's acceptable

Tools

GCP/BigQuery

Tableau

Excel

Job description

CVS Health in Kentucky is seeking a data analytics professional to join the Informatics team within Aetna’s Medicaid Business Unit. You will translate business questions into governed datasets, run queries in SQL/GCP, and deliver actionable insights across 10 Medicaid markets.

You will publish KPI dashboards, support incentive forecasting, collaborate with senior leaders, and ensure documentation and governance of data logic.