Clickhouse Data Scientist Interview Questions
The questions to prepare for a Clickhouse Data Scientist interview. Questions from real interview reports rank first. Updated weekly.
Tests your SQL window function skills and ability to express rolling aggregations efficiently.
ClickhouseRank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.
WaymoUse joins, CASE WHEN, and date filtering to compare outcome rates before and after a decision.
HarbourVest PartnersUse ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.
Replit
QuantcastTests your statistical testing approach for measuring impact and controlling false positives.
ClickhouseDiagnose why conversion fell from 4.8% to 3.1% after a launch by breaking the metric across funnel steps, cohorts, and segments.
ClickhouseDesign an end-to-end A/B test for a pricing page, including MDE, guardrails, analysis plan, and a ship decision.
ClickhouseTests your product analytics thinking and ability to connect metrics to user outcomes.
ClickhouseTests your evaluation methodology, metrics selection, and validation practices.
ClickhouseExplain common online experimentation pitfalls and how to design, analyze, and decide in ways that avoid false wins.
ClickhouseSign up to see every question
Create a free account to unlock this list and practice real interview questions.