Data Warehouse Architect 5 Responsible for maintaining data alignment between systems and the data warehouse, designing and managing ETL processes, building and maintaining data warehouse applications, supporting end-user training, and assisting federal reporting teams with database query optimization.