I applied online. I interviewed at RouteOne (Herndon, VA) in May 2025
Interview
Asked sql questions, logic questions. Sql included like joins, and logs questions were basic math queries. Also asked to explain my projects. Total length was around 30 minutes, average interview
Interview questions [1]
Question 1
What query would you use to combine info from these 2 tables
I applied through college or university. The process took 2 days. I interviewed at RouteOne (Farmington Hills, MI)
Interview
SQL test on TestDome followed by an in person interview. Need to score 50% and above on the test to get through and then the interview will happen. One interview with multiple interviewer wil be there.
Interview questions [1]
Question 1
Resume based questions followed by Technical on PowerBI, SQL and DAX queries
BI Analyst applicants have rated the interview process at RouteOne with 3 out of 5 (where 5 is the highest level of difficulty) and assessed their interview experience as 100% positive. To compare, the company-average is 66.7% positive. This is according to Glassdoor user ratings.
Candidates applying for BI Analyst roles take an average of 2 days to get hired, when considering 2 user submitted interviews for this role. To compare, the hiring process at RouteOne overall takes an average of 10 days.
Common stages of the interview process at RouteOne as a BI Analyst according to 2 Glassdoor interviews include:
Group panel interview: 22%
Phone interview: 22%
Skills test: 22%
Personality test: 11%
IQ intelligence test: 11%
One on one interview: 11%
Here are the most commonly searched roles for interview reports -