You should definitely check out dbt :)

Some links in my comment: https://news.ycombinator.com/item?id=36911937