Senior Analyst - Business Analytics
About The Position
As a Senior Analyst - Business Analytics, you will be part of the Aetna Testing Center of Excellence team, delivering scalable automation solutions, advanced data analytics, and high-quality testing outcomes across healthcare benefits and claims platforms. You will collaborate with testing subject matter experts, testers, quality engineers, and reporting teams on enterprise initiatives across Medicare and Commercial lines of business. The role contributes to operational quality, turnaround times, and defect leakage prevention. It calls for technical expertise in Python, SQL, and reporting tools, along with analytical skills in testing automation, data validation, and generating actionable insights. This is a full-time position with 40 anticipated weekly hours. The typical pay range is $46,988.00–$122,400.00. The actual base salary offer depends on factors including experience, education, and geography. The position is also eligible for a CVS Health bonus, commission, or short-term incentive program. Eligible benefits include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources. The application window is anticipated to close on 11/11/2026.
Requirements
- At least 3 years of experience in testing, automation, quality assurance, data analysis, or related areas.
- Strong Python programming skills, including automation, scripting, and application development.
- Strong SQL expertise and experience analyzing and validating large datasets.
- Experience building AI-driven solutions and using AI-assisted development tools such as GitHub Copilot.
- Experience creating Power BI dashboards, reports, and visualizations.
- Strong analytical, problem-solving, and root cause analysis skills.
- Familiarity with DevOps practices, CI/CD pipelines, and version control tools.
- Strong communication, collaboration, and stakeholder management skills.
- Ability to manage multiple priorities and deliver results in a fast-paced environment.
Nice To Haves
- Experience in healthcare, provider, claims, or benefits platforms.
- Knowledge of claims data sources such as HRP and ACAS.
- Experience with PostgreSQL and other relational databases.
- Basic knowledge of QuickBase or other low-code platforms.
- Bachelor’s degree preferred, or equivalent relevant experience.
Responsibilities
- Design, develop, and support automation solutions, testing frameworks, and lightweight applications using Python.
- Create and optimize SQL queries for data analysis, validation, reporting, and defect investigation.
- Build Power BI dashboards and reports to provide insights into testing, defects, and performance metrics.
- Use AI-assisted tools to accelerate development, improve code quality, and increase productivity.
- Validate claims and benefits data against business requirements and quality standards.
- Perform root cause analysis, identify improvement opportunities, and recommend solutions.
- Collaborate with business and technical teams to streamline processes and identify automation opportunities.
- Mentor team members and communicate findings, risks, and recommendations to stakeholders and leadership.
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
