ByteDance/Tiktok Data Scientist Interview Questions
The questions to prepare for a ByteDance/Tiktok Data Scientist interview. Questions from real interview reports rank first. Updated daily.
Use layered CTEs to calculate user activity metrics and assign engagement segments with quartile-based scoring.
Calculate a three-day moving average of active-client revenue using aggregation and SQL window functions.
Explain how to handle NULLs in SQL-backed visualizations without misrepresenting counts, averages, or trends.
Calculate stage-level checkout drop-off rates from Wayfair session data using PostgreSQL aggregations and a CTE.
WayfairExplain why a statistically significant result may still be too small to matter for a business decision.
Identify, detect, and mitigate network effects, spillover, and sample ratio mismatch in online experiments.
Explain why a chosen metric was appropriate for comparing outcomes in Meta's unread circle notification experiment.
Define a success metric for a new feature that captures real user value, not just raw usage.
Identify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.