Ask HN: How to Work with a Data Warehouse

With tools like segment.io it's super easy to collect data from multiple sources and quickly build a data warehouse with highly accurate data. But what are my options for working with the data? I want to run email/sms campaigns based on user events for example. Should I just make a lambda and build everything manually?