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

Stantec Data Scientist Interview Questions

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

16questions
~2htotal time
Track your progressSign up free to work through all 16 questions and resume where you left off.
Start practicing free →
1
A/B Testing & ExperimentationStart here. 6 questions · ~53 min
A/B Test for Trading WorkflowMedium

Design an experiment for a new trading signal or workflow change, including metrics, power, randomization, and launch criteria.

experiment designGuardrail Metricsprimary metricsStantec
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 TestingStantec
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 MismatchStantec
More A/B Testing & Experimentation questions with a free account
2
Product Sense3 questions · ~26 min
Success Metric for Predictive MaintenanceMedium

Assesses ability to translate business reliability goals into measurable model success metrics.

Stantec
Water Initiative Effectiveness MetricMedium

Tests designing outcome metrics aligned to real-world environmental initiatives at Stantec.

product metricsStantec
More Product Sense questions with a free account
3
Behavioral & Leadership4 questions · ~35 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~26 min
Rolling Average with SQL Window FunctionsMedium
Practice

Use a PostgreSQL window function to calculate inclusive 30-day rolling sensor averages for active WSP monitoring assets.

Window FunctionssqlStantec
Diagnose a Dashboard Metric DropMedium

Tests structured debugging of metric changes using data, pipeline, and modeling checks.

root causeDiagnosisStantec
Diagnose Sensor Metric DropsMedium

Evaluates troubleshooting methodology for sensor-based metric regressions.

Data AnalysisDiagnosisStantec

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 2 drills · ~20 min
Top Users SQL QueryMedium
Practice
Practice drill

Count valid daily interactions and return the top three users using aggregation and deterministic ranking.

data cleaningDate FunctionsGroup By
SQL Window Functions Moving AverageMedium
Practice
Practice drill

Calculate a three-day moving average of active-client revenue using aggregation and SQL window functions.

Window FunctionsData AnalysissqlAAreteSShyena Tech YarnsEEvalueserve
The finish line: interview-readyComplete all 16 questions plus 2 hands-on drills to finish this plan.