Dataford
Top 50
Company roadmap
Updated weekly · Last refresh Aug 30

Stantec Interview Questions

The questions to prepare for Stantec interviews, across all roles. Questions from real interview reports rank first. Updated weekly.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 7 questions · ~62 min
Design an LRU CacheEasy
Practice
Recently asked

Implement an LRU cache in O(1) average time using a hash table and doubly linked list.

Hash TablesQueueLinked ListsStantec
More Coding questions with a free account
2
Pipelines4 questions · ~35 min
Data Quality in ETL PipelinesEasy
Recently asked

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityStantec
More Pipelines 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
Execution16 questions · ~141 min
Balancing Speed Quality and ScopeHard

Describe a time you had to choose between speed, quality, and scope, and how you aligned stakeholders around the trade-off.

Trade-offsRisk AssessmentScope ManagementStantec
More Execution questions with a free account
4
Metrics4 questions · ~35 min
Define Success for a ProjectEasy

Define what success means for a project using clear KPIs, a north star, and supporting metrics.

KPIsSuccess CriteriaDiagnosisStantec
More Metrics questions with a free account
5
Strategy5 questions · ~44 min
Tell Me About YourselfEasy

Tests your ability to deliver a clear, relevant introduction tailored to the role at Aqr.

Competitive AnalysisGo-to-MarketStantec
More Strategy questions with a free account
6
A/B Testing & Experimentation3 questions · ~27 min
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
7
More topics11 questions · ~97 min
Translating Requirements into ArchitectureHard
Recently asked

Tests your ability to convert requirements into an actionable architecture and delivery approach.

solution designarchitecturerequirementsStantec
Database Management Systems ExperienceMedium

Tests practical understanding of data storage, querying, and operational considerations.

database managementsqlStantec
More questions with a free account
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
Contact Center Agent Performance MetricsHard
Practice
Practice drill

Compute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.

ETLAggregationsData ModelingADP
Handle Missing Financial Input ValuesMedium
Practice
Practice drill

Use joins, CTEs, and CASE logic to flag and fill missing financial fields for Qlik planning records.

Data WranglingETLQualityQlik
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.