Walmart·Data Analyst·Technical Phone Screen
Jun 2026
SQL live coding round for a Data Analyst role at Walmart Labs. The problems were business-flavored, not textbook, so you had to actually think about what the numbers meant before writing a single line. Less about perfect syntax, more about whether you could reason through a messy real-world scenario.
- Write a SQL query to calculate total revenue or GMV over a given period, grouped by a relevant business dimension.
- How would you identify new customers in SQL, and what business definition would you use to distinguish them from returning ones?
- Write a SQL query using window functions to compare a metric across rolling time periods, such as week-over-week or month-over-month.
- Given a query that runs slowly on a large dataset, how would you diagnose and optimize it?
- Write a SQL query involving multiple joins to pull together data from different tables for a business reporting use case.
- How would you handle date calculations in SQL, such as filtering for the last N days or computing the difference between two dates?
“Seemed straightforward but I spent too long assuming I knew what 'revenue' meant.” The rest of the author's notes on Data Analyst interview at Walmart, Technical Phone Screen round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.
View Post