Jellyfish Data Analyst Interview Questions

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

34questions

~5htotal time

Track your progressSign up free to work through all 34 questions and resume where you left off.

Start practicing free →

SQL & Data ManipulationStart here. 9 questions · ~82 min

Rolling 30-Day Active UsersHard

Practice

Calculate daily rolling 30-day active users from a BCG event log using CTEs, date intervals, and distinct aggregation.

Window FunctionsDate FunctionsRunning Totals

Jellyfish

Debug and Optimize Slow SQLMedium

Practice

Task A reporting query at a commerce platform summarizes recent orders for active customers, but the production version is slow. Write a PostgreSQL query t...

database optimizationlarge datasetsdatabase querying

Jellyfish

Second-Highest Client Transaction AmountMedium

Practice

Use a CTE, join, and dense ranking to return each client's second-highest distinct transaction amount.

Window FunctionsSubqueriesRanking

Jellyfish

More SQL & Data Manipulation questions with a free account

Pipelines3 questions · ~27 min

Verify Tracking Script FiresMedium

Tests debugging and validation of web tracking implementations.

Data QualityToolsQuality

Jellyfish

Set Up Custom Event TriggersMedium

Tests ability to implement event tracking that supports multi-platform performance measurement.

ToolsAutomationData Modeling

Jellyfish

Troubleshoot GA Vs Internal SalesHard

Tests end-to-end analytics reconciliation and root-cause analysis.

Data QualityReconciliationtransactions

Jellyfish

Behavioral & Leadership20 questions · ~181 min

More Behavioral & Leadership 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

The finish line: interview-readyComplete all 34 questions to finish this plan.