i got a recruiter screen scheduled for a Senior Data Analyst role on the pricing/revenue team. it's in 3 weeks and i'm trying to figure out what the actual loop looks like.
the JD mentions SQL, experimentation, and stakeholder storytelling. the Glassdoor stuff is kind of old and vague.
if you've been through the Expedia analytics loop recently (last 6-12 months) i'd love to hear: how many rounds and what types what the SQL questions looked like (window functions? query optimization? joins on weird schemas?) whether there's a take-home or case study what level of domain knowledge about travel/pricing they expected
anything helps. i'll share back once i'm through it.
5 replies
de_derek
went through the data eng loop 8 months ago, different role but overlapping process. SQL round was heavy on window functions and a multi-step transformation problem. nothing too exotic, but the joins involved a messy hotel schema so knowing how to read an unfamiliar schema quickly matters more than knowing travel specifically.
ds_dmitri
data science loop here, roughly same timeframe. they gave me a take-home case study: here's a dataset of bookings, tell us something interesting, build a simple metric. gave 3 days. the presentation to two PMs + an analyst. they asked a lot about how you'd operationalize whatever you found. 'what would you actually change' type questions.
analyst_ana
that take-home format is really useful to know about. did they give you a rubric or just raw instructions?
ds_dmitri
raw instructions. 'explore and present your findings.' i spent way too long on the viz and not enough on the 'so what.' wish i'd inverted that.
numbers_only
pricing/revenue team is one of the more interesting data teams there from what i've heard. expect questions about how you think about conversion rate tradeoffs and LTV. domain doesn't matter as much as the framework.