Thumbtack Data Analyst Interview Questions
The questions to prepare for a Thumbtack Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.
Tests SQL window functions for deduplication and data quality in marketplace logs.
Calculate six-month Thumbtack professional retention using CTEs, date filtering, joins, and cohort aggregation.
Calculate cohort month-over-month retention for Thumbtack service professionals using CTEs, date truncation, joins, and aggregation.
Calculate a three-day moving average of active-client revenue using aggregation and SQL window functions.
AArete
MITRE
GlassdoorTests structured troubleshooting using funnel metrics, segmentation, and data validation.
Tests metrics design and causal thinking to assess competitive impact on retention.
Assesses communication of statistics concepts and your approach to evaluating model performance.
Assesses ability to explain core statistics concepts clearly to non-technical stakeholders.
Design an A/B test for a new app-store ranking algorithm, including primary metrics, guardrails, sample size, and launch criteria.
Tests product sense and financial modeling tradeoffs for marketplace monetization changes.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.