Top 32
Prep plan
Updated weekly · Last refresh Oct 17

Criteo Data Analyst Interview Questions

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

32questions
~4htotal time
Track your progressSign up free to work through all 32 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions + 3 drills · ~102 min
SQL, Tableau, and Data Science ProjectsMedium

Assesses end-to-end analytics capability across querying, tooling, and modeling.

sqlpythonCriteo
SQL Dialect ChoiceEasy

Evaluates your SQL fluency and practical experience with specific database systems.

sqlCriteo
Live SQL Coding ChallengeHard

Assesses your real-time SQL problem-solving and debugging under time pressure.

coding challengesqlCriteo
SQL for Regional TrendsHard
Practice
Practice drill

Combine Criteo operational and revenue data to report monthly regional performance, trends, and revenue outliers.

Date FunctionsJoinsGroup ByCriteo
Handling Missing DataEasy
Practice
Practice drill

Replace missing sales fields with defined defaults and return a consistently ordered dataset.

missing valuesdata cleaningnull handlingUniversity of MinnesotaThe Home DepotNationwide
Pre vs Post Launch SQLMedium
Practice
Practice drill

Compare monthly campaign performance before and after launch using date grouping, conditional phases, and month-over-month window calculations.

Window FunctionsLag/LeadDate FunctionsCriteo
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership18 questions · ~144 min
More Behavioral & Leadership questions with a free account
3
More topics5 questions · ~40 min
Analyze Results of UX A/B TestMedium

Explain how you would design and analyze a UX A/B test, from hypothesis and power to guardrails and launch decision.

ExperimentationStatistical SignificanceA/B TestingCriteo
Explain a CEO Efficiency Improvement CaseHard

Evaluates your case-study thinking, clarifying questions, and data-driven reasoning.

case studyefficiencyCriteo
Analyze a TrendlineHard

Evaluates your ability to interpret trends and draw defensible conclusions from data.

Data AnalysisCriteo
Using Data to Fix Campaign PerformanceMedium

Tests your ability to translate analytics into actionable insights for Criteo clients.

client managementData Analysiscampaign performanceCriteo
Guesstimate Airline RevenueHard

Assesses structured estimation, assumptions, and reasoning when data is incomplete.

EstimationCriteo

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 32 questions plus 3 hands-on drills to finish this plan.