Candidates describe Scotiabank's Data Analyst interviews as mostly behavioral and conversational, with light technical checks in Excel, SQL and Power BI, and little in the way of algorithm questions.
$58K
Avg. Base Comp
$70K
Avg. Total Comp
2-3 rounds
Typical Rounds
Not reported
Process Length
Candidates describe Scotiabank's Data Analyst interviews as more behavioral than technical. Several reports describe a casual opening, such as a coffee chat or hiring-manager call, sometimes with other candidates present. Questions there covered motivation, why Scotiabank and why this role, and walking through a resume. One candidate also got an off-beat personality question about what animal they would be.
The technical content reported is practical and fairly basic. One candidate who received an offer had a technical test covering SQL, Excel and Python, with heavy attention to SUMIF and VLOOKUP and no leetcode-style challenges. Their final round was a relaxed coffee chat with the hiring manager about a past project and how they would handle a data quality problem. Others reported high-level questions, such as how to clean a large dataset or how to join information from two tables, plus discussion of tools like Power BI.
Formats vary. Some candidates reported a phone screen covering background, tools and desired salary, followed by a manager interview. Another described a Teams interview with two managers, followed by assessments on technical knowledge and customer service. That candidate said the managers narrowed the role's scope late in the interview, so asking early which responsibilities are central may help.
Most reports here ended without an offer, and several mention little or no feedback afterward. Prepare specific stories about your data work and keep Excel functions like SUMIF and VLOOKUP sharp, along with SQL joins and basic Python. Practice talking through a data-cleaning approach step by step as well.
Synthesized from 10 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Scotiabank process.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Scotiabank
Select the 2nd highest salary in the engineering department
| Question | |
|---|---|
| Size of Joins | |
| Ride-Sharing App Schema | |
| Client Solution Pushback | |
| Swipe Payment API | |
| Why Do You Want to Work With Us | |
| Your Strengths and Weaknesses | |
| Dropbox Database | |
| Empty Neighborhoods | |
| Rolling Bank Transactions | |
| Employee Salaries | |
| Comments Histogram | |
| Top Three Salaries | |
| Closest SAT Scores | |
| Last Transaction | |
| Slacking Employees Salaries | |
| Find the Missing Number | |
| Monthly Customer Report | |
| Experiment Validity | |
| Payments Received | |
| Paired Products | |
| 500 Cards | |
| Department Expenses | |
| Total Spent on Products | |
| Get Top N Frequent Words | |
| Top 3 Users | |
| Maximum Profit | |
| Bagging vs Boosting | |
| Subscription Overlap | |
| Duplicate Rows |
Synthesized from candidate reports. Individual experiences may vary.
Candidates report an initial call that confirmed application details, background, tool experience such as Power BI, and in one case desired salary. Reports describe it as friendly and fairly quick, but not every candidate mentioned this step, so it may vary by team.
Several candidates describe a casual conversation with HR or the hiring manager, sometimes with other candidates present. Questions typically covered motivation, why Scotiabank, a resume walk-through and sometimes personality. Technical content, when present, stayed high-level, such as how to clean a large dataset or join two tables.
Reports differ. One candidate described a technical test covering SQL, Excel and Python with heavy focus on SUMIF and VLOOKUP. Another received post-interview assessments on technical knowledge and customer service. Expect practical rather than algorithmic checks.
One candidate who received an offer described a final coffee chat with the hiring manager about a past project, plus scenario questions on handling a data quality problem. Other candidates did not reach a final round, so this format rests on a single account.
