Ernst & Young LLP Data Engineer Interview Guide

The Ernst & Young LLP data engineer loop, round by round: what each stage tests, example questions with the guidance interviewers actually score, the mistakes that sink strong candidates, and how to prepare.

Last updated: July 31, 2026Proudly published by: Jeff Wahl

1 real Ernst & Young LLP interview questions

Reported by candidates from real loops, tagged by domain, round, level, and year. Expand for what the round is scoring.

SQLL5 · 2026

SQL TEST by a robot with nested (too many of them) SQL queries

Onsite · sql

Try a Ernst & Young LLP-style SQL round

Find every user active on 3 or more CONSECUTIVE days. This gaps-and-islands shape shows up in nearly every DE SQL round. Edit the query and run it against the seed data.

	/* Users active on 3+ consecutive days. */
	/* Hint: date minus a per-user ROW_NUMBER is constant within a streak. */
	WITH streaks AS (
	SELECT
	user_id,
	activity_date,
	activity_date - CAST(
	(ROW_NUMBER() OVER (
	PARTITION BY user_id
	ORDER BY activity_date
	))
	AS INT
	) AS grp
	FROM user_sessions
	)

	SELECT
	user_id
	FROM streaks
	GROUP BY user_id, grp
	HAVING COUNT(*) >= 3

Ernst & Young LLP is hiring data engineers now

The roles behind this loop. Prep against the levels and locations they are actually filling.

Hiring now

Ernst & Young LLP data engineer · live from career pages

open roles

San Francisco Bay Area

top metro

Design, build, and maintain robust data pipelines and transformations using Databricks, SQL, and enterprise ETL tools to support Talent reporting and analytics.

L5Hoboken24d ago

Design, develop, and implement data engineering solutions using Databricks on cloud platforms (e.g., AWS, Azure, GCP).

L5Stamford24d ago

Lead the design and implementation of modern data architectures, supporting transactional, operational, analytical, and AI solutions.

L5Stamford24d ago

Design or review logical and physical data models to support analytics, AML, reporting, and AI use cases

L4Saint John26d ago

Architect and oversee complex data workflows and high-volume streaming pipelines, leveraging platforms such as Kafka, Pub/Sub, Apache Flink, Dataflow, PySpark

L4Toronto27d ago

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

L4Toronto28d ago

Lead the design and development of scalable data engineering solutions using Databricks on cloud platforms (e.g., AWS, Azure, GCP).

L4Iselin46d ago

Knowledge of data architecture, including the design and setup of scalable solutions.

L4Multiple locations64d ago

New postings per week

5/25

6/8

6/15

6/29

7/6

week beginning · ~6 weeks of data

Where they hire

San Francisco Bay Area

Los Angeles

Toronto

New York

Levels hiring

L45L53

Updated Jul 31, 202682 open listings across 6 cities

Ernst & Young LLP compensation and culture

The numbers, tech stack, and team structure live on the company overview.

Data engineering at Ernst & Young LLP→

The role, comp by level, tech stack, teams, and culture signals.

Compare Ernst & Young LLP with other data engineering employers

How the role, pay, and loop stack up against peer companies.

Data engineering at Airbnb→

Compare the role, comp, and interview loop.

Data engineering at Amazon→

Compare the role, comp, and interview loop.

Data engineering at Apple→

Compare the role, comp, and interview loop.

Data engineering at Databricks→

Compare the role, comp, and interview loop.

02 / Why practice

Prepare at Ernst & Young LLP interview difficulty

01
Reading a solution is not the same as writing one
Every engineer who has frozen on a query they had read a dozen times knows the gap. The only preparation that closes it is producing the answer yourself, under time, before the interview does it for you
02
76% of hiring managers reject on the coding task, not the resume
From HackerRank's 2024 Developer Skills Report. Candidates who look strong on paper still fail the live screen if they haven't done timed, executable practice
03
5 problem shapes cover 80% of data engineer loops
Dedup, sessionization, top-N-per-group, slowly-changing dimensions, partition tricks. Writing the shapes by hand turns the unfamiliar into pattern recognition

Practice Ernst & Young LLP-level SQL

Related Guides

Data Engineering at Ernst & Young LLP→

The Ernst & Young LLP DE role, comp, tech stack, and culture.

DE Interview Prep Guide→

Complete preparation framework for data engineering interviews.

Data Modeling Questions→

Star schema, SCD, grain definition, and normalization.