Snowflake Data Scientist Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Contrast FCF vs NI; choose one statement
An asset-heavy company reports rising net income while free cash flow (FCF) is negative for three straight quarters. a) Explain when and why FCF can b...
Lead innovation and automate a critical process
Describe a specific project where you led an end-to-end innovation from idea to production. Be concrete: - What was the problem, constraints, and succ...
Design an analytic warehouse for event data
Design a warehouse-ready analytics data model and ingestion plan to support cohort retention, ARPU, and product-case analyses at scale (50M events/day...
Present an end-to-end project and defend decisions
End-to-End Project Presentation + Deep-Dive Follow-ups Instructions (10 minutes, max 5 slides) Present an end-to-end project you led that shipped to r...
Solve and optimize 3Sum and variants at scale
Implement a function that returns all unique triplets (i, j, k) of indices whose values sum to a target T, with strong performance and deduplication g...
Decide and justify product metrics amid trade-offs
Smart Sort Feed Ranking: Metrics, Experiment, Decisions, and Monitoring Context: You are introducing a new Smart Sort ranking for a content feed. It s...
Build a cohort dashboard with Streamlit and SQL
You are given three tables and asked to build a minimal Streamlit app that helps a PM explore weekly cohort retention and ARPU by country. Assume SQL ...
Describe navigating ambiguous, repetitive questioning
Behavioral: Handling Repeated, "Fishing" Questions Context: You're a Data Scientist in a technical screen or stakeholder review. The other person keep...
Design an A/B test for ML model launch
Feed Ranker A/B Test Design and Powering You are replacing the current ranker with a new model in a feed. Baseline CTR is 2.0%. You expect a +5% relat...
Design and validate a cost-sensitive classifier
Binary Purchase Prediction with Delayed Labels and Imbalanced Classes Context - Goal: Ship a real-time binary classifier that predicts whether a user ...
Query seven-day conversion with windows and dedupe
Assume all timestamps are UTC. Treat "today" as 2025-09-01. Define "last 7 days" as the inclusive window [2025-08-26 00:00:00, 2025-09-01 23:59:59]. S...
Derive uniform RNGs from limited or biased sources
Sampling Construction and Analysis: From rand5() to rand7(), General randM()→randN(), and Fairness from a Biased Source You have access to a uniform p...
Implement DFS with cycle detection and topo order
Implement DFS (recursive and iterative) with topo sort, cycle detection, and timestamps You are given a directed graph G with N nodes labeled 1..N and...