Top 35
Prep plan
Updated weekly · Last refresh Oct 17

The Cigna Group Data Analyst Interview Questions

The questions to prepare for a The Cigna Group Data Analyst interview. Questions from real interview reports rank first. Updated daily.

35questions
~5htotal time
Track your progressSign up free to work through all 35 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 15 questions + 2 drills · ~145 min
Window Ranking in Ticket QueuesMedium

Explain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.

Window FunctionsRankingrow_numberThe Cigna Group
Optimize SQL Query PerformanceHard
Practice

Optimize a PostgreSQL reporting query by reducing intermediate rows, using appropriate joins, and calculating monthly performance efficiently.

database optimizationdatabase managementindexesThe Cigna Group
Database and Reporting InfrastructureMedium

Assesses your understanding of the systems that support analytics and reporting.

database managementtechnical knowledgeThe Cigna Group
Handling Missing DataMedium
Practice
Practice drill

Standardize missing observation fields with fallback values, missingness flags, and ordered output.

Window Functionsmissing valuesdata cleaningEversource EnergyCincinnati Children's HospitalAdtalem Global Education
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
More SQL & Data Manipulation questions with a free account
2
Pipelines6 questions · ~50 min
Cloud Platform Experience for PipelinesMedium

Describe practical experience building pipelines on AWS, including orchestration, security, and data quality.

InfrastructureETLData ModelingThe Cigna Group
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityThe Cigna Group
Handling ETL ProcessesMedium

Tests your understanding of ETL design, transformations, and data pipeline reliability.

ETLELTData ModelingThe Cigna Group
More Pipelines questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Metrics5 questions · ~42 min
Analyzing Claims and Pharmacy DataMedium

Tests your approach to multi-domain healthcare analytics across claims and engagement signals.

KPIsLeading IndicatorsDiagnosisThe Cigna Group
Tableau Dashboard ImpactMedium

Tests your dashboard storytelling and ability to connect insights to business decisions.

KPIsLeading IndicatorsDiagnosisThe Cigna Group
More Metrics questions with a free account
4
Behavioral & Leadership9 questions · ~75 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 35 questions plus 2 hands-on drills to finish this plan.