I've had good experience with Amazon Redshift for a ~40TB dataset. Google BigQuery can also work pretty good, depending on how exactly you want to use it. You c

I've had good experience with Amazon Redshift for a ~40TB dataset. Google BigQuery can also work pretty good, depending on how exactly you want to use it. You can use SQL or SQL-like languages to query your data, and it works without much hassle. I'd strongly recommend against building an in-house system. You're going to spend hundreds of thousands of dollars in developer salary and hardware, and won't get that much out of it. I'm sure AWS and Google both offer HIPAA-compliance, though you might have to pay more.