Redfin Data Analyst Interview Case Study

Here is what the overall process looks like:

TLDR

Candidate: Albert

How it gets started: applied on Redfin's website

Job level: mid-level

Year of Experience: 1 year as a data analyst 

Degree: M.S. in economics

Offer: Yes

TC: ~150K USD

Location: Seattle, WA

Interview process: 6 weeks

Preparation: 1 month

Has a job: yes

Decide to join: not yet, still waiting on other companies.

Round 1 HR chat: 

 Basic questions such as whether you are willing to relocate to Seattle, do you need VISA sponsorship, and why you leave the current company. After that, Albert received a take-home assignment, which required cleaning up and pre-processing the raw dataset and then delivering a data visualization dashboard and report using Tableau.

Technical screen :

The hiring manager deep-dived into Albert's resume and especially his experience in product sense and statistical experiment, a/b testing. Why do you want to join Redfin? Why leave your current job? What do you see yourself in 5 years? Finally, a classic product diagnostic question: if a metric dropped suddenly, how do you investigate.

Virtual Onsite:

Round 1: presentation based on take-home assignment with the hiring manager

1. How come you get this conclusion?
2. Why did you use the logarithm in the x-axis in your scatterplot?
3. What did you find through the data? Do you have any experience dealing with missing data?

Round 2: product sense/ metrics and case study with a fellow senior data scientist

1. Introduce yourself
2. We found that when we ran A/B testing, the testing group won, but it was no longer significant when we launched it. What could be the cause, and how do we deal with it?

Round 3: leadership/behavioral questions 

1.  Why do you want to join Redfin?

2. What feature do you like to see we add to Redfin?

3. Have you used redefined for your home purchase?

4. Why do you want to leave your current role?

Round 4. Product and machine learning

Tell me how we can improve Redfin?

How do we improve the Redfin home value, prediction model?

Round 5. SQL and business intelligence

OUTER JOIN, WINDOW functions, and based on the same context, what kind of metrics should be included in the data visualization dashboard and report, and why?

Offer

Albert received the job offer shortly after the virtual onsite interview.

Get mentored and become 100% job interview ready for your data scientist interview, learn directly from former FAANG hiring managers,  BOOK YOUR SESSION TODAY.