Built a data model, data warehouse and pipeline for extracting transforming and loading data into a star schema-based data model in a redshift database