Bmo Harris Bank Data Analyst candidates report a two-round process centered on HR or recorded behavioral screening, basic SQL, Power BI experience, and communication with customers or cross-functional partners.
$97K
Avg. Base Comp
$123K
Avg. Total Comp
2 rounds
Typical Rounds
Not reported
Process Length
Bmo Harris Bank Data Analyst interviews reported here emphasize practical fluency and communication more than deep analytics theory. Candidates describe HR or recorded behavioral screening followed by a live manager conversation or timed assessment. Prepare clear, concrete examples from your Power BI work and other tools, because interviewers asked candidates to explain projects rather than solve advanced analytics problems.
SQL is the most consistent technical theme. Reported questions covered joining tables, inner versus outer joins, and using HAVING. One intern candidate also completed a 75-minute HackerRank with a coding task, a database task, and 11 multiple-choice questions, so applicants may benefit from practicing paced SQL and coding fundamentals as well as spoken explanations.
Behavioral preparation should focus on motivation, challenging situations, difficult customers, conflict, and cross-functional pushback. One candidate described the later interview as friendly and fit-focused; another was told the team valued responsiveness beyond standard hours. Ask thoughtful questions about collaboration and work expectations while assessing whether the role matches your own preferences. The reported sample is small and spans analyst levels, so the assessment format may vary by opening.
Synthesized from 3 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 Bmo Harris Bank process.
The process was pretty straightforward, but a little odd in how much of it was automated. My first round was a HireVue behavioral interview, and it was all recorded rather than live. The questions were non-technical, and I remember being asked why I was interested in the position and to describe a challenging situation I had faced. You get one reattempt for each recorded answer, and the whole thing took about 60 to 90 minutes. After that came a HackerRank assessment that was timed for 75 minutes and included one coding challenge, one database challenge, and 11 multiple-choice questions. That part felt more like a screening test than a full interview, so I made sure to pace myself and not spend too long on any single question.
Prep tip from this candidate
Be ready for a recorded behavioral HireVue with standard motivation and challenge questions, then a timed HackerRank that combines one coding task, one database task, and multiple-choice questions. Since the process seems to move from automated screening into a technical round, it’s worth practicing concise video answers and doing a few timed SQL/coding drills before you start.
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 Bmo Harris Bank
How would we build a model to detect fraud and text customers to approve or deny fraudulent transactions
| Question | |
|---|---|
| Bagging vs Boosting | |
| Google Maps Improvement | |
| Hurdles In Data Projects | |
| Data Preparation for Imbalanced Data | |
| Overfit Avoidance | |
| Image Classification Pipeline | |
| Client Solution Pushback | |
| Check Normality | |
| Time Series Discrepancies | |
| 2nd Highest Salary | |
| Empty Neighborhoods | |
| Rolling Bank Transactions | |
| Employee Salaries | |
| Comments Histogram | |
| Closest SAT Scores | |
| Top Three Salaries | |
| Monthly Customer Report | |
| Slacking Employees Salaries | |
| Experiment Validity | |
| Find the Missing Number | |
| Compute Deviation | |
| Subscription Overlap | |
| Prime to N | |
| 500 Cards | |
| Session Difference | |
| Last Transaction | |
| Department Expenses | |
| Maximum Profit | |
| Rain in N Days |
Synthesized from candidate reports. Individual experiences may vary.
Candidates report an HR phone screen or recorded HireVue as an initial step. Topics included background, resume experience, interest in the role, a challenging situation, and general fit. The HireVue report described recorded answers with one reattempt per question.
One Data Analyst Intern candidate reported a 75-minute HackerRank containing one coding challenge, one database challenge, and 11 multiple-choice questions. This appears specific to that internship process, so other Data Analyst openings may instead move directly to a live interview.
Candidates report a live conversation with a hiring manager, sometimes alongside another manager. Questions mixed behavioral discussion with practical SQL, including table joins, inner versus outer joins, and HAVING, plus experience using Power BI and other applications.
