Top 33
Prep plan
Updated weekly · Last refresh Aug 30
T

ThoughtWorks Data Analyst Interview Questions

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

33questions
~4htotal time
Track your progressSign up free to work through all 33 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 4 questions · ~32 min
Define Success for a New FeatureEasy

Define the right metrics to judge whether a new product feature is successful.

KPIsConversion RateLeading IndicatorsTThoughtWorks
Define Success Metrics for FeaturesMedium

Set a clear north star, supporting KPIs, leading indicators, and guardrails for a new product feature.

North Star MetricLagging IndicatorsKPIsTThoughtWorks
Prioritizing Competing Stakeholder RequestsMedium

Assesses prioritization and stakeholder management under pressure.

Stakeholder Managementtime managementTThoughtWorks
More Metrics questions with a free account
2
SQL & Data Manipulation8 questions + 3 drills · ~94 min
Optimizing Slow PostgreSQL Research QueriesMedium

Explain how you diagnosed and optimized a slow PostgreSQL query using execution plans, indexing, and query rewrites.

JoinsData WranglingAggregationsTThoughtWorks
Handling Missing and Dirty SQL DataMedium

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

Data WranglingCase WhenQualityTThoughtWorks
From Raw Data to RecommendationMedium

Evaluates your ability to transform data into business decisions.

Data AnalysisTThoughtWorks
Choosing Visualization ToolsEasy

Assesses your tool selection and ability to justify visualization choices.

Toolsdata visualizationdata storytellingTThoughtWorks
Rolling 7-Day Average with Window FunctionsMedium
Practice
Recently asked
Practice drill

Calculate patient rolling 7-day averages and rank patients within each Medpace research site using layered window functions.

Window FunctionsRankingRunning TotalsTThoughtWorksMedpaceHealth Care Solutions At Home
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
Autonomous vs Manual Drive TimeHard
Practice
Practice drill

Compute per-vehicle daily autonomous vs manual seconds from state-change logs using LEAD and conditional aggregation.

JoinsData WranglingGroup By
More SQL & Data Manipulation 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
Behavioral & Leadership21 questions · ~168 min
Resolving Team Disagreement on ApproachEasy

Tests conflict resolution in a delivery context, including communication, influence without authority, and ability to preserve team trust while reaching a decision.

Influence Without AuthorityConflict ResolutionCommunicationTThoughtWorks
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 33 questions plus 3 hands-on drills to finish this plan.