TikTok Data Scientist Interview Questions

Applying to TikTok as a Data Scientist means preparing for a product-first, metrics-driven interview loop where speed, stakeholder influence, and practical experimentation matter as much as algorithms. TikTok Data Scientist interview questions typically emphasize SQL and Python data manipulation at scale, experiment design and causal inference, product analytics and metric definition, and pragmatic modeling choices. Interviewers look for technical correctness, clear assumptions, the ability to link analysis to business metrics, and concise communication that persuades product and engineering partners. You should expect a staged process: an initial recruiter screen and technical assessment followed by a virtual loop of 3–5 interviews mixing live SQL/Python exercises, product-analytics or modeling case problems, A/B testing scenarios, and behavioral discussions. For interview preparation, practice writing readable SQL with window functions and CTEs, build short Python data pipelines, rehearse experiment-design explanations, and prepare STAR stories showing ownership and impact. Simulated loops with timed coding and product cases

128 Questions 1 Company02.17.2026
Showing 20 results
Role
TikTok logo
TikTok
Medium
Data Scientist

Select 10% Users Randomly from User Table

users +----+----------+-------------+ | id | username | signup_date | +----+----------+-------------+ | 1 | alice | 2023-01-02 | | 2 | bob ...

Data Manipulation (SQL/Python)
0
0
5 people solved
Aug 4, 2025
TikTok logo
TikTok
Easy
Data Scientist

Calculate Expected Draws for X > 0.8 in Uniform(0,1)

Calculate Expected Draws for X > 0.8 in Uniform(0,1) Scenario Quick probability check during a first-round screen to gauge statistical intuition. Ques...

Statistics & Math
7
0
58 people solved
Aug 4, 2025
TikTok logo
TikTok
Medium
Data Scientist

Maximize Distinct Purchases Within Budget Constraints

Scenario Given a customer budget and a list of product prices, determine the maximum number of distinct products the customer can afford. Question Des...

Coding & Algorithms
28
0
53 people solved
Jul 12, 2025
TikTok logo
TikTok
Medium
Data Scientist

Analyze Negative Reviews' Impact on Coupon Repurchase Rate

Measuring Negative Reviews' Impact on Coupon Repurchase Management wants to understand how negative customer reviews affect the probability that a use...

Analytics & Experimentation
22
0
91 people solved
Jul 12, 2025
TikTok logo
TikTok
Easy
Data Scientist

Test Billboard Campaign Conversion Rate Exceeds 60%

Test Whether a Billboard Campaign Conversion Rate Exceeds 60% A billboard campaign sample contains N = 100 users, and 65 of them converted. You want t...

Statistics & Math
38
0
131 people solved
Jul 12, 2025
TikTok logo
TikTok
Medium
Data Scientist

Optimize Station Sequence for Maximum Car Output in Simulation

Scenario The Car-Building mini-game lets you sequence chassis, engine, and paint stations with limited buffers. Question Describe a strategy to maximi...

Coding & Algorithms
10
0
33 people solved
Jul 12, 2025
TikTok logo
TikTok
Medium
Data Scientist

Tiktok DS Interview Questions

Scenario: You are provided with two tables: minute_streamed and minute_viewed. The minute_streamed table records each minute of streaming activity, wh...

Data Manipulation (SQL/Python)
11
1
83 people solved
Jun 26, 2025
TikTok logo
TikTok
Medium
Data Scientist

Investigating Correlation Between Ad Visits and Reports

Scenario You are on the analytics team at a large social media platform. A positive correlation has been observed between the number of page visits to...

Analytics & Experimentation
6
0
62 people solved
Jun 22, 2025
TikTok logo
TikTok
Easy
Data Scientist

Write monthly customer and sales SQL queries

