Two Business Analyst candidates describe a recruiter screen, a hiring manager conversation and a final panel, with a SQL test and case study in one report. Questions drew on resume experience such as UAT and deal management.
$128K
Avg. Base Comp
$168K
Avg. Total Comp
5 rounds
Typical Rounds
2 weeks
Process Length
Two Business Analyst candidates describe their Snowflake loops, and both start the same way: a recruiter screen, followed by a hiring manager conversation. One candidate describes the recruiter call as a routine phone conversation about background and experience. After those first steps, the reports diverge, so prepare for some variation.
One candidate reports five rounds in about two weeks: recruiter screen, hiring manager conversation, a SQL test, a round combining behavioral questions with a case study, and a final culture-fit round. The questions came from the resume. The hiring manager asked about their greatest accomplishment, and later interviewers asked about deal management, stakeholder relationships and CPQ. This candidate describes the case study as collaborative, with the interviewer focused on how they thought through problems, so walk through your reasoning step by step instead of jumping to an answer.
The other candidate's hiring manager focused on user acceptance testing (UAT), followed by three separate 30-minute panel sessions. One panelist, a Sr. Order Management Analyst, asked about processing transactions and questioned the move from a Senior Specialist role to an Analyst role. Be ready with a clear reason for that kind of career move, and bring specific examples of UAT you have led. This candidate also describes long gaps between rounds and had to chase updates, so confirm next steps at the end of each conversation.
Both reports ended in a rejection.
Synthesized from 5 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 Snowflake 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 Snowflake
Select the 2nd highest salary in the engineering department
| Question | |
|---|---|
| Comments Histogram | |
| Random SQL Sample | |
| Marketing Channel Metrics | |
| Feature Store Integration | |
| Cumulative Sales By Product | |
| Sample Time Series | |
| Average Unique Counts | |
| D2C Socks e-Commerce | |
| Minimum Days for Scheduling All Meetings | |
| Client Solution Pushback | |
| Reddit-like Notifications | |
| Empty Neighborhoods | |
| Customer Orders | |
| Button AB Test | |
| Closest SAT Scores | |
| Subscription Overlap | |
| Employee Salaries (ETL Error) | |
| Rolling Bank Transactions | |
| Top Three Salaries | |
| Prime to N | |
| Minimum Change | |
| 500 Cards | |
| Upsell Transactions | |
| Top 3 Users | |
| Find the Missing Number | |
| Month Over Month | |
| Scrambled Tickets | |
| Longest Streak Users | |
| Bagging vs Boosting |
Synthesized from candidate reports. Individual experiences may vary.
Both candidates started with a recruiter screen. One described it as a routine phone call about their background and experience. Be ready to summarize your resume concisely. That same candidate's recruiter left the company mid-process, and they had to contact a recruiting coordinator to get reconnected, so confirm who your point of contact is.
Both candidates met a hiring manager. One was asked about their greatest accomplishment. The other was asked mainly about UAT experience on Zoom, and that hiring manager gave next steps within a few days. Prepare concrete examples from your resume.
One candidate describes a SQL test, then a round that combined behavioral questions with a case study. They found the case study collaborative, with the interviewer focused on how they thought through the problem. Practice explaining your approach out loud as you work through data questions.
One candidate had a final culture-fit round with a mix of interviewers, with questions on deal management, stakeholder relationships and CPQ. The other had three separate 30-minute panel sessions, one onsite and two on Zoom, including questions on processing transactions and on moving from Senior Specialist to Analyst. Expect waits between steps.
