Amazon · Primly Community

Amazon data scientist interview (SQL + case + stats): what the loop actually looks like in 2026

ds_dmitri · 4 replies

just finished my amazon DS loop last month, applied for a science role on the advertising team in seattle. sharing what i found because there's surprisingly little specific info out there on the DS track vs the SWE track.

five rounds total, one recruiter screen and four interviews. the rounds were:

round 1: SQL + product sense. they gave me a schema with 3 tables (users, events, orders) and asked me to write a query for weekly retention cohorts. nothing exotic but it needed a self-join. then a product question about a metric that dropped 15% week over week. they wanted you to walk through a structured diagnosis, not just list possible causes. i think this is where a lot of DS candidates get cut. they ramble. be systematic.

round 2: stats / experimentation. one question on AB test design, power analysis, minimum detectable effect. they asked what you'd do if your experiment had a novelty effect. another question was about p-hacking and how you'd prevent it in a high-velocity testing culture. this felt very amazon-specific. they run a lot of experiments and they want people who won't just ship false positives.

round 3: ML applied. describe a model you built from scratch. i walked through a churn model i built at my current job. they pushed hard on feature engineering, how i handled class imbalance, and what happened when it went to prod vs staging. they don't want a textbook answer. they want a story where something went sideways.

round 4: leadership principles. this is the behavioral round and it matters A LOT at amazon. like, more than most companies. i prepped about 12 LP stories using STAR. they asked about customer obsession, dive deep, and deliver results specifically. they probed for specifics hard. if you say 'we increased revenue', they want the number.

a few things i noticed: the interviewers all asked 'what would you do differently?' at the end of STAR stories. build that into your prep. also, no take-home in my loop but i've heard other teams do one.

i got an offer. L5 DS, $190k base + RSUs + sign-on but i'll save the full breakdown for the comp thread.

4 replies

analyst_ana

the LP behavioral mattering more than at other companies is so real. i did a loop at amazon 2 years ago (failed) and at the debrief my recruiter said the LP round tanked me even though the technical was fine. prepping STAR stories with the actual LP names is not optional there.

ds_dmitri

yeah i basically had a google doc where i tagged each story to 2-3 LPs. made it way easier to adapt on the fly when they asked something i didn't have a dedicated story for.

remote_swe_42

did the cohort retention SQL question involve window functions or was it just a self-join? i'm prepping for a loop now and the SQL practice i've been doing is heavier on window functions.

tired_recruiter

confirming from the other side: amazon DS loops vary a lot by team. advertising is more stats-heavy, AWS teams lean more on SQL + operational metrics. the LP round is constant across all of them. it's not soft, it's a structured eval with rubrics.