I've been interviewing for DS roles at a bunch of companies lately. I'm also interviewing for other MLE-track roles, and for Product-track DS.
The three SQL questions weren't hard, but they were worded in a really convoluted way, so it was hard to even understand what was being asked. None of them needed anything complicated either, at most one dense rank.
The Product Sense round was about how to design metrics for a direct message feature.
This is an answer I looked at afterwards from an AI summary, and I think it makes a lot of sense:
| Category | Metrics | Why |
|---|---|---|
| North Star | Weekly Active Meaningful Conversations | Meaningful social interactions |
| Adoption | Weekly DM sender rate | Feature penetration |
| Engagement | Messages per sender, reply rate | Depth and reciprocity |
| Content Sharing | Videos shared via DM per active user | TikTok-specific value |
| Retention | D7/D30 retention, overall app retention | Long-term product impact |
| Guardrails | Spam, block rate, watch time | User safety and cannibalization |
Discussion
Loading comments…