- Screening
-Hiring Manager
- Test
- 3-hour team interview with SQL and Data Viz test
The first interview was with the recruiter who was 20 mins late. Luckily I was able to pivot and still meet at that time.
After the initial screening, I met with the Hiring Manager for 1 hour and then a final interview that was 3 hours. It seemed like he really needed to hire someone, and it was a good conversation. I genuinely liked chatting and felt like we would work well together.
After the 1:1 interview, there was a virtual assessment screening to make sure you understood stats and Tableau, then there was a 3-hour interview. I had asked the recruiting coordinator, not the recruiter who never spoke to me again, how best to prepare for this long interview and she gave me some very vague words that every recruiter says to prepare. Then ~1 hour before the interview, the HM sent me some data that I should be familiar with for the interview and be prepared to work with in Tableau. I was unable to look at the data more than download it and see some basic details. (Even though no one told me to download it!)
The 3-hour interview started with a SQL test with two potential colleagues. It was pretty straightforward. I did run into some technical difficulties with their weird sign-on to the SQL test enviornment. They had me use a company email address and it wasn't working correctly, which limited my time in the SQL test.
After the SQL test, there was a job fit interview with a Program Manager and another Sr. level. It was pretty behavioral-focused.
The final interview was with 2 data scientists. They asked very specific visualization questions, which I am personally better at the analysis portion vs. visualization, and it had been some time since I had used Tableau. Surprised it was still on my local comp. Then they asked me to use the data I was given, plug it into a tableau instance on my end and run some analysis. Nothing to do with SQL or Python, my strengths, it was all in Tableau and assuming I had an instance installed and was familiar with the data. I am saying this because the team had ample time to prepare me for this portion of the interview. Never was I told to make sure I had an instance of Tableau available for the interview. I was also given the data 1 hr before the 3-hour interview and was supposed to be familiar with it. I felt like I was caught off guard and unprepared, which tends to send me in a spiral so all I could say was "I haven't had 'much' time to look at this data" while I was scrambling to understand the ask. It was a stressful, unprepared interview and I think one of the wort interviews I have ever had.