I applied through an employee referral. I interviewed at Dropbox (Los Angeles, CA) in Sep 2023
Interview
Only completed 2nd round, waiting to hear back 1st: recruiter screen 2nd: 45min SQL and Python/R technical screen 3rd: 5 interview final round with PM, Data Scientists, and Hiring Manager
Interview questions [1]
Question 1
SQL question: We have three tables to track user engagement and payment activities. 1) Among all the users registered in 2021 Jan, what percentage of them are active in 2021 Feb? 2) For users whose first activity is ‘Trial_Start’ we define the user type as ‘begin_as_trial’, and for those whose first activity is ‘Subscription_Start’ we define as ‘direct_purchase’; for all the others we define as ‘begin_as_basic’. Please calculate the revenue in 2020 by user type. Python question: Teams table: team_id, paid_licenses Users: user_id, team_id Suppose team type is determined by the number of licenses it's paying for. Please define a function to determine team type (small, medium or enterprise), and then calculate the average number of users in each team type small team: 1~99 licenses medium team: 100~2499 licenses enterprise team: 2500+ licenses
I applied through an employee referral. The process took 3 weeks. I interviewed at Dropbox
Interview
multiple rounds of interviews, both technical and product focused. did six interviews total including the initial screen. recruiter was friendly and had an overall solid experience with the interview and the company.
Disorganized. Reassigned to multiple recruiters over a short period. Recruiters and interviewers frequently forgot to attend scheduled phone calls, or send test materials at the scheduled times. Gave up on pursuing the position because of the experience.
Data Scientist applicants have rated the interview process at Dropbox with 3 out of 5 (where 5 is the highest level of difficulty) and assessed their interview experience as 50% positive. To compare, the company-average is 46.9% positive. This is according to Glassdoor user ratings.
Candidates applying for Data Scientist roles take an average of 16 days to get hired, when considering 6 user submitted interviews for this role. To compare, the hiring process at Dropbox overall takes an average of 21 days.
Common stages of the interview process at Dropbox as a Data Scientist according to 6 Glassdoor interviews include:
Phone interview: 33%
One on one interview: 33%
Skills test: 11%
Other: 11%
Presentation: 11%
Here are the most commonly searched roles for interview reports -