Etsy Data Analyst Interview Guide

Etsy processed billions in marketplace sales with a headcount under 2,500, which means each data analyst here owns a disproportionately large slice of the business compared to peers at bigger e-commerce companies. From hundreds of mock interviews we've run, the candidates who struggle most with Etsy are the ones who prep like it's a big-tech analytics role. It's not. You're the analytical voice in a small squad, and that squad ships based on what you find.

Etsy Data Analyst Role

You sit inside one of Etsy's autonomous product squads (Search & Discovery, Buyer Growth, Seller Experience, or Risk) as the person who turns marketplace data into product decisions. That means writing SQL against transaction, listing, and buyer/seller tables, designing A/B tests on things like personalized search ranking or free shipping promotions, and distilling results into written recommendations that travel through the org without you in the room. Success after year one looks like owning a metric framework your squad actually trusts, one where product decisions wait for your analysis rather than treating it as a post-hoc formality.

A Typical Week

The surprise hiding in that breakdown is how much of the week goes to writing and stakeholder communication versus heads-down querying. Etsy's async-friendly hybrid culture means your structured Google Docs write-up often carries more influence than any meeting you attend. The analysts who thrive here write clearly under time pressure, not just query cleanly.

Projects & Impact Areas

Search relevance absorbs much of the analytical energy right now, driven by Etsy's investment in LLMs for search ranking (documented on their Code as Craft blog), which generates a steady pipeline of A/B tests measuring buyer click-through and seller visibility. That search work naturally connects to seller ecosystem health projects like listing quality scoring and diagnosing what separates a $500/month shop from a $50K one. Meanwhile, the Risk team runs its own dedicated analytics around fraud detection and marketplace integrity, a domain that's expanding as Etsy automates more of its policy enforcement.

Skills & What's Expected

SQL depth is the skill most candidates underestimate. The widget shows balanced scores across dimensions, but in practice your ability to write complex multi-table joins across buyer, seller, listing, and transaction schemas will determine your first six months more than anything else. Python (pandas for experiment analysis) and statistics (significance testing, sample size calculations) are real requirements, not decorative, but they play supporting roles. ML knowledge sits at a medium bar: you won't build production models day to day, yet you need enough fluency with Etsy's search and recommendation systems to evaluate their output and explain tradeoffs to a PM deciding whether to ship.

Levels & Career Growth

The jump from mid-level to senior is less about writing harder SQL and more about defining what gets measured, not just measuring what's asked. Etsy's investment in ML for search and recommendations creates a natural growth path for analysts who want to shift toward modeling over time. The thing that blocks promotion most often, from what candidates and former employees report, is staying reactive to ad-hoc requests instead of proactively shaping the analytical agenda for your squad.

Work Culture

Etsy runs a hybrid model out of its Brooklyn HQ in Dumbo, with employees expected in-office roughly two days per week and many analytics folks clustering on Wednesdays and Thursdays. The pace is genuinely humane: 9:30 to 5:30 is normal, and the company's "minimize waste" value extends to killing unnecessary meetings. Seller impact frequently wins internal arguments over pure revenue optimization, which can feel refreshing or frustrating depending on your disposition. One honest tradeoff: the smaller headcount means fewer analytics peers to learn from compared to a larger org, so you need to be comfortable with self-directed growth.

Etsy Data Analyst Compensation

Reliable public data on Etsy's exact vesting schedule, refresh grant cadence, and band rigidity is thin. If you receive an offer, ask your recruiter to walk through the vesting split year by year and whether refresh grants are standard for your level. Those two details will tell you more about your real four-year earnings than the headline TC number ever could.

On negotiation: Etsy competes for analyst talent against a dense NYC market of mid-cap tech companies and fintech firms. From what candidates report, a credible competing offer tends to create more movement on the equity portion of the package than on base. Run your own math on what the RSU grant looks like at a conservative stock price, not just the grant-date valuation, before you sign anything.

Etsy Data Analyst Interview Process

Timelines vary, but from what candidates report, Etsy's process can move faster than you'd expect for a company its size. Lock in your availability early, because gaps between rounds seem to come from scheduling logistics rather than slow decision-making.

The round that separates candidates, based on public interview accounts, is the one where you present findings to a simulated product audience. Knowing your SQL isn't enough if you can't connect a query result to a recommendation about, say, whether a change to Etsy's listing quality score is actually helping handmade sellers get discovered. Practice framing every analysis around a specific action the team should take, not just what the data shows.

