Business Analytics Consultant
Posted 48mins ago
Employment Information
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


















