Round 1) VERY easy automated SQL and analysis write-up challenge. Round 2) Phone Screen with the hiring manager. I thought this was interesting as a second step because it was conducted by the hiring manager considering they had a recruiter do the scheduling. The manager was pleasant but I could tell without a doubt she was not paying attention to any of my responses. I could also hear pages turning as she was talking which verified my suspicion that she was reading from a FULL script...this went on for PAGES AND PAGES. She also mixed up the two apps they offer in her description of the company- I never told her this though. Round 3) A difficult SQL challenge with a data engineer. The SQL questions were relatively difficult but the real difficulty is that the engineer has you write the SQL live on screen share with a database you have 0 time to become acquainted with. There were also data engineering and database architecting questions…why for an analyst job I have no idea. The last thing I'll say, and I want to stress that he was also very nice, but he had clearly rolled out of bed 5 minutes before the interview - I do not mean that as hyperbole. He was wearing an very oversized t-shirt hanging off of his shoulder that looked like pajamas and his hair was extremely messy. I don't say that to shame anyone but to just point out that I didn't get the sense that they cared as much as their candidates do or put in a fraction of the effort