Process was easy enough. First call with recruiter is just asking about background. For the role should know financial topics, seemed to really emphasize knowing forecasting, time series modeling and analysis, and Experimentation of A/B testing and Analytics. Take home was 6 questions, 4 mysql and 2 open ended asking to analyze data. Be careful reading the questions as they can be unclear, got 1 question wrong and didn't move forward

The data team that has been there the longest is incredibly nice, but also super-junior. They conduct the interviews! I have no idea why but leetcode easy (this was Oct/Nov 2022) and she thought it was a challenge or something. I have 8 years of experience, so multi-tasked with a seperate conversation while doing the coding round. The company's big issue at the time was ETL, so felt I could demo something in the SQL code that would be optimized for a pipeline as well. I'd heard afterwards they'd flagged my coding round because I'd created an outer query to the easy SQL question so that nulls are handled a certain way or something, even though I discussed that it will help for when any ETL would be scaled / modified downstream. The interviewer (one of their first hires) was so junior that we'd started to naturally assume a student/teacher role, but in a respectful way and very cool, while asking questions about their pain points and proposing solutions to them. I was excited to join the team and felt like I could be impactful help. For whatever reason she flagged me on it. I'm guessing it was due to a junior/senior thing and they may have needed a junior/junior thing. They'd had a follow up round with another interviewer and asked another easy question I had not done using SQL in x years (it's usually handled by python). I blanked, was completely focused on the realization that the team needed to be convinced to hire more senior people. Just sat there thinking about the flight I was going to catch that day, and empathy for the company's ETL issues. Tried not to look back - ETL issues with an ecommerce site that handles realtime transactions are a sign of stressful tech debt they likely dealt with this year.