Altman Solon Data Engineer Data Analyst interview questions

Interviewed for the Analytics Innovation Practice, 5 rounds (30 min behavioral video interview with HR, 45 min technical coding video interview with team member, 30 min behavioral video interview with team member, 45 min case video interview with team member, and 45 min behavioral interview with director). The technical coding interview (second round) was 4 SQL questions that built on top one another, all pretty basic in solutions but definitely also talk about what other considerations / context. The case interview (fourth round) was on how to determine additional locations of a grocery franchise - consider what additional information/factors to consider, process to determine it, machine learning/python etc. I always got feedback within a week from the interview and when I had a competing offer deadline, they were able to expedite the last couple rounds. Overall, all the people were very friendly and the process was pretty clear.