Dataford
Dataford
Top 41
Prep plan
Updated weekly · Last refresh Oct 17

Ernst & Young Data Analyst Interview Questions

The questions to prepare for a Ernst & Young Data Analyst interview. Questions from real interview reports rank first. Updated daily.

41questions
~6htotal time
Track your progressSign up free to work through all 41 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 11 questions + 2 drills · ~111 min
SQL Clause DifferencesMedium
Recently asked

Tests your ability to write correct SQL and choose the right filtering approach for queries.

JoinssqlErnst & Young
INNER JOIN vs LEFT JOINEasy
Recently asked

Tests SQL join fundamentals and correct understanding of row inclusion logic.

sql basicsJoinsdatabase conceptsErnst & Young
CTE vs Subquery ChoiceMedium
Recently asked

Tests SQL structuring choices for readability, maintainability, and performance considerations.

SubqueriesCTEssqlErnst & Young
SQL Window Functions ExperienceMedium
Practice
Recently asked
Practice drill

Use SQL window functions to rank regions by average 2024 yield within each country.

Window FunctionsJoinsData ManipulationErnst & YoungKBRMaximus Tech
Optimize Large-Scale QueriesMedium
Practice
Recently asked
Practice drill

Optimize a PostgreSQL query over millions of event rows using selective predicates, indexing, joins, and latest-row selection.

Performance Tuningdatabase optimizationlarge datasetsOktaErnst & Young
More SQL & Data Manipulation questions with a free account
2
Statistics & Probability10 questions · ~83 min
Risk Assessment for Financial StrategyHard
Recently asked

Tests risk reasoning using statistical and financial concepts to evaluate strategy viability.

Risk AssessmentErnst & Young
Overfitting Mitigation ApproachMedium
Recently asked

Tests practical overfitting controls and validation methods used during modeling.

overfittingErnst & Young
More Statistics & Probability 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
Behavioral & Leadership17 questions · ~141 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~25 min
Data Cleaning with PythonMedium
Recently asked

Tests hands-on Python data cleaning skills and practical handling of messy datasets.

data cleaningData ManipulationpythonErnst & Young
Metrics for Backtest PerformanceMedium
Recently asked

Tests ability to choose appropriate performance metrics and interpret them for strategy assessment.

MetricsModel EvaluationErnst & Young
Evaluating Success of Business StrategyMedium
Recently asked

Tests KPI selection, measurement design, and linking analytics to business outcomes.

business strategysuccess metricsErnst & Young
The finish line: interview-readyComplete all 41 questions plus 2 hands-on drills to finish this plan.