Top 32
Prep plan
Updated weekly · Last refresh Aug 30

Okx Data Analyst Interview Questions

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

32questions
~4htotal time
Track your progressSign up free to work through all 32 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 2 drills · ~54 min
7-Day Rolling Active UsersMedium
Practice

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsOkx
Optimizing Large Transaction Table JoinsHard

Explain how to tune a slow PostgreSQL query that joins several large transaction tables using indexes, join strategy, and partitioning.

JoinsperformancesqlOkx
Clean Missing Values in PandasMedium

Tests data cleaning choices and metric integrity when handling missing transaction values.

null handlingData Wranglingdata integrityOkx
SQL for Top Trading UsersMedium
Practice
Practice drill

Use aggregation and NTILE to identify the top 10% of OKX users by 30-day trading volume.

sql queryData AnalysisOkx
Weekly Service KPI by TeamMedium
Practice
Practice drill

Analyze weekly service delivery performance by team using joins, a CTE, date aggregation, and KPI calculations.

KPIJoinssqlDeloitteReputation
More SQL & Data Manipulation questions with a free account
2
Metrics3 questions · ~25 min
Investigate Mobile Trading Volume DropMedium

Tests root-cause analysis using metrics, instrumentation, and experiment-ready thinking.

Funnel AnalysisKPIDiagnosisOkx
Measure Success of Staking ProductMedium

Tests product metric design for crypto features and how you define success end to end.

North Star MetricKPIActivationOkx
Learning From AnalysesMedium

Evaluates how you extract insights from analysis and iterate on your work.

learningAnalysisOkx

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 & Leadership23 questions · ~193 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~17 min
Segment Dormant Traders for ROIMedium

Tests segmentation strategy and ROI-focused measurement for OKX user growth initiatives.

User Segmentsroicampaign performanceOkx
Turn Vague Goals Into KPIsMedium

Tests ability to convert ambiguous product goals into measurable analytics and KPIs.

MetricsUser NeedsrequirementsOkx
The finish line: interview-readyComplete all 32 questions plus 2 hands-on drills to finish this plan.