I went through the interview process for the Associate Analyst role in January/February 2022. The process had 5 rounds:
1) Behavioral
2) Coding challenge
3) Analytics project
4) Live relational database challenge
5) Defense of analytics project
Interview questions [1]
Question 1
1) Tell about yourself
Why do you want to work at DAS42?
Why are you interested in the role and why are you a good fit?
2) Total of 5 HankerRank SQL and Python questions
3) You have 1 week to use Looker to solve a simulated business case. You analyze sales data and create data visualizations and a slideshow to provide business intelligence.
4) The interviewers give you a business case, and you create a database diagram for that business while the interviewers watch and give tips.
5) The interviewer pokes holes in your analytics project from round 3 and you defend your work and accept criticism.
I applied online. The process took 1 day. I interviewed at DAS42 in Apr 2023
Interview
Experienced the initial screening with HR. The interviewer did not seem to care about my answers. Would read off of the screen for the interview questions, and the moment I started answering, they would look what seemed to be out the window and not listening to my answer. Would turn back to the camera a couple moments later to type some notes, ask the next question, and then once again not pay attention to me. Received a rejection the next day with no explaination.
Smooth Interview: phone screening, then Technical sufficiency and Business insights interview (business case write-up), then two rounds final interviews including technical and behavioral questions. Overall, the interview was smooth and they fully support you if there is any clarification you would like to ask.
Interview questions [1]
Question 1
How would you design data warehouse given certain rules?
