-Design data platforms such as data marts, data stores, data warehouses -Design, develop and Implementation - Gather & document technical requirements, Review/develop data warehouse bus matrix, Select business process, Declare fact table grain, Identify dimensions, Identify metrics, Identify candidate data sources, Review data model with IT and management, Finalize logical design documentation, Create tables and indexes, Design high level ETL processes, Develop maintenance plans, Document the ETL system specifications.