Etsy Data Analyst Interview Questions

SQL & Data Manipulation

Expect questions that force you to translate messy payments/product prompts into correct SQL under time pressure. You’ll be evaluated on joins, window functions, cohorting, and debugging logic to produce decision-ready tables.

For each listing, compute the trailing 28-day booking revenue, excluding the current day, and return the top 50 listings by that metric for yesterday. Bookings can be refunded, so use net revenue per booking.

AirbnbMediumWindow Functions and Time Windows

Sample Answer

Compute daily net revenue per listing, then sum it over the prior 28 days using a date-based window that excludes the current day. You avoid double counting by aggregating to listing-day before windowing, then filtering to yesterday at the end. Use $[d-28, d-1]$ as the window, not 28 rows, because missing days exist. Net revenue should incorporate refunds at the booking level before the listing-day rollup.

SQLCopy

1WITH booking_net AS (
2  SELECT
3    b.booking_id,
4    b.listing_id,
5    DATE(b.booking_ts) AS booking_day,
6    COALESCE(b.gross_amount_usd, 0) - COALESCE(b.refund_amount_usd, 0) AS net_amount_usd
7  FROM bookings b
8  WHERE b.status IN ('confirmed', 'completed', 'refunded')
9),
10listing_day AS (
11  SELECT
12    listing_id,
13    booking_day,
14    SUM(net_amount_usd) AS net_revenue_usd
15  FROM booking_net
16  GROUP BY 1, 2
17),
18scored AS (
19  SELECT
20    listing_id,
21    booking_day,
22    SUM(net_revenue_usd) OVER (
23      PARTITION BY listing_id
24      ORDER BY booking_day
25      RANGE BETWEEN INTERVAL '28' DAY PRECEDING AND INTERVAL '1' DAY PRECEDING
26    ) AS trailing_28d_net_revenue_excl_today_usd
27  FROM listing_day
28)
29SELECT
30  listing_id,
31  trailing_28d_net_revenue_excl_today_usd
32FROM scored
33WHERE booking_day = CURRENT_DATE - INTERVAL '1' DAY
34ORDER BY trailing_28d_net_revenue_excl_today_usd DESC NULLS LAST
35LIMIT 50;

You need host-level cancellation rate for the last 90 days, where the numerator is guest-initiated cancellations and the denominator is all bookings that reached confirmed status. Hosts can have multiple listings, and booking status changes are tracked in an events table with one row per status transition.

AirbnbHardEvent Log Deduping and Conditional Aggregation

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more SQL & Data Manipulation questions

Product Sense & Metrics

The bar here isn’t whether you know a metric name—it’s whether you can structure an analysis plan that maps to decisions. You’ll need to define success, identify leading vs lagging indicators, and anticipate confounders and data limitations.

How would you define and choose a North Star metric for a product?

EasyFundamentals

Sample Answer

A North Star metric is the single metric that best captures the core value your product delivers to users. For Spotify it might be minutes listened per user per week; for an e-commerce site it might be purchase frequency. To choose one: (1) identify what "success" means for users, not just the business, (2) make sure it's measurable and movable by the team, (3) confirm it correlates with long-term business outcomes like retention and revenue. Common mistakes: picking revenue directly (it's a lagging indicator), picking something too narrow (e.g., page views instead of engagement), or choosing a metric the team can't influence.

Outbound delivery speed for the company Logistics improved from 2.3 to 2.1 days, but CS contacts per 1,000 orders increased by 12% in the same period. You have order, shipment scan, and contact reason data, propose a metric framework to diagnose whether the speed win is causing the contact increase.

AmazonMediumMetric Decomposition and Customer Contacts

Sample Answer

You could do cohort decomposition by promised speed buckets or you could do contact rate standardization holding mix constant. Cohort decomposition wins here because it exposes which promise and ship-method segments changed behavior, and whether contacts spike specifically where speed improved. Standardization is faster but can hide operational failure modes like more partial shipments or missed promised windows. You want both eventually, but the cohort view answers causality-adjacent questions with fewer assumptions.

A company reduces the guest service fee by 1 percentage point in 5 countries, and Finance wants a metric tree that separates demand lift from margin impact and host behavior changes. Propose the primary success metric, the decomposition you would show (with formulas), and 2 guardrails that prevent gaming or long-run supply damage.

