Top 16
Prep plan
Updated weekly · Last refresh Oct 17

Poshmark Data Analyst Interview Questions

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

16questions
~2htotal time
Track your progressSign up free to work through all 16 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 2 drills · ~55 min
Compare Monthly User Retention CohortsMedium
Practice

Calculate month-1 retention for January vs February signup cohorts using joins, date filtering, and aggregation.

Window FunctionsDate FunctionsAggregationsPoshmark
Optimizing Large Transaction Table JoinsHard

Explain how to tune a slow PostgreSQL query that joins several large transaction tables using indexes, join strategy, and partitioning.

JoinsperformancesqlPoshmark
SQL Case Studies and PuzzlesMedium

Tests practical SQL problem-solving skills under realistic case-study constraints.

Problem SolvingsqlPoshmark
Most Common User Navigation PathsMedium
Practice
Practice drill

Use LEAD, CTEs, and ranking to find the most common 3-step user navigation paths across active-user sessions.

Window FunctionsJoinsCTEsPoshmarkQuora
Daily User Engagement MetricsEasy
Practice
Practice drill

Aggregate daily app events to report total events and distinct active users for a date range.

JoinsGroup ByAggregationsViberPoshmark
More SQL & Data Manipulation questions with a free account
2
Metrics3 questions · ~26 min
Improve Product Funnel ConversionMedium

Explain how to improve a product funnel by defining the right conversion metric, breaking the funnel apart, and acting on the biggest drop offs.

AARRR FrameworkFunnel AnalysisConversion RatePoshmark
Marketplace Health Metrics FrameworkEasy

Define a practical metric framework for tracking growth, marketplace balance, operations, and profitability in a marketplace business.

KPIsDiagnosisLTVPoshmark
Analyze User Engagement Drop After Feature ReleaseMedium

Assess the 15% drop in user engagement after a new app feature release and propose metric decomposition strategies.

Poshmark

Sign up to see every question

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

Get my prep plan
3
Behavioral & Leadership7 questions · ~61 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~18 min
Linear vs Logit ModelingMedium

Evaluates understanding of statistical functions and appropriate use in KPI modeling.

KPIPoshmark
Statistical Significance for RolloutsMedium

Evaluates your approach to hypothesis testing and interpreting rollout results.

feature evaluationData AnalysisStatistical SignificancePoshmark
The finish line: interview-readyComplete all 16 questions plus 2 hands-on drills to finish this plan.