Airbnb · careers.airbnb.com · checked today
Senior Staff Data Engineer, Foundational Data
<div class="content-intro"><p><span style="font-family: helvetica, arial, sans-serif; font-size: 12pt;">Airbnb was born in 2007 when two hosts welcomed three guests to their San Francisco home, and has since grown to over 5 million hosts who have welcomed over 2 billion guest arrivals in almost every country across the globe. Every day, hosts offer unique stays and experiences that make it possible for guests to connect with communities in a more authentic way.</span></p></div><h3>The Community You Will Join:</h3>
Skills, with evidence
- Airflow / orchestration
from the Airflow-orchestrated pipelines that ingest telemetry, logs, and billing data
must have - Data modelling
You can design a dimensional model and define a metric others will trust
must have - Python
you write strong SQL and Python.
must have - SQL
you write strong SQL and Python.
must have - Cost & performance
Our cost dashboards are among the most-used at Airbnb, relied on by technical leads, finance, and executives.
- Scala
Scala experience is useful but not required
not practised here - Failure handling
<li>Participate in the team's on-call rotation for the datasets we own</li>
- Dashboards & BI
Our cost dashboards are among the most-used at Airbnb, relied on by technical leads, finance, and executives.
not practised here
Your plan
- The SQL screen: correct, then fast≈ 2 h
SQL
- Python: the data-wrangling round≈ 4 h
Python
- Data modelling: the round most people fail≈ 4 h
Data modelling
- Pipeline design: safe to run twice≈ 4 h
Airflow / orchestration · Failure handling
- Fourteen months of wrong numbersAdvanced
- You fixed it. Who already used it?Advanced
- The payload changed overnightAdvanced
- Creator payout runAdvanced
- Delete me from everywhereAdvanced
- Spark: read the plan Spark actually ran≈ 2 h
Cost & performance
- applyInPandas per country: what Spark ships to Python, and the native rewriteAdvanced
- Filters you wrote in the wrong place: where Catalyst moves themAdvanced
- snappy, gzip or zstd: measure the Parquet codec trade-off yourselfAdvanced
- Find the four suspects in a slow pipeline (one of them is innocent)Advanced
- A filter after a window function: pushed down or not?Advanced
- Say it out loud≈ 1 h
Not covered by the plan: Scala, Dashboards & BI.
Readiness
Counted from drills you have completed anywhere on D8LooP.
leaves in 13 dremoved the moment Airbnb closes it