Top 12
Prep plan
Updated weekly · Last refresh Oct 17
W

Westpac Group Data Scientist Interview Questions

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

12questions
~2htotal time
Track your progressSign up free to work through all 12 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 1 drill · ~40 min
Rolling 30-Day Transaction AverageMedium
Practice

Calculate each user's rolling 30-day average transaction volume using PostgreSQL window functions.

Window FunctionsDate FunctionsData ManipulationWWestpac Group
Join Types and SemanticsMedium
Practice

Demonstrate how INNER JOIN and LEFT JOIN differ when matching customers to account records.

null handlingJoinssqlWWestpac Group
Optimizing Large Analytical SQL QueriesHard

Explain how to diagnose and optimize a slow analytical query on a multi-terabyte event table using SQL-aware tuning strategies.

JoinsData WranglingCTEsWWestpac Group
SQL and Programming Interview MixMedium
Practice
Practice drill

Approach a mixed interview round while summarizing completed activity with a CTE, aggregation, and left join.

JoinsCTEssqlWise
2
Behavioral & Leadership4 questions · ~40 min
More Behavioral & Leadership questions with a free account
3
More topics5 questions · ~50 min
Diagnosing a 10% Metric DropHard

Build a systematic process to validate, decompose, and explain a sudden 10% drop in core engagement.

root cause analysisDiagnosisdiagnostic processWWestpac Group
Risks of Peeking in Ride-Share TestMedium

Assess why checking experiment results early can inflate false positives and distort ship decisions.

PeekingExperimentationStatistical SignificanceWWestpac Group
Balance Conversion and RetentionHard

Framework for deciding when to favor short-term conversion gains versus long-term retention in a product decision.

Feature PrioritizationUser NeedsValue PropositionWWestpac Group
Mitigating Experimentation PitfallsHard

Identify major online experimentation pitfalls and explain practical mitigations for SRM, network effects, peeking, and novelty.

experiment designNetwork InterferenceNetwork EffectsWWestpac Group
Define Metrics for New FeaturesMedium

Define a success metric for a new feature that captures real user value, not just raw usage.

MetricsFeature Prioritizationuser valueWWestpac Group

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 12 questions plus 1 hands-on drill to finish this plan.