Dataford
Top 35
Company roadmap
Updated weekly · Last refresh Aug 30

Themis Insight Interview Questions

The questions to prepare for Themis Insight interviews, across all roles. Questions from real interview reports rank first. Updated weekly.

35questions
~5htotal time
Track your progressSign up free to work through all 35 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 4 questions · ~32 min
Secure Terraform State ManagementMedium

Approach for securing Terraform state across teams, environments, and automated deployment pipelines.

InfrastructureDependenciesQualityThemis Insight
More Pipelines questions with a free account
2
SQL & Data Manipulation3 questions + 3 drills · ~54 min
Handling Missing and Dirty SQL DataMedium

Explain how to profile, clean, and standardize missing or dirty data before analysis.

Data WranglingCase WhenQualityThemis Insight
Understanding Common Table Expressions (CTEs)Medium

Explain what CTEs are and their advantages in SQL queries.

CTEsThemis Insight
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
Normalize Messy CRM Contact DataHard
Practice
Practice drill

Clean inconsistent CRM contacts by joining source tables, standardizing values, and flagging bad records.

Data WranglingCase WhenQualityAlphaSense
Validate Monthly Revenue Data QualityHard
Practice
Practice drill

Use joins, a CTE, and CASE logic to flag messy monthly order data and produce cleaned revenue by month.

Data WranglingCase WhenQualityLiterati
More SQL & Data Manipulation questions with a free account
3
Security & Infrastructure7 questions · ~56 min
Technology vs Infrastructure Trade-offsMedium

Assesses your decision-making framework for balancing risk, cost, and operational impact.

Decision MakingThemis Insight
More Security & Infrastructure questions with a free account
4
Behavioral & Leadership16 questions · ~128 min
More Behavioral & Leadership questions with a free account
5
More topics5 questions · ~40 min
Common Pitfalls in Experiment ResultsHard

Identify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.

PeekingNovelty EffectSample Ratio MismatchThemis Insight
First Checks for Metric DropsEasy

Outline the first checks to diagnose a sudden drop in a core product metric, starting with data quality, scope, and decomposition.

Lagging IndicatorsLeading IndicatorsDiagnosisThemis Insight
Define Launch Success MetricsMedium

Approach for choosing launch success metrics, including a north star, leading indicators, and clear success criteria.

Product-Market FitUser NeedsKPIThemis Insight
Kubernetes High AvailabilityHard

Tests Kubernetes architecture skills for HA and fault tolerance in critical ingestion workloads.

kuberneteshigh availabilityfault toleranceThemis Insight
More questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 35 questions plus 3 hands-on drills to finish this plan.