AirbnbHardMetric Tree and Unit Economics

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more Product Sense & Metrics questions

A/B Testing & Experiment Design

What is an A/B test and when would you use one?

EasyFundamentals

Sample Answer

An A/B test is a randomized controlled experiment where you split users into two groups: a control group that sees the current experience and a treatment group that sees a change. You use it when you want to measure the causal impact of a specific change on a metric (e.g., does a new checkout button increase conversion?). The key requirements are: a clear hypothesis, a measurable success metric, enough traffic for statistical power, and the ability to randomly assign users. A/B tests are the gold standard for product decisions because they isolate the effect of your change from other factors.

You run an experiment on the guest cancellation flow and randomize by user_id, but a guest can book multiple trips and see both variants across devices. How do you detect and quantify interference, and what changes to the design or analysis would you make?

AirbnbMediumSUTVA violations and unit of randomization

Sample Answer

Reason through it step by step as if thinking out loud. Start by checking exposure logs, does the same guest_id have multiple variant assignments across sessions or devices, and what share of traffic is affected. Next, quantify bias risk by comparing outcome rates for cross-exposed users versus clean users, and by re-estimating the lift on the clean subset to see how sensitive the result is. Then pick a fix: enforce sticky assignment at the guest_id level with consistent identity stitching, or move randomization to a higher level like booking_id if the treatment is per booking. If you cannot fix assignment, analyze with cluster-robust standard errors at the guest_id level, or switch to a design like switchback only if the interference is time-based rather than user-based.

A company runs 8 simultaneous experiments on the host pricing page, and your experiment shows $p = 0.03$ on booking conversion and $p = 0.20$ on contribution margin. How do you decide whether this is a real win, and what correction or validation would you apply?

AirbnbHardMultiple testing and ambiguous readouts

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more A/B Testing & Experiment Design questions

Statistics

Most candidates underestimate how much applied stats shows up in fraud analytics, from thresholding to false-positive tradeoffs. You’ll need to reason clearly about distributions, sampling bias, and how to validate signals with limited labels.

What is a confidence interval and how do you interpret one?

EasyFundamentals

Sample Answer

A 95% confidence interval is a range of values that, if you repeated the experiment many times, would contain the true population parameter 95% of the time. For example, if a survey gives a mean satisfaction score of 7.2 with a 95% CI of [6.8, 7.6], it means you're reasonably confident the true mean lies between 6.8 and 7.6. A common mistake is saying "there's a 95% probability the true value is in this interval" — the true value is fixed, it's the interval that varies across samples. Wider intervals indicate more uncertainty (small sample, high variance); narrower intervals indicate more precision.

A company Logistics changed a routing rule and late deliveries dropped from $2.4\%$ to $2.1\%$ over 14 days, but shipment volume also increased and the mix shifted toward longer-distance lanes. How do you estimate whether the routing change reduced late deliveries, and which statistical model or adjustment would you use?

AmazonMediumConfounding and Adjusted Comparisons

Sample Answer

Walk through the logic step by step as if thinking out loud. Start by defining the outcome as a binary label per shipment (late or not) and list the main confounders, lane distance, carrier, promised speed, weather, day-of-week, and volume. Then fit a logistic regression with a treatment indicator for the routing rule change plus those covariates (and ideally lane fixed effects) so you compare like with like. Validate by checking pre-change trends by lane, then report an adjusted lift with a CI, not just the raw $2.4\%$ to $2.1\%$ delta.

An AWS Console UI experiment shows a $+1.2\%$ lift in weekly active users, but the metric has heavy-tailed session counts and the variance doubled during the test. How do you decide whether to ship, and what statistical technique would you use to make the result decision-ready?

AmazonHardVariance, Heavy Tails, and Robust Inference

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more Statistics questions

Data Modeling

When you design tables for analytics, you’re being tested on grain, keys, and how modeling choices impact BI performance and correctness. Expect star schema reasoning, fact/dimension tradeoffs, and how you’d model common product/usage datasets.

An ETL job builds fct_support_interactions from Zendesk tickets, chat transcripts, and on-chain deposit events, and you notice a sudden 12% drop in interactions after a schema change in chat. What data quality checks and pipeline safeguards do you add so this does not silently ship to dashboards again?

CoinbaseMediumETL Monitoring, Data Quality

Sample Answer

