Position: Data Analyst
Location: San Francisco Bay Area, CA
Outcome: Onsite Rejected
How was the interview process? What was it like?
Lots of questioning on behavioral aspects. How do you interact with PMs, UI engineers, managers. How do you frame a business question into a data format. What metrics would you consider for understanding flow of sign up page, what A/B would you conduct, when to stop the test and deliver results.
What technical questions were asked?
SQL / Pandas, Business Case and Estimation, Product Metrics and Measurement
What was one of your solutions?
Created a self join to the table, with a filter to limit to max date values 7 days or earlier. If the user has a campaign value- use that. If null, use the value from the self join. If that is also null, then call it organic.