Top 33
Prep plan
Updated weekly · Last refresh Oct 17

Hopper Data Analyst Interview Questions

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

33questions
~5htotal time
Track your progressSign up free to work through all 33 questions and resume where you left off.
Start practicing free →
1
A/B Testing & ExperimentationStart here. 3 questions · ~25 min
2
Metrics5 questions · ~42 min
Describe a Dataset-Driven ProjectMedium

Evaluates your approach to exploratory analysis, prioritization, and deriving actionable insights for Hopper.

Data AnalysisHopper
Assess Underpricing of Disruption GuaranteesHard

Tests ability to connect product economics to data signals and risk exposure.

risk analysisDiagnosisprofit marginsHopper
More Metrics questions with a free account

Sign up to see every question

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

Get my prep plan
3
SQL & Data Manipulation4 questions + 2 drills · ~53 min
Rolling 7-Day Price Freeze ConversionHard
Practice

Calculate Hopper Price Freeze users' rolling 7-day conversion rate using date-based aggregation and window functions.

Window FunctionsDate FunctionsConversion RateHopper
Subquery vs CTE Trade-offsMedium

Tests SQL design judgment for readability, performance, and maintainability on large datasets.

SubqueriesCTEstransactionsHopper
SQL: Avg Booking Value by SegmentMedium
Practice
Practice drill

Compare average Hopper booking values for users who purchased Price Lock and users who did not.

JoinsGroup ByCase WhenHopper
MQL to SQL Conversion SQLMedium
Practice
Practice drill

Calculate monthly MQL-to-SQL conversion rates and month-over-month percentage-point changes for PagerDuty leads.

Window FunctionsLag/LeadDate FunctionsPagerduty
More SQL & Data Manipulation questions with a free account
4
Behavioral & Leadership18 questions · ~151 min
More Behavioral & Leadership questions with a free account
5
More topics3 questions · ~25 min
Diagnose Hopper Margin IssuesHard

Evaluates product and analytics judgment for improving unit economics at Hopper.

business strategyHopper
Price Freeze Pricing Under VolatilityHard

Tests quantitative reasoning for pricing under uncertainty and risk management for product guarantees.

pricingVarianceExpected ValueHopper
Balance Fintech Fees and RetentionHard

Tests product and analytics judgment for optimizing competing business objectives over time.

RetentionValue PropositionProduct VisionHopper
The finish line: interview-readyComplete all 33 questions plus 2 hands-on drills to finish this plan.