Get this wrong in production and your CX dashboards underreport demand, staffing and SLA decisions get made on fake stability. The right call is to add volume and freshness checks (row count deltas by source, max event timestamp lag), completeness checks on required keys (ticket_id, interaction_id, user_id), and distribution checks on critical dimensions (channel, product surface). Gate the publish step with alerting and fail-closed thresholds, plus backfill logic and schema versioning so a renamed field cannot null out a join unnoticed.

A company wants a single "gross bookings" metric used by Finance and Product, but your model has cancellations, modifications, partial refunds, and multiple payment captures per reservation. How do you model facts and keys so that gross bookings, net bookings, and revenue can be computed without double counting across these flows?

AirbnbHardFact Modeling, Double Counting, Payments and Reservations

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more Data Modeling questions

Visualization

When dashboards become the source of truth, small choices in charting and narrative can change decisions. You’ll be tested on picking the right visual, communicating insights to non-technical stakeholders, and proposing actionable next steps.

A Tableau dashboard for the company Retail shows conversion rate by store, but the VP wants stores ranked and "actionable" by tomorrow. What is your default chart and sorting approach, and what adjustment do you make to avoid overreacting to small-sample stores?

AppleMediumRanking, Variability, and Visualization Choice

Sample Answer

The standard move is a ranked bar chart of conversion with a reference line for the fleet median, plus a small table for traffic and transactions. But here, sample size matters because $n$ varies wildly by store, so the ranking is mostly noise for low-traffic locations. You either filter to a minimum volume threshold or plot a funnel chart (conversion versus sessions) with confidence bands, then call out only statistically stable outliers for action.

You ship an exec dashboard for iOS crash rate by build, but a new build rollout causes an apparent crash-rate jump. How do you redesign the dashboard so leadership can tell whether the build is worse versus the user mix changing due to staged rollout?

AppleHardCohorting, Segmentation, and Narrative Design

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more Visualization questions

Data Pipelines & Engineering

In practice, you’ll be asked how you keep reporting accurate when pipelines break or definitions drift. Strong answers cover validation checks, anomaly detection, backfills, idempotency, and communicating data incidents to stakeholders.

What is the difference between a batch pipeline and a streaming pipeline, and when would you choose each?

EasyFundamentals

Sample Answer

Batch pipelines process data in scheduled chunks (e.g., hourly, daily ETL jobs). Streaming pipelines process data continuously as it arrives (e.g., Kafka + Flink). Choose batch when: latency tolerance is hours or days (daily reports, model retraining), data volumes are large but infrequent, and simplicity matters. Choose streaming when you need real-time or near-real-time results (fraud detection, live dashboards, recommendation updates). Most companies use both: streaming for time-sensitive operations and batch for heavy analytical workloads, model training, and historical backfills.

You need a trustworthy daily metric for App Store subscriptions that powers Finance reporting and product dashboards, and events can arrive up to 72 hours late. How do you design the warehouse tables and the incremental rebuild logic so the metric is both stable and correct?

AppleMediumLate Arriving Data and Incremental Loads

Sample Answer

Start with what the interviewer is really testing: "This question is checking whether you can keep a metric stable for stakeholders while still correcting for late data." You typically separate an immutable raw events layer from a curated fact layer keyed by a stable business grain (for example, subscription, day, storefront), and define a rolling recompute window of the last $N$ days where $N \ge 3$ to absorb late arrivals. You also need a clear definition of when the metric is final (for example, a watermark), plus audit columns like load_timestamp and source_max_event_time so you can explain changes and meet SLAs.

An Airflow DAG builds a daily fact table for payouts to hosts, partitioned by payout_date, and finance reports missing payouts for a two week window after a backfill. How do you design the backfill and data quality safeguards so you avoid double counting, preserve idempotency, and keep downstream Superset dashboards stable?

AirbnbHardBackfills, Idempotency, and Data Quality Gates

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more Data Pipelines & Engineering questions

Causal Inference

What is the difference between correlation and causation, and how do you establish causation?

EasyFundamentals

Sample Answer

Correlation means two variables move together; causation means one actually causes the other. Ice cream sales and drowning rates are correlated (both rise in summer) but one doesn't cause the other — temperature is the confounder. To establish causation: (1) run a randomized experiment (A/B test) which eliminates confounders by design, (2) when experiments aren't possible, use quasi-experimental methods like difference-in-differences, regression discontinuity, or instrumental variables, each of which relies on specific assumptions to approximate random assignment. The key question is always: what else could explain this relationship besides a direct causal effect?

