Business Analytics Consultant

Posted 48mins ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Business Analytics Consultant delivering SQL/GCP analytics, dashboards, and insights for CVS Health’s Medicaid quality incentive programs. Supporting performance management across 10+ markets.

Responsibilities:

  • Deliver analytics, reporting, and insights supporting the P4P Quality Incentive Portfolio and strategic initiatives within Aetna’s Medicaid Business Unit
  • Partner with cross-functional stakeholders across 10+ Medicaid markets to translate business questions into governed datasets, repeatable analytic methods, and actionable insights
  • Execute complex data queries, integrate and validate healthcare data from multiple sources, and assess health and economic outcomes
  • Publish KPI dashboards and recurring reports for Quality, Finance, and Market & Organizational leadership
  • Produce reproducible, well-documented analyses that support stakeholder review and audit needs
  • Turn ambiguous questions into clear requirements, analytic approaches, and recommendations
  • Write robust, efficient SQL/GCP code to extract, manipulate, and analyze large healthcare datasets
  • Design, deploy, and maintain data visualizations and dashboards for KPI calculations, projections, quality incentive tracking, and ROI analysis
  • Work with executive leadership and health plan leaders to provide updates, flag barriers, build trend and ad hoc reports, and deliver insights
  • Develop and participate in presentations and consultations with health plan leaders
  • Document data logic and plan methodology to ensure reproducibility and transparency
  • Understand Medicaid operations and state plan methodologies
  • Collaborate 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+ years of experience with healthcare data, such as enrollment, claims, or 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
  • Familiarity with healthcare quality measures such as HEDIS, CAHPS, and 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
  • Strong collaboration and communication skills across teams
  • Organized and attentive to detail
  • Ability to manage conflicting priorities, work independently under general direction, and meet commitments
  • Bachelor’s degree accepted; Master’s degree in a related field preferred

Benefits:

  • Medical coverage
  • Dental coverage
  • Vision coverage
  • Paid time off
  • Retirement savings options
  • Wellness programs
  • Other resources supporting physical, emotional, and financial well-being
  • CVS Health bonus, commission or short-term incentive program in addition to base pay