A common stack in industry now is: Fivetran (or Stitch) -> Snowflake (or BigQuery) -> Looker (or Mode)

For an organization with 1000+ employees you are going to be paying a lot for whatever service you use, which means that you will get a lot of support from the vendor you go with and you don't have to try to answer all of these questions ahead of time. Plus, you are going to hire someone on your team to manage this, it's not something that someone just manages on the side.