Data Analyst interview
at Meta.

Tell-me-about-a-time stories on ownership, conflict, and impact — scored against this company's real values.

1. 01 Tell me about a time you delivered an analysis under a tight deadline and how you decided what was good enough to ship.
2. 02 Describe a time your dashboard or report changed how a team made a decision.
3. 03 Tell me about a time you found an error in your own analysis after sharing it and how you handled it.
4. 04 Describe a time you had to explain a complex data finding to a non-technical stakeholder who pushed back.

The hard screen for the craft itself — talked through out loud, not whiteboarded in your head.

1. 01 Write a SQL query using a self-join to find pairs of Facebook users who became friends on the same day.
2. 02 Using window functions, write a query that ranks the top 3 most-commented posts per user over the last 30 days.
3. 03 How would you structure the primary and secondary metrics, and the SQL, to evaluate the performance of an Instagram Reels launch?
4. 04 Given two tables of ad impressions and conversions, write a query to compute click-through and conversion rate by campaign with a HAVING filter on volume.

Open-ended design of the systems this company actually runs, with the interviewer probing your tradeoffs.

1. 01 Design the set of KPIs and the reporting pipeline you'd build to monitor the daily health of Facebook Messenger.
2. 02 How would you design an experiment and the supporting metrics to measure the impact of a new notification on user retention?
3. 03 Design a dashboard and metric model to track engagement funnels for Facebook Stories from view to reply.
4. 04 How would you model and instrument metrics to detect anomalies in Marketplace listing quality at scale?