The data warehouse designer is responsible for reviewing requirements and performing functional and technical analysis of source data. The data warehouse designer is critical in defining how the team will implement the solution to meet the client’s requirements. The designer translates business rules from the functional requirements to the technical design. They design the logical entities needed to meet the business requirements, and define the relationships between these data entities. Designers create the DDL and work with database administrators to create the tables to store data. Designers create the specifications used by the development team to extract, transform, and load and validate data from the source tables to the target tables. Designers also work with the business intelligence developer and others to understand and prepare data for business intelligence and analytical solutions.
Just as the requirements are refined and adjusted over time, the data warehouse design process is also iterative, and requires team collaboration.