A pretty great overview of the modern data architecture by our friends at Indicative. https://www.indicative.com/data-warehouse/modern-data-infrastructure/