Top 50
Company roadmap
Updated weekly · Last refresh Oct 17
D

data consultancy Interview Questions

The questions to prepare for data consultancy interviews, across all roles. Questions from real interview reports rank first. Updated daily.

50questions
~8htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 4 questions · ~40 min
2
SQL & Data Manipulation4 questions · ~40 min
SQL Query OptimizationMedium
Practice

Optimize a slow PostgreSQL query that aggregates completed transactions while preserving customers with no matching activity.

Performance Tuningdatabase optimizationindexesddata consultancy
More SQL & Data Manipulation 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
Pipelines4 questions · ~40 min
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityddata consultancy
More Pipelines questions with a free account
4
Machine Learning3 questions · ~30 min
Supervised vs Unsupervised LearningEasy

Explain how supervised and unsupervised learning differ, and ground the distinction in a practical ML example.

Unsupervised LearningFeature EngineeringBias-Variance Tradeoffddata consultancy
More Machine Learning questions with a free account
5
Execution4 questions · ~40 min
Handle Scope Creep Mid-ProjectMedium

Explain how you would manage scope creep without damaging stakeholder trust or putting delivery at risk.

Trade-offsRisk AssessmentScope Managementddata consultancy
More Execution questions with a free account
6
Metrics4 questions · ~40 min
Define Success Metrics for FeaturesMedium

Set a clear north star, supporting KPIs, leading indicators, and guardrails for a new product feature.

North Star MetricLagging IndicatorsKPIsddata consultancy
More Metrics questions with a free account
7
More topics27 questions · ~267 min
Prioritize Features for AI ProductsMedium

A framework for prioritizing AI product features based on user value, feasibility, evaluation quality, and trade-offs.

Feature PrioritizationValue Propositionddata consultancy
Common Pitfalls in Experiment ResultsHard

Identify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.

PeekingNovelty EffectSample Ratio Mismatchddata consultancy
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.