Top 12
Prep plan
Updated weekly · Last refresh Nov 6
C

CorGTA Data Analyst Interview Questions

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

12questions
~2htotal time
Track your progressSign up free to work through all 12 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 1 drill · ~40 min
Retention Rate SQL With JoinsMedium
Practice

Calculate consecutive-month customer retention rates using joins, aggregation, and date-based CTEs.

aggregationsql queryCCorGTA
Handling Missing and Dirty SQL DataMedium

Explain how to profile, clean, and standardize missing or dirty data before analysis.

Data WranglingCase WhenQualityCCorGTA
Optimizing a Poor SQL QueryHard
Practice

Rewrite a slow policy-performance query to reduce repeated work while preserving broker-level results.

database optimizationindexescomplex queriesCCorGTA
Optimize Dashboard Query PerformanceMedium
Practice
Practice drill

Diagnose and optimize a slow TaskRabbit dashboard query using execution plans, indexing, filtering, and pre-aggregation.

database optimizationJoinsData WranglingIInfo OriginCohere TechnologyTaskRabbit
2
Behavioral & Leadership6 questions · ~60 min
Resolving a Critical Data AnomalyMedium

Tests ownership of data quality issues, root-cause analysis, and clear stakeholder communication under pressure.

Problem SolvingOwnershipdata anomalyCCorGTA
Presenting Recommendations to Senior StakeholdersMedium

Tests executive communication, stakeholder management, and influence through a data-backed recommendation under scrutiny.

Stakeholder ManagementCommunicationpresentationCCorGTA
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~30 min
Investigating a Sudden Metric DropMedium

Evaluates your troubleshooting approach for sudden metric changes and root-cause analysis.

business impactCCorGTA
Building a Dashboard From Ambiguous RequirementsMedium

Evaluates how you clarify requirements and deliver a usable dashboard.

data visualizationdashboard designCCorGTA
Choosing the Right VisualizationMedium

Assesses your ability to select effective visualizations for different analytical goals.

data visualizationCCorGTA

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 12 questions plus 1 hands-on drill to finish this plan.