Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso RealSelf (Seattle, WA)
Colloquio
I applied and had a phone screen, a data challenge, and an in-person tech screen with a manager. I also had an on-site interview with three members that spanned the range of product manager, data engineer, and business analyst manager. The interview questions reflected this, with focus on how to address a few different business case studies, SQL, a little discussion about the data challenge, some high-level ML questions, and logic/estimating numbers (sort of brainteasers, but mostly to follow order-of-magnitude back of the envelope type calculations to see your logical process).
I found the questions to be fairly easy and straightforward. Although I didn't think the role was the right fit for what I wanted, I really enjoyed spending time with the team and it's clear that everyone there really likes working there and is passionate about their role in the company. Their recruiter is wonderful to work with and it is clear they put a lot of effort into the recruiting and interview process (others have already mentioned the swag bag, gift card, charity donation, etc.).
Domande di colloquio [1]
Domanda 1
Questions about my experience and background as well as why I want to join their team. How would you explain X concept to your grandparent? How would you optimize pricing for X situation? Write a SQL query to find users that took X action between X dates. Many of the same types of questions have been mentioned in other reviews.
Ho presentato la mia candidatura online. La procedura ha richiesto 3 settimane. Ho sostenuto un colloquio presso RealSelf (Seattle, WA) nel mese di mar 2021
Colloquio
I apply online in 2021, then I got HR phone call and the video meeting with Hire manager, who is the leader of business analysis team. The HR is really friendly and the interview questions are easy to average.
Domande di colloquio [1]
Domanda 1
SQL (difference between Left Join and Inner Join)
Difference between linear regression and logistic regression?
Ho presentato la mia candidatura online. La procedura ha richiesto 5 giorni. Ho sostenuto un colloquio presso RealSelf
Colloquio
firstly, I got an online assessment and required to submit in 24 hours ,includes 2 SQL, 1 case study, 1 A/B test.
but i failed and got a refused email next day.
Ho presentato la mia candidatura online. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso RealSelf (Seattle, WA) nel mese di set 2019
Colloquio
I had applied to RealSelf via Glassdoor and, after about a week or so, I received an email from RealSelf with an invitation for an assessment (so I hadn't had a phone screen at all).
This assessment was Excel/Google Sheets-based with three distinct blocks - SQL, data distribution, and kind of A/B test evaluation. An applicant should spend no more than 2 hours on this assessment and send it back to RealSelf via the provided link within 24 hours after downloading the test.
Although I didn't get an offer, I'd like to thank my recruiter, Leslie Mills, anyway. The communication with her was a breeze; she has clarified all my questions, even silly ones, and overall, it was one of the most emphatic and kind recruiters I've ever worked with. Keep on, Leslie!
Domande di colloquio [3]
Domanda 1
Write SQL queries to answer the given 3 questions using the provided scheme.