Senior Analyst, Business Analytics
About The Position
The Medicaid Enrollment Business Information Management (BIM) team is seeking a technical professional to lead the development, maintenance, and optimization of data and reporting solutions. The role involves independently building and administering databases, managing high-volume enrollment data, and performing complex data validation, extraction, transformation, and troubleshooting. It also calls for proficiency in SQL, Power BI, and Quickbase, along with knowledge of relational data structures, quality assurance, testing, audit controls, and process improvement. The position transforms complex enrollment data into accurate reports and actionable insights. The analyst investigates data-quality issues, supports testing and audit activities, strengthens controls and processes, and works with business stakeholders to translate Medicaid requirements into scalable technical solutions. The role communicates findings, risks, and recommended next steps clearly while moving technical work from analysis through resolution. The position supports a hybrid work environment. For hires in in-scope populations who live near a suitable work location, the policy may require working onsite three days a week; Aetna Service Operations office or hub locations will be discussed with the selected candidate.
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 skills.
- Ability to independently create and maintain databases.
- Experience with data management, validation, extraction, and transformation.
- Strong organizational skills.
- Experience with reporting, quality assurance, testing, audits, and process optimization.
- High school diploma or GED equivalent required.
Nice To Haves
- Bachelor's degree preferred.
- Medicaid or healthcare background.
- Working knowledge of SOX audits.
- Proficiency in Power BI and Quickbase.
- Ability to translate Medicaid business requirements into scalable technical solutions.
- Ability to create, analyze, and decipher in-depth SQL queries.
- Working knowledge of relational data for extracting and transforming data for reporting.
- Ability to interpret business requirements documents and apply them to working processes.
- 1–3 years of Medicaid Enrollment experience with data reporting and analysis.
Responsibilities
- Develop, maintain, and optimize data and reporting solutions.
- Build and maintain databases and manage high-volume enrollment data.
- Write and troubleshoot advanced SQL queries.
- Validate, extract, and transform data for reporting solutions.
- Investigate and resolve data-quality issues and risks.
- Support testing, quality assurance, and audit activities, including audit controls.
- Identify opportunities to strengthen controls and improve processes.
- Interpret Medicaid business requirements and translate them into scalable technical solutions.
- Communicate findings, risks, and recommended next steps to business stakeholders.
Benefits
- Medical coverage
- Dental coverage
- Vision coverage
- Paid time off
- Retirement savings options
- Wellness programs
- Other resources, based on eligibility
- Eligible for a CVS Health bonus, commission, or short-term incentive program
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
High school or GED
