Ernst & Young U.S. LLP Data Analyst Interview Questions
The questions to prepare for a Ernst & Young U.S. LLP Data Analyst interview. Questions from real interview reports rank first. Updated daily.
Explain what CTEs are and their advantages in SQL queries.
Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.
Tests your SQL knowledge of filtering and joining logic using subqueries.
Tests performance troubleshooting, query optimization techniques, and data-aware decision making.
Find the second-highest distinct non-NULL salary using PostgreSQL window-function logic.
Tests your approach to null handling and join logic to ensure correct results.
Find missing employee numbers in a fixed sequence using PostgreSQL generate_series and a left join.
Flatten divisions, teams, and members into ordered tabular rows while preserving empty hierarchy levels.
CoalitionSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests integrity in execution: whether you uphold standards under pressure, communicate transparently, and take ownership for the outcome.
Tests communication of complex analytics to nontechnical stakeholders, with emphasis on influence, clarity, and driving action from insights.