If you are already familiar with one, that is actually a really good reason to use it. If you store a lot of data but rarely query it, BQ will be WAY cheaper because you pay for compute and storage separately. On the other hand, you will never see sub-second queries in BQ.

Another option absolutely worth checking out is Snowflake, which compromises between the approach of BQ and Redshift in a very interesting way.