Data Warehouse Designer
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.
Activities
- Analyze requirements to understand data needs and relationships
- Analyze source system data
- Transform Business Rules into data solutions to meet reporting needs
- Design the data solution to satisfy security requirements
- Update catalogs of current data models
- Develop and maintain DDL for implementation of data designs
- Validate data warehouse data to ensure data accuracy and integrity
- Monitor source system updates to address impacts in data warehouse
- Troubleshoot and resolve data warehouse production issues
Key Products
- Logical and physical data models
- Source to Target documentation
- DDL scripts
- Extract Transform Load overview document