You are analyzing a food-delivery marketplace. Tables Assume the following schema (you may add minor helper CTEs as needed): orders - order_id (BIGINT...

Data Manipulation (SQL/Python)
6
4
84 people solved
Nov 27, 2025
TikTok logo
TikTok
Medium
Data Scientist

Write SQL for 7-day geo-localized revenue dashboard

Write a single SQL query (assume PostgreSQL; tz_offset is an integer hour offset from UTC) to compute a 7-day dashboard by local user date for US vs A...

Data Manipulation (SQL/Python)
0
0
9 people solved
Oct 13, 2025
TikTok logo
TikTok
Medium
Data Scientist

Compute and rank top bad advertisers

SQL on ad safety. Assume the following schema and sample rows. Use ANSI SQL. Today is 2025-09-01; interpret “last 7 days” as 2025-08-26 00:00:00 to 20...

Data Manipulation (SQL/Python)
2
0
10 people solved
Oct 13, 2025
TikTok logo
TikTok
Medium
Data Scientist

Write SQL for geo posting-frequency drops

Using the schema below, write a single ANSI SQL query (window functions allowed) that identifies countries with the largest share of creators whose po...

Data Manipulation (SQL/Python)
11
0
89 people solved
Oct 13, 2025
TikTok logo
TikTok
Medium
Data Scientist Locked

Design a creator posting-frequency experiment

This question evaluates experimental design and causal inference competencies for a Data Scientist, including precise metric definition, randomization...

Analytics & Experimentation
4
0
38 people solved
Oct 13, 2025
TikTok logo
TikTok
Medium
Data Scientist

Compute last-to-previous ad impression gaps

Given impressions(ad_id INT, user_id INT, impression_ts TIMESTAMP) with multiple impressions per (user_id, ad_id), write a single SQL query to return,...

Data Manipulation (SQL/Python)
0
0
3 people solved
Oct 13, 2025
TikTok logo
TikTok
Hard
Data Scientist Locked

Prove conversion ads value via incrementality

This question evaluates a candidate's competency in causal inference and experimentation design for advertising measurement, covering metrics and attr...

Analytics & Experimentation
2
0
53 people solved
Oct 13, 2025
TikTok logo
TikTok
Medium
Data Scientist

Compute CTR drop with exclusions

Assume today = 2025-09-01. Using ad delivery logs, find advertisers whose CTR in the last 7 days (2025-08-25 to 2025-08-31) dropped by at least 20% re...

Data Manipulation (SQL/Python)
8
0
110 people solved
Oct 13, 2025
TikTok logo
TikTok
Medium
Data Scientist

Compare SQL counts, windows, and NULL semantics

You’re given two tables. users(id INT, country STRING, created_at DATE) rows: 1 | US | 2025-08-28 2 | US | 2025-08-30 3 | IN | 2025-08-29 4 | BR | 202...

Data Manipulation (SQL/Python)
8
0
71 people solved
Oct 13, 2025
TikTok logo
TikTok
Medium
Data Scientist

Communicate technical impact under skeptical stakeholders

Reframing a Multi‑Team Project for a Technical‑Only Hiring Manager Context You are a data scientist in a technical screen. You need to present a multi...

Behavioral & Leadership
1
0
28 people solved
Oct 13, 2025
TikTok logo
TikTok
Medium
Data Scientist

Compute 7-day rolling complaint/order ratio in SQL

SQL only. Given the schema and sample data below, write a single Postgres query (no procedural code) to compute a 7-day rolling complaint-to-order rat...

Data Manipulation (SQL/Python)
1
0
13 people solved
Oct 13, 2025
TikTok logo
TikTok
Medium
Data Scientist

Derive L1 vs L2 effects with correlation

Multicollinearity: Ridge vs LASSO vs Elastic Net Setup - Two standardized predictors x1 and x2 with corr(x1, x2) = 0.99. - X'X = [[100, 99], [99, 100]...

Statistics & Math
5
0
65 people solved
Oct 13, 2025

Frequently Asked Questions

How difficult are TikTok Data Scientist interview questions compared with other big‑tech data scientist roles?
TikTok Data Scientist interview questions are often rigorous and practical, comparable to other large consumer tech firms. Expect a mix of medium‑to‑hard SQL and Python problems, statistic and experimentation questions, product‑sense cases, and behavioral assessments. Difficulty varies by level and team: recommendation, ads, or trust teams tend to surface more modeling and systems trade‑off questions, while analytics roles emphasize SQL and experimental design. Interviewers evaluate technical correctness, clarity of explanation, assumptions, and business impact. Overall, the process rewards clear, reproducible thinking and the ability to connect analysis to product metrics rather than only algorithmic cleverness.
What is the typical TikTok Data Scientist interview process and in which rounds does the Data Scientist topic appear?
The typical process begins with a recruiter screen, followed by a hiring manager or technical phone/video screen that mixes behavioral and technical elements. Many candidates face an online assessment or coding task focused on SQL/Python and statistics, then a virtual onsite loop of four to five interviews covering coding and data manipulation, modeling and experimentation, product sense, and behavioral fit. Data science topics appear across nearly every round: SQL and data wrangling show up early, modeling and experiment design in middle rounds, and product/behavioral questions throughout. Timing and exact structure can vary by team and role seniority.
What is a realistic interview preparation timeline for a TikTok Data Scientist role?
A realistic timeline is 4–8 weeks depending on your starting point. In the first two to three weeks, solidify fundamentals: SQL queries with joins, windows and aggregations, core statistics, and pandas-based data manipulation. Weeks three to five should include modeling refreshers, A/B testing design, and practicing product-case structure. The final one to two weeks are for timed practice, mock interviews, and refining stories for behavioral questions using concrete metrics and impact. Throughout, incorporate regular code review, timed SQL exercises, and at least three full mock loops to build pacing and communication under pressure.
Which key subtopics should I prioritize for TikTok Data Scientist interview questions?
Prioritize SQL (joins, aggregates, window functions, CTEs, NULL handling, and performance considerations) and Python data manipulation with pandas and complexity awareness. Statistics and experimentation are essential: hypothesis testing, confidence intervals, power/sample-size, and guardrails for A/B tests. Modeling basics and interpretability—regression diagnostics, classification, bias/variance, and common algorithms—are often probed. Product and analytics skills matter: metric design, funnel analysis, segmentation, and diagnosing metric changes. Finally, data quality, monitoring, and communicating results to cross‑functional partners are recurring themes you should demonstrate confidently.
What standout tips and common pitfalls should I know when preparing for TikTok Data Scientist interviews?
Standout tips include stating and validating assumptions, choosing and justifying product metrics, and explaining trade‑offs between accuracy, latency, and cost. Use concrete examples with numbers to show impact and frame recommendations in business terms. Practice clear, concise SQL and always explain edge cases and complexity. Common pitfalls are skipping clarifying questions, delivering results without operational considerations, neglecting data quality issues, and failing to discuss privacy or bias implications. Avoid overfitting solutions to interview data and don’t hide uncertainties—interviewers appreciate thoughtful caveats and a plan for further validation.

Explore more TikTok Data Scientist interview questions

Real questions from candidate reports, grouped by topic, role and company.

By category
Other roles at TikTok
Data Scientist questions at other companies
Browse all