">
logo for information-management-architect.com
leftimage for information-management-architect.com

Data Warehouse Architect

Improve accountability with David Bowman’s information management guidelines for data warehouse architect roles and responsibilities

This site is designed for Information Technology professionals who need  to improve accountability and require guidance and direction to establish information management roles.

It provides information management guidelines for data warehouse solution architect roles and responsibilities.

What are Data Warehouse Projects?

A solution architect, has overall responsibility for architecture and design, development, integration testing and data warehousing solution migration to quality assurance testing and production. They are involved in the following data warehouse project phases:

Requirements Specification


A solution architect is responsible for ensuring that requirements are sufficiently clear to commence architecture and design and that acceptance requirements have been clearly defined. This includes:
  • Data requirements;
  • Entity relationship diagram and logical data model;
  • Dimensional data model;
  • Source to target mapping;
  • Data conversion and history load;
  • Data warehouse security;
  • Defining system, or non-functional requirements including
    • Production support; and
    • Service level requirements
Architecture and design

A solution architect has overall responsibility for all architecture and design. This includes responsibility for data warehouse design and providing technical direction to data modelers, data analysts, data integration architects, data integration developers and database administrators. This includes:
  • Data architecture;
  • Data warehouse operations management including:
    • Process architecture; and
    • System processes
  • Physical data base design, including
    • Star schema and data mart design;
    • Snowflake schema schema design
  • Change data design, including slowly changing dimensions;
  • Operational data store design;
  • Defining database development software;
  • Specifying business intelligence architecture;
  • Database normalization;
  • Database partitioning;
  • Data aggregation;
  • Data base management solutions;
  • Data conversion solutions; and
  • Database design documentation.
Construction or Build

The solution architect is also responsible for the quality assurance of all architecture and design deliverables. This involves reviewing all development  deliverables and certifying that they are complete including:
  • Unit testing; and
  • System testing.
Quality Assurance

A solution architect is responsible for:
  • Directing integration testing
  • Participating in regression testing
  • Participating in software security testing
  • Load testing and performance testing; and
  • Release testing.
Summary…

Data warehouse projects are data centric and require highly skilled specialists to fill technical leadership roles.

A solution architect plays a pivotal role in project planning and technical design can help ensure rapid delivery.

This site provided information management guidelines for data warehouse architect roles and responsibilities.