TikTok·Data Scientist·Technical Phone Screen
May 2026
TikTok data scientist interview with a SQL-heavy technical screen. The problem revolved around a user posting log and asked for registration dates, early engagement metrics, and retention math. Pretty classic analytics setup but the retention rate piece tripped me up a bit.
- Given a user posting log table, write SQL to find each user's first posting date, compute how many posts they made within their first 7 days, and calculate the overall 7-day retention rate (the share of users who posted on day 7 or later).
“I started with a CTE to pull the min date per user, which felt right.” The rest of the author's notes on Data Scientist interview at TikTok, Technical Phone Screen round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.
View Post