Top 15
Company roadmap
Updated weekly · Last refresh Aug 13

Search Intelligence Interview Questions

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

15questions
~2htotal time
Track your progressSign up free to work through all 15 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 12 questions + 3 drills · ~126 min
Cleaning Data for Pivot TablesMedium

Tests your approach to data cleaning, structuring, and preparing datasets for pivot-based analysis.

data cleaningSearch Intelligence
Handling Missing or Inconsistent DataMedium

Tests your data quality methods for handling nulls, inconsistencies, and downstream analysis impact.

data cleaningdata integritySearch Intelligence
Merging Sheets with LookupsMedium

Assesses your ability to join spreadsheet data using lookup functions and manage common pitfalls.

excel functionsSearch Intelligence
Building an Auto-Updating DashboardMedium

Assesses your dashboard design skills for maintaining freshness and reliability as Search Intelligence data grows.

excel functionsdata visualizationSearch Intelligence
Spotting Anomalies with Conditional FormattingMedium

Evaluates how you use visual rules to detect outliers and communicate data quality issues.

ExcelSearch Intelligence
Normalize Customer Addresses by RegionMedium
Practice
Practice drill

Standardize inconsistent addresses using joins, CTEs, and CASE logic to map each record to a normalized region.

data cleaningData WranglingExcelTelus Digital
Top Users by Recent Transaction VolumeMedium
Practice
Practice drill

Find the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.

Data Analysisquery optimizationsqlTTier 1 BankRevolutCurrent (NY)
Monthly Retention Cohort AnalysisMedium
Practice
Practice drill

Build monthly signup cohorts with CTEs and joins to calculate month 0-2 retention for a self-serve product.

Data Analysisuser retentionCohort AnalysisOpenAIBILLRed Ventures
More SQL & Data Manipulation questions with a free account
2
More topics3 questions · ~24 min
Average Speed With Different LegsMedium

Tests understanding of average speed versus average of speeds in a two-leg scenario.

Search Intelligence
Estimating Median Age in OxfordMedium

Evaluates statistical estimation approach and use of credible sources.

EstimationreasoningSearch Intelligence
Documenting Formulas for AuditMedium

Tests your clarity and rigor in documenting analysis logic for review and accountability.

CommunicationdocumentationSearch Intelligence

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 15 questions plus 3 hands-on drills to finish this plan.