Top 17
Prep plan
Updated weekly · Last refresh Oct 17

Jerry Data Analyst Interview Questions

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

17questions
~3htotal time
Track your progressSign up free to work through all 17 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 1 drill · ~66 min
Top 5 Products SQL QueryMedium
Practice

Find the five products with the highest completed-order sales during the fixed one-year reporting period.

JoinsRankingAggregationsJerry
Clustered vs Non-Clustered IndexesMedium

Explain how clustered and non-clustered indexes differ in storage, lookup behavior, and query performance.

JoinsData WranglingJerry
Customer Orders: LEFT vs INNER JOINEasy

Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.

JoinsData WranglingGroup ByJerry
Conversion Rate by Acquisition ChannelEasy
Practice
Practice drill

Calculate signup-to-paid conversion by channel using joins, a CTE, and grouped aggregation in PostgreSQL.

JoinsCase WhenAggregationsRipplingHarnessJerry
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership7 questions · ~66 min
Structuring an Ambiguous Business CaseMedium

Tests structured problem solving under ambiguity, prioritization, and clear communication in a business case setting.

CommunicationProblem Solvingcase studyJerry
More Behavioral & Leadership questions with a free account
3
More topics4 questions · ~38 min
Build an Engagement FeatureMedium

Approach for identifying, prioritizing, and launching a new feature that increases user engagement.

Feature PrioritizationUser NeedsUse CasesJerry
Diagnose Funnel Drop-OffMedium

Analyze where users drop off in a product funnel and identify the biggest conversion leak.

AARRR FrameworkFunnel AnalysisConversion RateJerry
Mean and Median CalculationEasy

Tests understanding of core statistics and correct computation methods.

DistributionsCentral Limit TheoremExpected ValueJerry
Analyze a Successful CampaignEasy

Describe how you would evaluate a successful marketing campaign using funnel KPIs, conversion, and ROI.

KPIsDiagnosisEngagement MetricsJerry

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 17 questions plus 1 hands-on drill to finish this plan.