Airbnb-Specific Data Patterns Questions
Domain-specific data modeling and analytics patterns used in Airbnb-scale product analytics. Covers data schema design, event and transaction patterns, feature engineering templates for predictive models, cohort and lifecycle analytics, geospatial and temporal data patterns, price and demand forecasting signals, AB testing data patterns, and data quality, governance, and lineage considerations relevant to Airbnb data.
MediumTechnical
0 practiced
Implement sessionization in Python using pandas: given a DataFrame events with columns user_id and event_ts (Timestamp), write a function that groups events into sessions per user where a new session starts after 30 minutes of inactivity. Return session_id, user_id, session_start, session_end, and event_count per session. Describe edge cases and complexity.
HardTechnical
0 practiced
Given an events table with billions of rows used for sessionization by user_id and timestamp, explain BigQuery (or another analytical DB) optimizations you would apply to reduce query cost and latency for session queries. Discuss partitioning, clustering, approximations, materialized views, and pre-aggregation trade-offs.
MediumTechnical
0 practiced
Write a BigQuery SQL pattern to compute the approximate median nightly price per neighborhood for the past 6 months on a dataset with tens of millions of nightly price records. Mention functions you would use to improve performance and why.
HardTechnical
0 practiced
Explain how you would estimate price elasticity of demand using panel data at the listing-day level, controlling for listing fixed effects and day fixed effects. Describe model specification, identification assumptions, and robustness checks you would perform.
HardSystem Design
0 practiced
Propose a scalable strategy for computing rolling aggregates (e.g., past 90-day bookings per listing) across billions of events daily. Compare approaches: streaming aggregates with stateful processors, daily batch pre-aggregations, and approximate algorithms, and recommend when to use each.
Unlock Full Question Bank
Get access to hundreds of Airbnb-Specific Data Patterns interview questions and detailed answers.
Sign in to ContinueJoin thousands of developers preparing for their dream job.