Top 30
Prep plan
Updated weekly · Last refresh Aug 30

Arcadis Data Analyst Interview Questions

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

30questions
~4htotal time
Track your progressSign up free to work through all 30 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 3 drills · ~63 min
Data Cleaning and Preparation ApproachMedium

Tests practical data quality handling and readiness for reliable analytics.

Data WranglingCTEsArcadis
SQL Query for Targeted ExtractionMedium

Tests SQL fundamentals for selecting, filtering, and retrieving relevant data.

JoinsData WranglingAggregationsArcadis
Optimize a Slow QueryHard

Tests performance tuning skills including indexing, query plans, and efficient SQL patterns.

Window FunctionsSubqueriesJoinsArcadis
SQL Rolling Average and RankingHard
Practice
Practice drill

Use CTEs and window functions to calculate 7-day transaction averages and rank Loft users within each region.

Window FunctionsRankingRunning TotalsLoftArcadisCgi Nederland
Deduplicate Out-of-Order Replication EventsMedium
Practice
Practice drill

Use ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.

Window FunctionsSubqueriesJoinsReplitQuantcast
Top Customers by Net SalesMedium
Practice
Practice drill

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

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership21 questions · ~174 min
More Behavioral & Leadership questions with a free account
3
More topics5 questions · ~41 min
Design Test for New FeatureMedium

Design an A/B test for a new platform feature, including success metrics, power, guardrails, and a clear ship decision.

experiment designfeature evaluationA/B TestingArcadis
Applied Statistical Techniques in PracticeEasy

Discuss statistical techniques you know and show how you have applied them to real product or customer analysis problems.

Confidence IntervalsRegressionHypothesis TestingArcadis
Diagnose a Customer Satisfaction DropMedium

Investigate a sudden drop in customer satisfaction and separate leading signals from the final NPS readout.

NPSLeading IndicatorsDiagnosisArcadis
Checking Analysis Accuracy StatisticallyEasy

Explain how to validate analysis accuracy using sampling checks, bias review, confidence intervals, and statistical testing.

Confidence IntervalsHypothesis TestingData WranglingArcadis
Metrics for Sustainability Initiative SuccessMedium

Tests ability to define measurable outcomes aligned to sustainability goals and project delivery.

North Star MetricKPIsDiagnosisArcadis

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