Dataford
Top 31
Prep plan
Updated weekly · Last refresh Sep 18

Zest AI Data Analyst Interview Questions

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

31questions
~4htotal time
Track your progressSign up free to work through all 31 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 7 questions + 2 drills · ~80 min
Top Customers by Net SalesMedium
Practice

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingZest AI
Pandas Aggregate and IndexingMedium

Tests your ability to manipulate and summarize data effectively with pandas.

pandasZest AI
Top Daily Rides by VehicleMedium
Practice
Practice drill

Rank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.

Window FunctionsJoinsData WranglingWaymoCruise
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
More SQL & Data Manipulation questions with a free account
2
Metrics3 questions · ~26 min
Diagnose Churn by Customer SegmentMedium

Investigate why one customer segment drives most churn and what actions to take.

User SegmentsChurnDiagnosisZest AI
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
Statistics & Probability5 questions · ~43 min
Interpreting P Values in TestingEasy

Explain what a p-value means in hypothesis testing and how it relates to statistical significance.

Hypothesis TestingStatistical SignificanceP-ValuesZest AI
Variable Contribution in RegressionMedium

Evaluates your ability to interpret linear regression coefficients and communicate variable impact.

linear regressionZest AI
More Statistics & Probability questions with a free account
4
Product Sense3 questions · ~26 min
Analyze Credit Scoring ImpactMedium

Tests ability to connect analytics to lending risk outcomes and model improvement.

User SegmentsValue PropositionUse CasesZest AI
More Product Sense questions with a free account
5
Behavioral & Leadership11 questions · ~94 min
More Behavioral & Leadership questions with a free account
6
More topics2 questions · ~17 min
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityZest AI
Evaluate Marketing CampaignsMedium

Tests experimental thinking and metrics selection for campaign impact measurement.

ExperimentationGuardrail MetricsA/B TestingZest AI
The finish line: interview-readyComplete all 31 questions plus 2 hands-on drills to finish this plan.