Snowflake Data Analyst candidates report SQL-heavy screens, business-case queries, hiring manager conversations and, in one longer loop, later stakeholder rounds. Several describe slow or silent follow-up.
$110K
Avg. Base Comp
$145K
Avg. Total Comp
Not reported
Typical Rounds
3 months
Process Length
Snowflake Data Analyst interviews, as candidates describe them, revolve around SQL written against the clock. Two candidates described five SQL questions in about 45 minutes, and one said that window also had to fit introductions and Q&A. Practice writing correct queries quickly rather than only talking through an approach.
The questions leaned toward business problems. One candidate was asked to calculate month-over-month revenue change across 12 months, which points to window functions and time-series aggregation. A candidate who spoke with a hiring manager got an org-chart question: given manager and direct-report tables, count everyone under a director including nested levels, which calls for recursive thinking. A Data Analyst/BI Engineer candidate described a separate second SQL round built around one case-style question that tested analytical thinking more than syntax.
Beyond SQL, loops differ by team. That BI Engineer candidate, interviewing in Pune, went on to functional manager, hiring manager, finance BI leadership, in-person and HR rounds, with situational questions such as handling a difficult manager. An HRIS Analyst candidate was asked to walk through reports and dashboards they had built and then received a take-home assignment. Another candidate was told by a recruiter about an "Insight and Creative Problem Solving" round involving presenting insights, but never learned the format, so ask about it early.
Communication was a recurring frustration. Some candidates waited weeks or never heard back, and one described a process of roughly three months. Confirm next steps and timelines in writing where you can.
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 | |
| Cumulative Sales By Product | |
| Average Unique Counts | |
| Log Anomaly Detection Model | |
| Sample Time Series | |
| D2C Socks e-Commerce | |
| Blob Indexing | |
| Shortest Path Algorithms | |
| Client Solution Pushback | |
| Reddit-like Notifications | |
| Empty Neighborhoods | |
| Closest SAT Scores | |
| Rolling Bank Transactions | |
| Customer Orders | |
| Top Three Salaries | |
| First to Six | |
| Monthly Customer Report | |
| Experiment Validity | |
| Download Facts | |
| First Touch Attribution | |
| Button AB Test | |
| Compute Deviation | |
| Largest Salary by Department | |
| Subscription Overlap | |
| Employee Salaries (ETL Error) | |
| Prime to N | |
| Lowest Paid |
Synthesized from candidate reports. Individual experiences may vary.
One candidate described a standard recruiter call that explained the role and checked their background. Another dealt only with a manager and was repeatedly asked for new availability because of delays on the company side. A BI-role candidate said compensation became a factor late, so clarify expectations early.
Three candidates reported five SQL questions in a SQL-focused session, and two of them described about 45 minutes, including introductions and Q&A. One of these candidates said the questions were business-case oriented, such as month-over-month revenue change over 12 months. Practice window functions and time-series aggregation at speed.
A BI Engineer candidate described a second SQL round with one case-style question, then a hiring manager round with situational and behavioral questions. An Analyst candidate was asked an org-hierarchy SQL question by a hiring manager. An HRIS Analyst candidate was asked about scenarios and the reports and dashboards they had built.
The BI Engineer candidate reported a finance BI leadership round, an in-person Pune stakeholder and culture round, an HR compensation round and a reference check. An HRIS Analyst candidate received a take-home assignment. One candidate was told of an Insight and Creative Problem Solving round. These stages may not apply to every loop.
