SQL Power Architect data modeling and profiling tool was created by data warehouse designers and has many unique features geared specifically for the data warehouse architect. It allows you to reverse-engineer existing databases, perform data profiling on source databases, and auto-generate ETL metadata.