EY Data Analyst Interview Preparation and Question Guide

EY's brand is built on assurance, tax, strategy and transactions, and EY-Parthenon handles the strategy-heavy cases, so the flavour of a case depends heavily on which service line you apply to.

The process generally starts with a screen and an online assessment - aptitude, and sometimes a SQL or case test - followed by two to three interviews. Rounds cover technical data skills, a business or case scenario, and behavioural fit, usually finishing with a manager or partner conversation.

• Assessment: aptitude, and possibly SQL or Excel tasks.
• Technical round: SQL, data manipulation, and analysis approach.
• Case / business round: interpret data and recommend action.
• Behavioural / partner round: teamwork, communication and motivation.

EY commonly runs an assessment day with a group exercise, a case and a partner interview, and watches how you contribute to a team under time pressure. The signal EY wants is an analyst who is technically sound and can translate analysis into a recommendation a client will act on.

Prepare across the analyst toolkit:

• SQL: joins, GROUP BY, subqueries and window functions; expect to write a query for cohort or funnel analysis and narrate it.
• Excel: lookups, pivot tables, and cleaning messy data.
• Visualisation: which chart for which question, and how to avoid misleading a client.
• Business case: given a dataset or scenario, define the metric, diagnose a change, and recommend an action.

A strong answer to a case like sales dropped last quarter - investigate segments the data by region, product, channel and customer type, separates a real drop from a data issue, forms a hypothesis, and states a clear next step. Weak candidates list charts without a hypothesis or bury the recommendation at the end.

At EY, an analyst who cannot explain findings to a non-technical stakeholder is only half useful, so communication is tested directly. Expect prompts like explain a complex analysis to a client with no data background. Behavioural questions cover teamwork under deadline, attention to detail and why EY. Use STAR and quantify impact where you can. EY frames fit around its purpose - building a better working world - and looks for genuine, values-led motivation.

Partners look for someone who is careful with data, honest about limitations, and able to turn numbers into a decision - the qualities that make a client trust your dashboard rather than second-guess it. This blend of SQL fluency, clean framing and business communication is what employers screen for across Data Analyst / Data Science Jobs, so the reps transfer well beyond a single firm.

Beyond querying, EY interviewers probe whether you reason soundly about data. Be ready for light statistics - averages versus medians and when each misleads, the difference between correlation and causation, sample size intuition, and how you would spot a data-quality problem before it reaches a client deck. You do not need advanced modelling, but shaky fundamentals here undermine trust in everything else you present.

A strong candidate names caveats without prompting: this trend is based on two weeks of data, this segment is small, this metric changed definition mid-year. That instinct to caveat honestly is a large part of what distinguishes a reliable analyst from a fast one.

EY data analysts frequently support assurance and consulting engagements with analytics, so interviewers look for someone who can move from a client question to a clean, defensible analysis. Be ready to discuss a project where your data work changed a decision, and to explain a technical result simply - EY prizes the ability to communicate insight to partners and clients without jargon.

Convert study into reps:

• SQL: solve ten to fifteen medium queries, focusing on joins, aggregation and window functions.
• Excel and viz: rebuild a messy dataset into a clean pivot and a clear chart.
• Cases: practise three diagnose-and-recommend scenarios aloud.
• Fit: prepare four STAR stories including one on explaining data simply.

InterviewPrep's free AI voice mock interview builds a session from your CV and a EY Data Analyst job description, then scores your answers, pace and filler words - a good way to practise narrating a case and explaining analysis clearly before the real rounds.