Hulu ad load was reduced for a subset of DMAs, but advertisers also shifted budgets toward those same DMAs mid-flight due to a sports schedule. You need the causal effect of ad load reduction on ad revenue per hour, do you use a geo-based diff-in-diff or an instrumental variables approach, and why?

DisneyMediumGeo Experiments and Instrumental Variables

Sample Answer

You could do geo diff-in-diff or instrumental variables (IV). Geo diff-in-diff is simpler, but it loses credibility here because budget reallocation creates time-varying confounding correlated with treatment assignment. IV wins if you have a plausibly exogenous instrument for ad load, for example a policy or capacity constraint that shifts ad load but does not directly shift demand, then you estimate $\text{AdLoad}\rightarrow\text{RevenuePerHour}$ via 2SLS and defend exclusion and relevance.

A company runs a retargeting campaign for the company+ lapsed subscribers, but exposure is highly selective because it targets users with high predicted return probability. How do you design a quasi-experiment to estimate incremental resubscription lift, and what diagnostics convince you the estimate is not driven by selection bias?

DisneyHardSelection Bias and Quasi-Experimental Design

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more Causal Inference questions

Etsy's interview loop leans on a specific compounding effect: you'll write SQL against schemas that mirror their marketplace (listings, shops, transactions, reviews), then immediately get asked how those results should change a product decision, like whether Etsy's listing quality score is actually improving search click-through for niche categories or just boosting high-volume shops. Candidates who practice queries and business reasoning as separate skills get caught in the gap between them. Etsy's small squad structure means the analyst IS the person translating numbers into a recommendation for the PM sitting across the table, so interviewers probe that translation hard.

Build that muscle with realistic question sets at datainterview.com/questions.

How to Prepare for Etsy Data Analyst Interviews

Etsy's Code as Craft blog details how the company uses LLMs to improve search relevance, and that investment has downstream implications for analyst work: someone has to measure whether those ranking changes actually help buyers find what they want without burying smaller shops. The company pulled in roughly $2.88 billion in revenue last year with a headcount of about 2,375, and its product delivery culture organizes those people into small, autonomous squads rather than large centralized teams.

The "why Etsy" answer that falls flat is any version of "I love handmade things." What separates Etsy from Amazon Handmade or Shopify isn't just the product catalog; it's that Etsy's take rate and marketplace design explicitly protect the creative entrepreneur's brand identity, even when that means sacrificing short-term GMS growth. Reference that tension directly. Mention, for example, how Etsy's 2025 earnings results show modest 3.5% revenue growth, which reflects a company choosing curation over volume in a way that shapes every metric an analyst would own.

Try a Real Interview Question

1WITH base AS (
2  SELECT
3    a.market,
4    a.variant,
5    s.session_id,
6    CAST(s.did_book AS DOUBLE) AS did_book
7  FROM experiment_assignments a
8  JOIN sessions s
9    ON s.user_id = a.user_id
10   AND s.session_start >= a.assigned_at
11   AND s.session_start < a.assigned_at + INTERVAL '7' DAY
12  WHERE a.experiment_name = 'search_ranker_v2'
13), agg AS (
14  SELECT
15    market,
16    variant,
17    AVG(did_book) AS conversion_rate
18  FROM base
19  GROUP BY 1, 2
20)
21SELECT
22  market,
23  MAX(CASE WHEN variant = 'control' THEN conversion_rate END) AS conv_control,
24  MAX(CASE WHEN variant = 'treatment' THEN conversion_rate END) AS conv_treatment,
25  (MAX(CASE WHEN variant = 'treatment' THEN conversion_rate END)
26   - MAX(CASE WHEN variant = 'control' THEN conversion_rate END)) AS lift
27FROM agg
28GROUP BY 1
29ORDER BY 1;

Etsy's interview exercises, from what candidates report, reward you for scoping a broad prompt down to the highest-signal analysis rather than trying to cover everything. That instinct for prioritization is worth practicing deliberately. Build reps on marketplace-style SQL problems at datainterview.com/coding.

Test Your Readiness

Sharpen your experiment design and metric definition skills at datainterview.com/questions, where you can practice the kinds of two-sided marketplace reasoning Etsy's process emphasizes.