Top 28
Prep plan
Updated weekly · Last refresh Oct 17

Arcadis Data Analyst Interview Questions

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

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

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

Window FunctionsSubqueriesJoinsArcadis
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
Handling Missing DataMedium
Practice
Practice drill

Standardize missing observation fields with fallback values, missingness flags, and ordered output.

Window Functionsmissing valuesdata cleaningEversource EnergyCincinnati Children's HospitalAdtalem Global Education
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
Debugging SQL QueriesMedium
Practice
Practice drill

Use PostgreSQL query execution and validation data to identify failed queries and suspicious result checks.

SubqueriesJoinsData WranglingScopely
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership19 questions · ~157 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 28 questions plus 3 hands-on drills to finish this plan.