What is a Consultant at dunnhumby?

As a Consultant at dunnhumby, you are the critical bridge between complex customer data science and actionable business strategy. dunnhumby is a global leader in customer data science, working with massive retail and FMCG (Fast-Moving Consumer Goods) brands to optimize everything from pricing and promotions to personalized marketing. In this role, you will translate vast amounts of consumer behavior data into compelling narratives that drive commercial success for these high-profile clients.

Your impact is both immediate and highly visible. You will work closely with retail partners and internal data teams to design targeted campaigns, analyze customer trends, and solve complex strategic problems. Whether you are leveraging SQL to extract insights or standing in front of senior client stakeholders to present a new promotional strategy, your work directly influences how millions of shoppers experience retail.

To thrive in this position, you must be a hybrid professional. You need the technical fluency to navigate databases and analytics tools confidently, combined with the polished communication skills required to manage client relationships. This role is ideal for strategic thinkers who are passionate about retail, highly comfortable with data, and capable of guiding clients through complex, sometimes ambiguous, business challenges.

Common Interview Questions

Getting Ready for Your Interviews

Preparing for the Consultant interview requires a balanced approach, as dunnhumby evaluates both your analytical sharpness and your client-facing finesse. You should frame your preparation around the following core evaluation criteria:

Technical and Analytical Fluency – You must demonstrate the ability to extract, manipulate, and interpret data. Interviewers will look for practical competence in SQL and familiarity with marketing automation tools (like Unica), assessing whether you can independently gather the data needed to support your strategic recommendations.

Strategic Problem Solving – This evaluates how you break down ambiguous retail challenges. You will be tested on your ability to structure case studies, perform guesstimates, and build logical frameworks that lead to actionable business solutions.

Stakeholder Management – As a Consultant, you will frequently navigate complex client dynamics. Interviewers will probe heavily into your past experiences dealing with difficult stakeholders, assessing your emotional intelligence, resilience, and ability to influence without formal authority.

Communication and Storytelling – Data is only as good as the story it tells. You will be evaluated on your ability to present findings clearly, concisely, and persuasively to non-technical audiences, particularly during the panel presentation stages.

Interview Process Overview

The interview process for a Consultant at dunnhumby is thorough and typically spans three to four distinct rounds. It is designed to evaluate your cultural fit, technical baseline, and practical consulting skills. The process usually kicks off with an initial recruiter screen focusing on your background, salary expectations, and general alignment with the company's "Customer First" philosophy.

Following the initial screen, you will typically meet with a Hiring Manager for a deeper dive into your resume. This round blends behavioral questions with technical probing, often testing your SQL knowledge and past project experience. If successful, you will advance to the most critical stage: the Panel Case Study. Here, you will be given a retail or data-driven scenario to analyze and present back to a group of team members and managers. The final round is generally a high-level conversation with a Director or senior leader, focusing on long-term potential, commercial awareness, and leadership qualities.

This visual timeline outlines the typical progression from your initial application through to the final leadership interview. Use this to pace your preparation, ensuring you review behavioral examples early on, but reserve intensive presentation and case study practice for the rigorous panel stage. Note that while this is the standard flow, campus hires or specific regional offices may incorporate online aptitude and guesstimate tests early in the sequence.

Deep Dive into Evaluation Areas

Client and Stakeholder Management

Consultants at dunnhumby must navigate diverse and sometimes challenging client environments. Interviewers will heavily index on your ability to manage expectations, handle pushback, and build rapport. Strong performance here means demonstrating empathy, active listening, and a structured approach to conflict resolution.

Be ready to go over:

• Navigating Resistance – How you handle clients who disagree with your data or recommendations.
• Cross-functional Alignment – Managing internal teams (like data engineering or product) to deliver on client promises.
• Expectation Setting – Communicating delays or shifts in project scope professionally.
• Advanced concepts – De-escalation techniques, building trust with skeptical senior leaders, and translating highly technical limitations to non-technical stakeholders.

Example questions or scenarios:

• "Tell me about a time you had to present data to a difficult stakeholder who fundamentally disagreed with your findings."
• "Describe a scenario where a project scope changed drastically. How did you manage the client's expectations?"
• "How do you build rapport with a client who is uncommunicative or resistant to change?"

Technical and Analytical Proficiency

While you are not a pure data scientist, you must be highly data-literate. dunnhumby expects Consultants to be hands-on with data extraction and campaign management. You should prove that you can write queries, understand relational databases, and use specific marketing tools to segment customers and analyze campaign performance.

Be ready to go over:

• SQL Fundamentals – Writing queries using JOINs, aggregations, and subqueries to pull customer cohorts.
• Campaign Management Tools – Familiarity with tools like Unica, or general principles of marketing automation and A/B testing.
• Data Interpretation – Looking at a raw dataset and identifying anomalies, trends, or commercial opportunities.
• Advanced concepts – Query optimization, statistical significance in A/B testing, and predictive modeling basics.

Example questions or scenarios:

• "Write a SQL query to find the top 10% of customers by spend in a specific retail category over the last quarter."
• "Explain your experience using Unica or similar tools to execute a targeted marketing campaign."
• "If a promotional campaign shows a high click-through rate but low conversion, what data points would you investigate next?"

Case Studies and Problem Solving

The case study presentation is the defining moment of the dunnhumby interview process. It tests your ability to synthesize information, create a narrative, and defend your logic. Strong candidates do not just provide "the right answer"; they showcase a clear, structured methodology and strong commercial awareness of the retail sector.

Be ready to go over:

• Retail Strategy – Optimizing pricing, analyzing basket affinity, and designing loyalty programs.
• Guesstimates and Sizing – Quickly calculating market sizes or revenue impacts using logical assumptions.
• Presentation Skills – Designing clear slides and speaking confidently to a panel.
• Advanced concepts – Cannibalization effects in retail promotions, margin vs. volume trade-offs, and customer lifetime value (CLV) optimization.

Example questions or scenarios:

• "Estimate the weekly revenue of a mid-sized grocery store in London."
• "You are presented with a case where a retailer wants to launch a new loyalty tier. Walk us through the data you would need and the framework you would use to advise them."
• "Present a post-campaign analysis to a panel, defending your recommendations for the next quarter's marketing spend."