Pros
The company is moving out of growth into operational mode and has been for some time. This brings about different behaviours and leadership. I'd say it really depends what you want out of a role. If you like a very micro-managed, regimented sales culture, you'll like it here. If not, you'll hate it. The product works great and is constantly being innovated on, never had a client complain or leave due to product. The issues at this company really stem from internal systems and teams as they have not scaled at the same pace as the sale organization. There are some good leaders and many not good - I'd say that's the biggest thing which will dictate your experience at Snowflake. Comp in the plans is below average and the bigger play was the Pre-IPO options which are mostly gone now.
Cons
Tons of broken systems and processes, worse than I've experienced at other unicorn rocketships. Sales Operations is completely overwhelmed, lots of that responsibility ends up on the sales reps which distracts from the core job. Many new inexperienced leaders have been brought in who don't understand the data space or the product at all - they just parrot those above. Comp is weak compared to industry and they've really started to reduce spending across the board (which I guess is natural) but no in-person SKO, cheap marketing events etc. etc.