RealSelf Business Intelligence Engineer interview questions

I applied online and they sent me a take home assessment which consisted of 3 questions (1 python - scraping data from twitter and doing data manipulations, 1 sql, 1 data modeling question - how will you join tables in Looker. Once I sent my submission, within 2 weeks I got an invite for recruiter screening. The recruiter spoke for 15 minutes and at the end of the call I was told I would be having an one interview with a senior member at the company. The interview with the senior technical member inclined more towards behavioral type. He genuinely wanted to know more about me and lastly he gave one simple python question. Next was a tech screen with the hiring manager. It consists of 3 sql questions and 1 python question. All were easy. Then I was called onsite to their seattle office for an onsite loop which consisted of 5 rounds. 1) Director of Analytics 2) Director of Data Science 3) BI Lead 4) Data Science Lead 5) Business Analyst Onsite loop were very exhausting as all the rounds were back to back without any intermittent breaks. But if you request, they will happily oblige. All the 5 people were very good. One thing I felt throughout the interview process is that at no point does it get intimidating like other companies. They basically want to know your thinking ability rather than your technical abilities. Onsite interviews was focused on case based business questions. So you will not know if your answer is what they are expecting. I thought I performed well but the next day I got a rejection email. The recruiting coordinator, Leslie Mills was such a wonderful person. Everytime you get an email from her, you will feel so much positiveness. Like other companies, they dont give feedback for rejection. I still cannot get the fact that I was rejected.