ByteDance Data Analyst interview questions

2 Data Analysts have shared notes from their ByteDance interviews, with the questions they were asked in each round. That is 1% of the 289 ByteDance interview notes on Screna AI.

2 Data Analyst interview notes

ByteDance·Data Analyst·Technical Phone Screen

Jun 2026
Bytedance Data Analyst technical screen, two SQL problems back to back. Nothing behavioral, just pure query writing under a bit of time pressure. The problems weren't impossible but the details tripped me up more than I expected.
  • Given a users table and a transactions table, identify users whose total completed crypto transaction amount exceeded £100 within the 7 days following their account creation. Return the user ID and that summed amount.
  • Using an activity table that logs views and clicks per product, compute the click-through rate for each product and return whichever product (or products) has the highest CTR. Exclude any product that has zero views.

“The window join is where I fumbled a bit.”

View Post

ByteDance·Data Analyst·Technical Phone Screen

May 2026
SQL-heavy data analyst interview at Bytedance, two meaty scenario questions back to back with no warmup. Both were open-ended enough that I kept second-guessing whether I was going too deep or not deep enough.
  • Revolut has just launched a new paid subscription tier called Ultra. There's no dedicated subscription table, so you have to infer adoption from transactions and activity data. How would you define a successful launch in the first month, and what SQL analyses would you build around it?
  • Using only the available tables, how would you build a rule-based SQL system to flag suspicious users or transactions for the fraud team? Walk through the rules you'd write, how you'd combine them into a risk score or review queue, and how you'd evaluate whether the system is actually working.

“This one sprawled in a way I wasn't ready for.”

View Post