QA & Test Senior Analyst - ETL at Cigna

Role Summary:


Reporting to the QA Manager, the QA & Testing Senior Analyst is responsible for the timely planning, execution, and reporting of Quality Assurance testing activities for new and enhanced data and analytics solutions. This role focuses on ensuring data quality, reliability, and fitness for purpose across ETL pipelines, databases, and downstream analytics platforms. The role partners closely with Scrum teams, product owners, data engineers, and business stakeholders to embed quality-first principles throughout the delivery lifecycle, primarily within a SAFe Agile environment.


Key Responsibilities:


Own and deliver QA targets for assigned projects, ensuring quality outcomes are met
Develop deep product and data understanding and create effective test designs
Execute test cases and log, track, and manage defects
Define test priorities and create efficient execution plans
Participate in defect triage sessions and root cause analysis
Actively participate in PI planning, sprint planning, and Agile ceremonies
Track and report test progress against agreed plans
Contribute to sprint retrospectives and continuous improvement initiatives
Apply appropriate test techniques, methodologies, and tools to maximise test coverage
Mentor and support junior QA team members
Adhere to Quality Engineering best practices and actively drive efficiency improvements


Required Skills and Experience:


Bachelor's degree in Computer Science or related discipline, or equivalent experience
5 - 8 years' experience in Software QA with strong focus on ETL and data testing
Proven experience validating ETL extraction, transformation, and load processes
Strong SQL skills, including stored procedures and backend testing
Experience testing across multiple database types
Hands-on experience with ETL testing tools
Test automation experience using code, preferably Python
Strong understanding of the full test lifecycle
Experience using Microsoft SQL Server tools
Knowledge of healthcare insurance industry
Strong understanding of SDLC and Agile delivery models
Experience with automated testing and modelling tools
Strong change management and test design skills
Quality metrics, dashboards, and release readiness reporting
Excellent written and verbal communication skills
Strong analytical and problem-solving skills
Ability to work independently or lead within a team
High attention to detail and accuracy
Commitment to continuous personal development


Desirable Skills and Experience:


ISTQB Foundation or Intermediate certification
Database and API testing experience
Cloud Platforms: Hands-on testing experience in (AWS / Microsoft Azure)
Ownership of data quality strategy and test approach across analytics platforms
Test automation using Python
ETL tools such as SSIS
Relational database expertise using SQL (or PostgreSQL, DBeaver)
Web technologies (Java, HTML)
Salesforce and Vlocity experience
Selenium or UFT experience