I created a step-by-step data warehouse for banking customer data using AWS and dbt. This guide walks through schema design, cloud setup, and data transformation—perfect for anyone curious about practical data engineering. Check out the full article here: https://medium.com/@jushijun/building-a-banking-customer-data-warehouse-an-end-to-end-guide-using-aws-and-dbt-c058ebe7af35.
Github: https://github.com/shj37/dbt-redshift-aws-banking-data-warehouse
- Built a banking customer data warehouse using AWS (Redshift, S3, Glue) and dbt for transformation.
- Designed a schema with fact and dimension tables, set up cloud infrastructure, and processed data into silver and gold layers.Applied skills in data modeling, ETL workflows, and cloud data tools to deliver an actionable analytics solution.
