Dataford
Top 28
Prep plan
Updated weekly · Last refresh Aug 30

Wayfair Data Analyst Interview Questions

The questions to prepare for a Wayfair Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

28questions
~4htotal time
Track your progressSign up free to work through all 28 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 2 drills · ~62 min
Calculate Monthly Sales Growth by Product CategoryMedium
Practice
Recently asked

Calculate month-over-month sales growth for each product category using JOINs and window functions.

JoinsAggregationsWayfair
Optimize Slow Clickstream QueriesHard
Recently asked

Tests performance tuning, query optimization, and handling large-scale clickstream data.

Performance TuningindexessqlWayfair
Top Product Revenue Last 30 DaysMedium
Practice
Practice drill

Use joins, a CTE, and aggregation to rank the top 5 products by non-returned revenue in the last 30 days.

Date FunctionsJoinsAggregationsBlue NileO'Reilly Auto PartsCengage
Rank Suppliers by Missed WindowsMedium
Practice
Practice drill

Use joins, CASE WHEN, and aggregation to find which suppliers most often miss scheduled delivery windows.

supplier performancesql analysisAggregationsLucid MotorsWayfair
More SQL & Data Manipulation questions with a free account
2
Metrics6 questions · ~51 min
Diagnose a Conversion DropMedium
Recently asked

Tests structured troubleshooting of KPI changes using segmentation and data validation.

KPIConversion RateDiagnosisWayfair
KPIs for Supplier Logistics PortalMedium
Recently asked

Tests KPI design aligned to operational outcomes and ability to define measurable targets.

project healthdashboardingkpi hierarchyWayfair
More Metrics questions with a free account
3
Behavioral & Leadership13 questions · ~110 min
More Behavioral & Leadership questions with a free account
4
More topics4 questions · ~34 min
Homepage Banner A/B Test DesignMedium
Recently asked

Design an A/B test for a homepage promotional banner, including metrics, MDE, sample size, guardrails, and a ship decision.

ExperimentationSample SizeA/B TestingWayfair
Automate Pricing Data ExtractionMedium
Recently asked

Tests practical Python skills for ETL-style automation and data cleaning for analytics readiness.

Data WranglingAutomationpythonWayfair
Find the Optimal Price PointHard
Recently asked

Tests pricing analytics thinking, experimental design, and decision-making under competitive pressure.

Pricing Strategyuser valuecompetitive landscapeWayfair
Measure Success of Pricing ChangeHard
Recently asked

Tests experimentation and causal measurement for pricing decisions in a competitive e-commerce environment.

experiment designincremental liftprimary metricsWayfair

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 28 questions plus 2 hands-on drills to finish this plan.