Top 23
Prep plan
Updated weekly · Last refresh Aug 30

Lumen Data Analyst Interview Questions

The questions to prepare for a Lumen Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

23questions
~3htotal time
Track your progressSign up free to work through all 23 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 3 drills · ~63 min
Deriving Insights From Messy DataMedium

Tests data wrangling skills and ability to produce reliable insights from imperfect inputs.

SQL & Data ManipulationData WranglingCTEsLumen
Writing Complex SQLMedium

Tests SQL proficiency, query design, and ability to handle non-trivial data retrieval.

Window FunctionsJoinsAggregationsLumen
Handling Missing DataEasy

Tests practical data cleaning decisions and impact on downstream analysis quality.

Data WranglingCase WhenAggregationsLumen
Analyze Customer Purchase Trends with Window FunctionsEasy
Practice
Practice drill

Calculate the monthly spending trends for customers using window functions and joins.

The Home DepotAvisoWorld Wide Technology
Top Daily Rides by VehicleMedium
Practice
Practice drill

Rank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.

Window FunctionsJoinsData WranglingWaymo
Deduplicate Out-of-Order Replication EventsMedium
Practice
Practice drill

Use ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.

Window FunctionsSubqueriesJoinsReplitQuantcast
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership14 questions · ~114 min
More Behavioral & Leadership questions with a free account
3
More topics5 questions · ~41 min
Checking Analysis Accuracy StatisticallyEasy

Explain how to validate analysis accuracy using sampling checks, bias review, confidence intervals, and statistical testing.

Confidence IntervalsHypothesis TestingData WranglingLumen
Choosing KPIs for InitiativesEasy

Tests KPI selection and alignment of metrics to business outcomes at Lumen.

KPIsMetricsLeading IndicatorsLumen
Developing a New Data ModelHard

Tests data modeling rigor, requirements gathering, and design tradeoffs for analytics.

ETLData ModelingPipelinesLumen
Responding to Contradicting DataMedium

Tests statistical thinking, hypothesis testing mindset, and how you adjust conclusions.

Hypothesis TestingCausal InferenceLumen
Analyzing Customer Satisfaction DataMedium

Tests end-to-end analytical approach for customer metrics and practical insight generation.

NPSMetricsDiagnosisLumen

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