I can help you with Cloud data migration to Amazon Redshift Data Warehouse. As the data is in S3, AWS Glue can hep us to move data from s3 to Redshift. This involves creating the Glue Data catalog of S3, Redshift table(which will be created as a part of the Data Migration). This leaves us with the Enterprise Data Warehouse setup i.e Redshift Which can then be used for Source of truth for Data Analysis/Analytics using a BI tool like QUicksight, Metabase etc.,