Immediately after applying, you get an automated email for the link to the HackerRank assessment. You get 45 minutes to complete it even though the email says you would have 90 minutes. The assessment is composed of 15 questions, 10 of which are math/statistics related and the final 5 questions are SQL related. For the math/statistics portion, definitely prepare to see questions related to confidence intervals, hypothesis testing, and how to interpret type 1/2 errors. For the SQL portion, definitely know joins, aggregations, and how to extract the year/month from column with a timestamp data type. Overall it was not too bad but the time constraint was somewhat of a factor. Upon completion of this assessment I was contacted by a recruiter about a week later. We went over my resume, why I wanted to work at Vanguard, and then he gave a high level overview of the role. He mentioned that he would look into scheduling the next round of interviews in the upcoming days. I had applied to multiple data analyst roles and he also said that he would look into getting my resume in front hiring manager for those. A few weeks later, it was just complete radio silence even after following up. I found it very odd that he would mention about scheduling the next round of interviews and then just ghost. It seems like a previous poster experienced a similar situation when applying to a data analyst position, so this definitely seems to be a common occurrence here.