KPMG Data Engineer Interview Guide

The KPMG 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: Proudly published by: Jeff Wahl
The technical bar

The technical center of gravity is pipeline architecture, which means SQL and Python fluency are expected but insufficient on their own. What KPMG interviewers want to see is how you design an end-to-end solution on Azure, Databricks and Spark with SQL, Python and PySpark when the requirements are messy. A strong answer names tradeoffs explicitly: why Databricks over a raw Spark cluster for this client's scale, how you'd handle schema drift in a batch ETL pulling from a legacy source system, what your SLA monitoring looks like when you can't control the upstream. The screen puts Python front and center, so you need clean, readable code under time pressure, not just working code. In the loop, generic architecture answers that could apply to any cloud stack won't carry you; ground every design choice in the client scenario you're given.

How candidates rate the KPMG loop

How hard candidates rated the loop and how they felt, summarized across the reports below.

How hard candidates rated it
Easy
50%
Medium
33%
Hard
17%

6 rated reports

How candidates felt
Positive
83%
Neutral
17%
Negative
0%

6 rated KPMG reports

Where offers are lost

The failure mode that recurs in KPMG loops isn't technical weakness, it's overconfidence on scope. Candidates who dive immediately into implementation without asking what the client actually needs, or who propose greenfield architecture when the client is mid-migration with 3 years of legacy tooling, signal poor consulting instincts regardless of their SQL fluency. The pass behavior is the inverse: you treat every problem statement as incomplete information, you surface assumptions before you solve, and you size your answer to what's deliverable under real constraints. Given that 29 reports and a compressed ladder mean the interview pool here is smaller than at large product companies, the interviewers rely more heavily on behavioral read than quantitative screening, so your communication about tradeoffs carries more weight per minute than it would at a firm with a structured coding rubric.

Try a KPMG-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
What the loop filters for

KPMG's loop is designed to filter for engineers who can operate without a stable platform under them. At a product company, you inherit guardrails: a defined stack, an established data model, colleagues who built the system. At KPMG, each engagement drops you into a client's environment with partial documentation, inherited technical debt, and a delivery timeline set by contract. The interview is calibrated to surface whether you can make sound architectural calls under those conditions. Interviewers are watching for how you handle underspecified problems: do you ask the right scoping questions, do you flag risks clearly, do you build something defensible rather than something clever? The consulting context also means client communication is a real evaluation axis. Engineers who can translate pipeline decisions into business impact for a non-technical stakeholder score higher here than at most product-company loops.

KPMG is hiring data engineers now

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

Prep allocation

Your prep should front-load pipeline architecture because that's where hiring decisions get made in this loop. Run through 4 to 5 end-to-end design scenarios on Azure and Databricks: migration from on-prem to lakehouse, incremental batch ETL with backfill logic, streaming ingestion with late-arriving data. For each, practice articulating the business constraint driving the design choice, not just the technical one. On the Python screen, prioritize readability and correctness over optimization tricks; KPMG screens for engineers who write maintainable code on client engagements, not competitive programmers. Leveling here matters for comp: the gap between $90K at L4 and $126K at the next level is real, and interviewers peg level on how independently you drive architectural decisions. If you're targeting senior, your answers should reflect ownership of the full pipeline, not just execution of a prescribed design.

KPMG
Hiring now
KPMG data engineer · live from career pages
31
open roles
New postings per week
25
3/2
4
4/13
15
5/18
14
6/1
11
6/8
18
6/29
week beginning · ~17 weeks of data
Where they hire
New York
3
Washington DC
3
Chicago
2
Toronto
2
Levels hiring
L42L55
Updated 31 open listings across 6 cities

KPMG compensation and culture

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

Compare KPMG with other data engineering employers

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

02 / Why practice

Prepare at KPMG interview difficulty

  1. 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

  2. 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

  3. 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

Related Guides