Senior Analyst, Business Analytics

About the role

We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time.

The Medicaid Enrollment Business Information Management (BIM) team is seeking a highly skilled technical professional to lead the development, maintenance, and optimization of data and reporting solutions. The successful candidate will bring intermediate to advanced SQL expertise and the demonstrated ability to independently build and administer databases, manage high-volume enrollment data, and perform complex data validation, extraction, transformation, and troubleshooting. Strong proficiency in Power BI and Quickbase is preferred, supported by a solid command of relational data structures, quality assurance, testing, audit controls, and process improvement. This role demands a solutions-oriented professional who can convert complex Medicaid business requirements into scalable, accurate, and sustainable technical solutions; proactively identify and resolve data-quality risks; and deliver clear, actionable insights to business stakeholders.

Responsibilities

• Write and troubleshoot advanced SQL queries
• Build and maintain databases
• Validate high-volume enrollment data
• Extract and transform information for reporting solutions
• Investigate data-quality issues
• Support testing and audit activities
• Identify opportunities to strengthen controls and improve processes
• Partner with business stakeholders to interpret Medicaid requirements and translate them into scalable technical solutions
• Clearly communicate findings, risks, and recommended next steps

Requirements

• 1–3 years of data interpretation and analysis experience
• Excellent verbal and written communication skills
• Working knowledge of Microsoft Office products (Word, Excel, PowerPoint, Outlook) and Internet Explorer
• Intermediate to advanced SQL analysis and troubleshooting
• Independent database creation and maintenance
• Data management, validation, extraction, and transformation
• Strong organizational skills
• Reporting, quality assurance, testing, audits, and process optimization

Preferred qualifications

• Medicaid / healthcare background
• Working knowledge of SOX audits
• Power BI and Quickbase proficiency
• Translating Medicaid business requirements into scalable technical solutions
• Ability to create, analyze, and decipher in-depth SQL queries
• Working knowledge of relational data as it relates to extracting and transforming for reporting purposes
• Ability to interpret business requirements documents and how they apply to working processes
• 1–3 years of Medicaid enrollment experience with data reporting and analysis

Education

• Bachelor's degree preferred
• High School Diploma or GED equivalent required

Schedule

Hybrid work environment — if selected and you live near a suitable work location, you may be expected to comply with the hybrid work policy (onsite three days a week). Aetna Service Operations office/hub locations will be discussed with the selected candidate. Anticipated weekly hours: 40. Time type: Full time.

Pay

The typical pay range for this role is $46,988.00 – $102,000.00 annually (base full-time salary). The actual base salary offer will depend on experience, education, geography, and other relevant factors. This position is eligible for a CVS Health bonus, commission, or short-term incentive program in addition to the base pay range.

Benefits

This full-time position is eligible for a comprehensive benefits package designed to support the physical, emotional, and financial well-being of colleagues and their families. Benefits include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources based on eligibility.