I have to second RedShift; it's been very easy to use, and just as importantly, it's dirt cheap to start out with. I used it to create a customer data warehouse for my current company; a mix of traditional flat data and JSON data that's either stored as large varchar columns or parsed into columns.
More to the data science part of it, it's allowed me to link together and analyze gigabytes of customer data. Easy Tableau plug-and-play integration was also a big selling point; it allowed me to give access to all the data to anyone who wanted it, without being bogged down by daily requests.
