Revenue Integrity Provider Insights & Reporting Manager

At CVS Health, we're building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care.As the nation's leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues - caring for people where, when and how they choose in a way that is uniquely more connected, more convenient and more compassionate. And we do it all with heart, each and every day..

Role Overview

This role is critical to building and maintaining robust data pipelines that power reporting and analytics for risk adjustment and provider performance projects. You'll work closely with analysts, reporting leads, and business stakeholders to transform raw data into trusted, scalable datasets that support market provider performance office and executive-level dashboards. Key Responsibilities

Design, build, and maintain ETL pipelines using PySpark and AWS Glue to process large volumes of structured and semi-structured data. Collaborate with reporting and insights teams to gather data requirements and ensure accurate, timely, and complete data delivery. Develop advanced SQL queries , including complex joins and Common Table Expressions (CTEs) for transformation, aggregation, and analysis. Use Git for version control, code management, and team collaboration. Design and manage scalable Datalake and warehouses on AWS using services such as S3, Redshift, Glue Catalog, and Athena. Build and optimize data solutions on DynamoDB and other NoSQL/relational databases as needed. Create interactive dashboards and visualizations in Amazon QuickSight to support data-driven decision-making. Automate workflows using AWS Step Functions, EventBridge, and Lambda to support efficient data operations. Monitor and optimize data processing performance, ensuring reliability and scalability Troubleshoot and resolve data quality or processing issues across source systems and downstream reporting . Keep up with industry best practices in cloud data engineering, security, and DevOps automation. Required Qualifications

• Hands-on experience with PySpark and/or Python
• Advanced SQL skills
• Experience with version control using Git or similar tools.
• Familiarity with key AWS services: S3, Redshift, Glue, Lambda, Step Functions, DynamoDB, Athena, QuickSight, CloudWatch, and/or CodeCommit.
• Management consulting, business process consulting and/or strategic business planning.
• Enterprise-wide and/or cross-functional large-scale initiatives with high degree of complexity.
• Demonstrated experience successfully implementing change in regulated and highly complex organizations

• 2+ years Government Programs experience including Medicare, Commercial ACA, and/or Medicaid
• Risk adjustment working knowledge and understanding
• Understanding of Databricks and its data engineering concepts.

• Strong understanding of on-premises data warehousing concepts, and AWS data lake architecture
• Exposure to big data technologies
• Experience building and supporting reporting solutions in healthcare, especially related to risk adjustment or provider attribution.
• Knowledge of DevOps or CI/CD practices for data pipeline development.
• Demonstrated ability to work effectively in cross-functional teams and manage multiple priorities in a fast-paced environment.

• Bachelor's degree in Business Administration/Management, Finance, Economics, Statistics, Mathematics, Data Science, HIM, Information Systems, Computer Science, or other relevant degree or 5 years of equivalent work experience

• Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan.
• No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching.
• Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility.