Senior Analyst, Business Analytics

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.

As a member of the Medicaid Enrollment Business Information Management team, you will spend your day transforming complex enrollment data into accurate reporting and actionable insights. You will write and troubleshoot advanced SQL queries, build and maintain databases, validate high-volume data, and extract or transform information for reporting solutions. You will investigate data-quality issues, support testing and audit activities, and identify opportunities to strengthen controls and improve processes. In partnership with business stakeholders, you will interpret Medicaid requirements, translate them into scalable technical solutions, and clearly communicate findings, risks, and recommended next steps. This role is ideal for an organized, solutions-focused professional who can independently move technical work from analysis through resolution while balancing accuracy, quality, and business needs.

• 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
• 1-3 years of data interpretation and analysis experience
• Reporting, quality assurance, testing, audits, and process optimization

• Medicaid / Healthcare background preferred
• 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

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

We support a hybrid work environment. If selected and you live near a suitable work location, you may be expected to comply with the hybrid work policy. Under the policy, all hires for in-scope populations should be placed into a hybrid or office-based location, working onsite three days a week. Aetna Service Operations office/hub locations will be discussed with the selected candidate.

The typical pay range for this role is:

This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls.  The actual base salary offer will depend on a variety of factors including 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 listed above. 
 

Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong.