Top 24
Prep plan
Updated weekly · Last refresh Aug 30

The E.W. Scripps Data Engineer Interview Questions

The questions to prepare for a The E.W. Scripps Data Engineer interview. Questions from real interview reports rank first. Updated weekly.

24questions
~4htotal time
Track your progressSign up free to work through all 24 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 1 drill · ~47 min
Top Product Revenue Last 30 DaysMedium
Practice

Use joins, a CTE, and aggregation to rank the top 5 products by non-returned revenue in the last 30 days.

Date FunctionsJoinsAggregationsThe E.W. Scripps
Top Products by Sales RevenueEasy
Practice

Find the top 10 products by total sales revenue using joins, aggregation, and a CTE.

RankingGroup ByAggregationsThe E.W. Scripps
Optimizing Slow-Running QueriesMedium

Tests query tuning skills and performance troubleshooting for production analytics.

Window FunctionsJoinsAggregationsThe E.W. Scripps
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
More SQL & Data Manipulation questions with a free account
2
Pipelines14 questions · ~128 min
Structured vs Unstructured Pipeline DataEasy

Explain how structured and unstructured data differ, and how that changes pipeline design and downstream modeling.

InfrastructureData ModelingQualityThe E.W. Scripps
Debugging Production Data PipelinesMedium

A structured approach to debugging production data pipelines, with focus on orchestration, data quality, idempotency, and safe backfills.

InfrastructureToolsQualityThe E.W. Scripps
Container Orchestration for PipelinesEasy

Discuss preferred container orchestration tools for running pipelines, and explain the trade-offs behind the choice.

InfrastructureToolsOrchestrationThe E.W. Scripps
More Pipelines 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
3
Coding6 questions · ~55 min
Deduplicating Records FunctionMedium

Tests algorithmic thinking and practical handling of duplicates for reliable datasets.

Hash TablesArraysSortingThe E.W. Scripps
Time Complexity ExplanationEasy

Tests your ability to reason about algorithmic efficiency and performance implications.

Hash TablesSearchingSortingThe E.W. Scripps
More Coding questions with a free account
The finish line: interview-readyComplete all 24 questions plus 1 hands-on drill to finish this plan.