Data Architect

A practitioner of data architecture, an information technology discipline concerned with designing, creating, deploying, and managing an organization’s data architecture. This person is usually responsible for designing the Extract, Transform, and Load (ETL) process and building the structure (dimensional model) that the data will reside in after it goes through the ETL process. Data architects also tie together the required technical functionality for the BI project. Multiple skills are needed: expertise in dimensional modeling is required, as well as a deep sensitivity to the requirements of the business. Also imperative is expertise with ETL functions such as SQL Server Integration Services, and experience in conducting ETL tasks. Hardware infrastructure and supporting software skills are also necessary.

» Business Intelligence Glossary