Dataford
Top 19
Prep plan
Updated weekly · Last refresh Aug 30

Edward Jones Data Engineer Interview Questions

The questions to prepare for a Edward Jones Data Engineer interview. Questions from real interview reports rank first. Updated weekly.

19questions
~3htotal time
Track your progressSign up free to work through all 19 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 3 drills · ~70 min
Clustered vs Non-Clustered IndexesMedium

Explain how clustered and non-clustered indexes differ in storage, lookup behavior, and query performance.

JoinsData WranglingEdward Jones
Deduplicate Transaction DataMedium

Tests SQL skills for duplicate detection and safe deduplication logic.

deduplicationdata integrityEdward Jones
Slowly Changing DimensionsMedium

Tests your approach to SCD strategies and maintaining historical accuracy.

slowly changing dimensionsdata warehouseData ModelingEdward Jones
Use Window FunctionsMedium

Tests SQL proficiency with window functions and correct partitioning and ordering.

Window FunctionsRankingRunning TotalsEdward Jones
Dimensional Modeling for FinanceMedium

Tests your dimensional modeling choices for accurate, analysis-ready financial reporting.

snowflake schemastar schemaEdward Jones
Rank Top Advisors by RegionMedium
Practice
Practice drill

Use a left join, aggregation, and ROW_NUMBER to find the top three Edward Jones advisors in each region.

JoinsRankingAggregationsEdward Jones
Top Customers by Region VolumeMedium
Practice
Practice drill

Find the top 3 customers in each region by transaction volume using joins, aggregation, and window ranking.

Window FunctionsJoinsRankingJPMorganChaseSilicon Valley BankNavi
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

Sign up to see every question

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

Get my prep plan
2
Behavioral & Leadership14 questions · ~112 min
Prioritizing Conflicting Cross-Functional DeadlinesMedium

Tests prioritization under pressure, stakeholder management, and decision-making when multiple teams compete for limited analyst capacity.

Conflict Resolutiontime managementPrioritizationEdward Jones
Handling Architectural Disagreement Cross-FunctionallyMedium

Tests conflict resolution and influence without authority when a cross-functional stakeholder challenges an architectural decision.

Influence Without AuthorityConflict ResolutionCommunicationEdward Jones
Owning a Pipeline Performance BottleneckMedium

Tests ownership and prioritization when a SQL bottleneck threatens pipeline reliability, including stakeholder communication and follow-through.

Performance TuningsqlbottlenecksEdward Jones
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 19 questions plus 3 hands-on drills to finish this plan.