KPMG Data Analyst Interview Process & Questions

Cracking the KPMG Data Analyst Interview

KPMG is one of the "Big 4" accounting organizations. Data Analysts here often work closely with the audit, tax, or advisory teams, manipulating massive financial datasets to uncover fraud, optimize processes, or provide strategic insights to clients.

The Interview DNA

Unlike tech startups that prioritize raw coding speed, KPMG prioritizes accuracy, domain understanding (finance/audit), and client communication. You must be able to translate data findings into business recommendations.

Round 1: Online Assessment

Typically conducted on platforms like SHL or HackerRank.

• Aptitude: Standard quantitative and logical reasoning (crucial for Big 4).
• Technical: Basic SQL queries and Excel scenario-based questions (e.g., VLOOKUP, Pivot Tables).

Round 2: Technical Interview (SQL & Excel)

This round focuses heavily on your ability to extract and clean data.

• Excel Focus: "How do you handle a dataset with 500,000 rows where 10% of the date fields are formatted as text instead of dates?" You must demonstrate knowledge of Power Query or advanced Excel functions.
• SQL Focus: Expect questions involving JOINs, GROUP BY, and Window Functions (like RANK() or ROW_NUMBER()).
• Scenario: "Write a query to find the top 3 highest-spending clients per region from this sales table."

Round 3: Business Case Study

This is where candidates often struggle. KPMG wants to see how you approach a real business problem.

• The Case: "A retail client is seeing a 15% drop in profitability in their Western region despite stable revenue. What data would you ask for, and how would you analyze it?"
• The Approach: Do not jump straight to "I will run a random forest model." Start with the basics: Analyze cost of goods sold (COGS), supply chain expenses, and discount rates. Show structure in your thinking.

Round 4: Partner / Director Round (Behavioral)

In the Big 4, the final round is usually with a Partner.

• Focus: Cultural fit, professionalism, and client readiness.
• Common Questions:
  • "Tell me about a time you had to explain a complex technical finding to a non-technical stakeholder."
  • "How do you handle tight deadlines when multiple managers are giving you conflicting priorities?"
  • "Why KPMG over the other Big 4?"

Pro Tip: Brush up on basic accounting terminology (revenue vs. profit, assets vs. liabilities). As a data analyst at a Big 4 firm, you will be swimming in financial data. Knowing the domain will set you apart from pure tech candidates.