Top 11
Company roadmap
Updated weekly · Last refresh Aug 30

They Interview Questions

The questions to prepare for They interviews, across all roles. Questions from real interview reports rank first. Updated weekly.

11questions
~1htotal time
Track your progressSign up free to work through all 11 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Handling Missing and Dirty SQL DataMedium

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

Data WranglingCase WhenQualityThey
Data Quality for Pricing DecisionsMedium

Tests your approach to data quality checks and suitability for underwriting and pricing decisions at They.

data accuracyThey
Dashboard for Marketing Campaign SuccessMedium

Tests your ability to define metrics, design dashboards, and make results actionable for marketing at They.

marketing analyticsdata visualizationdashboard designThey
Automating Manual ReportingMedium

Tests your ability to streamline reporting workflows through automation and reliable data pipelines at They.

efficiencyAutomationreportingThey
Diagnosing Portfolio UnderperformanceMedium

Tests your ability to analyze performance drivers and segment-level issues in complex portfolios at They.

performance metricsThey
Solving a Non-Trivial Data ProblemMedium

Tests your practical problem-solving process using SQL or Python for real data challenges at They.

Problem SolvingsqlpythonThey
Normalize Messy CRM Contact DataHard
Practice
Practice drill

Clean inconsistent CRM contacts by joining source tables, standardizing values, and flagging bad records.

Data WranglingCase WhenQualityAlphaSense
Validate Monthly Revenue Data QualityHard
Practice
Practice drill

Use joins, a CTE, and CASE logic to flag messy monthly order data and produce cleaned revenue by month.

Data WranglingCase WhenQualityLiterati
Profile Incomplete Customer RecordsEasy
Practice
Practice drill

Classify Best Buy customer records as Complete, Incomplete, or Inconsistent using CASE and null/blank checks.

Data WranglingCase WhenQualityBest Buy
2
Behavioral & Leadership4 questions · ~32 min
Explaining Technical Issues ClearlyMedium

Tests whether you can translate technical complexity into business-relevant language for non-technical stakeholders and drive action.

Stakeholder ManagementCommunicationtechnical explanationThey
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
The finish line: interview-readyComplete all 11 questions plus 3 hands-on drills to finish this plan.