Vanguard Data Analyst Interview Guide

Vanguard Data Analyst candidates describe a process that moves from a light screen into practical analyst work. One candidate had a basic phone screen about their background, then a one-hour HackerRank-style test with roughly 10 to 15 questions. They recall mostly basic SQL, one more intermediate problem, and multiple-choice statistics and hypothesis testing, and they ran out of time. A Senior Data Analyst candidate also reports a simple SQL HackerRank, so timed SQL practice is a sensible first priority.

The case study appears to carry real weight. One candidate says it was meant to take 4-6 hours, took longer, and had to be turned into a PowerPoint. They then walked through it in a technical interview, followed by a behavioral interview on why Vanguard, leadership, conflict and innovation. The Senior Data Analyst candidate presented an A/B case study to a senior manager. A third candidate describes the next step after the assessment as a consulting-style case on profit, metrics and whether performance looks good or bad.

For the Senior Data Analyst, A/B testing fundamentals were prominent: statistical significance, p-values, power, whether to launch after a failed experiment, and how to test when user-level randomization isn't possible. One candidate also reports a rushed remote round with basic pandas and SQL on screen share. One candidate describes slow and disorganized communication, so plan your time and follow up politely. Reports are few, so expect variation by team and level.