Senior Analyst - Business Analytics

4062 Aetna Resources, LLC; New York (NY); Hybrid; USD 47,000 - 122,000; Full time

Job summary

CVS Health is seeking a Senior Analyst - Business Analytics to join the Aetna Testing Center of Excellence. You will drive automation, data validation, and insightful reporting across Medicare and Commercial platforms.

The role emphasizes Python, SQL, and Power BI, with opportunities to mentor teammates and influence testing processes. It is a full-time on-site position in New York, offering a comprehensive benefits package and a base salary range aligned with market norms.

Qualifications

• 3+ years of experience in testing, automation, QA, data analysis, or related areas.
• Strong Python programming skills for automation, scripting, and app development.
• Strong SQL expertise for analyzing and validating large datasets.
• Experience building AI-driven solutions and using AI-assisted tools like GitHub Copilot.
• Experience creating Power BI dashboards, reports, and visualizations.
• Excellent analytical, problem-solving, and root-cause analysis skills.
• Familiarity with DevOps, CI/CD pipelines, and version control tools.

Responsibilities

• Design, develop, and support automation solutions and testing frameworks 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.
• Utilize AI-assisted development tools to improve code quality and productivity.
• Validate claims and benefits data to ensure business requirements and quality standards.
• Perform root cause analysis and recommend improvements.

Skills

Python

SQL

Power BI

AI-assisted tools

Testing automation

Data analysis

DevOps/CI/CD

Education

Bachelor’s degree preferred

Tools

PostgreSQL

GitHub Copilot

QuickBase

Job description

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.

Position Summary

As a Senior Analyst - Business Analytics you will be part of a highly skilled team within the Aetna Testing Center of Excellence (TCOE) team focused on delivering scalable automation solutions, advanced data analytics, and high-quality testing outcomes across healthcare benefits and claims platforms. As part of this role, you will collaborate closely with Testing Subject Matter Expertise, Testers, Quality Engineers, and Reporting teams, supporting enterprise initiatives across Medicare and Commercial lines of business. Your work will directly impact operational quality, turnaround times, and defect leakage prevention. The ideal candidate combines strong technical expertise in Python, SQL, and reporting tools with deep analytical skills to drive testing automation, data validation, and actionable insights.

Key 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 to ensure business requirements and quality standards are met.
• 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.

Required Qualifications

• 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 with 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.

Preferred Qualifications

• 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.

Education

Bachelor’s degree preferred (or equivalent relevant experience).

Anticipated Weekly Hours

40

Time Type

Full time

Pay Range

Pay Range The typical pay range for this role is: $46,988.00 - $122,400.00. 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.

Great benefits for great people

We take pride in offering a comprehensive and competitive mix of pay and benefits that reflects our commitment to our colleagues and their families. 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. The benefits for this position include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources, based on eligibility. Additional details about available benefits are provided during the application process and on Benefits Moments.

We anticipate the application window for this opening will close on: 10/07/2026.

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.

Our Work Experience

Our Work Experience is the combination of everything that's unique about us: our culture, our core values, our company meetings, our commitment to sustainability, our recognition programs, but most importantly, it's our people. Our employees are self-disciplined, hard working, curious, trustworthy, humble, and truthful. They make choices according to what is best for the team, they live for opportunities to collaborate and make a difference, and they make us the #1 Top Workplace in the area.