It starts with a take-home technical challenge. Giving you a CSV of data related to the product analyst position, you need to clean it up and deliver insights. I enjoyed how it was very similar to something you would encounter in the actual role. You then move on to an in-person interview where you discuss the take-home and do a Postgres SQL quiz in code-signal. No gotcha questions here, you just discuss the take home. The SQL questions are related to the position and involve knowledge of (WHERE and GROUP BY and time series comparison, Questions like, get the total amount for x by y during z timeframe.) You then move on to the final interview. It is 4 or 5 hours and 4 or 5 individual interviews with different people. The recruiter will give you info on what to expect beforehand. There is a case study, SQL challenge (code signal), and one where you look at a chart with no axis and tell a story about it. The SQL questions are pretty difficult in my opinion. Make sure you know things about postmates app you would want to change. Make sure you know postgres SQL for time-series related questions. Make sure you ask questions about the vague charts they show before you start talking. Overall the interviews were good. It took an extremely long time, 4 months. And they ghosted me after the final interview after telling me they would get back to me with a yes or no. So I found that quite unprofessional. Also, the first take-home is probably 100% a Python or R challenge yet most of the people there say they use SQL 90% of the time and that some dont even know Python. Exact SQL questions for first-round interview can be found in glassdoor.

Two weeks ago, I was contacted from a "Senior HR" Rep from Postmates with a form email saying they think I'd be a good fit, please take this data test as a first step, etc." You start off with a mock Data project - the goal being a test of your data analysis, visualization, data manipulation, and data optimizing skills. The project was actually very fun and not too time-intensive. (~4 hours) I handed the project in and never heard back from them. I sent a total of 3 emails over the course of two weeks to this HR rep who never responded, so I started to get a little suspicious and concerned. So I came here to Glassdoor and unfortunately saw a bunch of people shared my same EXACT experience. Just after researching here, I started to assume I wouldn't hear back or be given a rejection without explanation and sure enough - this week the rejection email finally came. They reach out, they get you to do the project, they ignore all communication, they make their decisions and if you are rejected, you will not receive a word of context or explanation. I personally am a tech and data professional with 10 years experience, former Project Manager in Big Tech companies, and former Head of Business Intelligence for a Tech Start Up. Unfortunately, this low level of professionalism is par for the course in the tech industry. My advice? Ignore any "potential opportunities" from this type of company and never forget that you don't have to accept this treatment from ANY company. If it happens once? That's unfortunate. If it happens a few times? That's suspicious. If it happens so often that your exact experience is echoed by dozens of other reviewers? It's their company culture. Skip them.