HR call just to see general quilifications, followed by 1 hour online SQL assignment which is challenging, followed by first professional interview with 2 team members getting into details of your experience and some questions about the SQL test, then homework assignment to analyze data which takes about 1-2 days, followed by a 2nd professional interview to present your work on the homework assignment. If you passed all that there's an HR interview, and talk with recommenders
Interview questions [1]
Question 1
Describe a funnel for monetizing your app. What data would you interest you? What KPIs would you track?
I applied through an employee referral. I interviewed at Unity (Tel Aviv-Yafo)
Interview
The first step was a screening call with the HR person, which included salary expectations. At the end of the call a physical interview was scheduled. The Interview focused on personal/career subjects and a live (basic) SQL question.
I applied through a recruiter. The process took 4 weeks. I interviewed at Unity (Los Angeles, CA) in Dec 2020
Interview
The interview process was pretty straight forward, had the initial session with the hiring manager with some analytical concept questions then moved on to the panel interviews with product and analytics team which involved many situational questions as well as some Looker specific questions. The company does their due diligence when it comes down to reference checks. Overall it took around 3-4 weeks from 1st interview to the extension of offer.