According to people in this career, the main tasks are...
| Task | Importance |
|---|---|
| Develop data warehouse process models, including sourcing, loading, transformation, and extraction. | 88% |
| Verify the structure, accuracy, or quality of warehouse data. | 88% |
| Map data between source systems, data warehouses, and data marts. | 84% |
| Develop and implement data extraction procedures from other systems, such as administration, billing, or claims. | 82% |
| Design and implement warehouse database structures. | 81% |
| Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases. | 79% |
| Provide or coordinate troubleshooting support for data warehouses. | 78% |
| Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies. | 78% |
| Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements. | 77% |
| Perform system analysis, data analysis or programming, using a variety of computer languages and procedures. | 76% |
| Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. | 75% |
| Create or implement metadata processes and frameworks. | 74% |
| Review designs, codes, test plans, or documentation to ensure quality. | 72% |
| Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing. | 72% |
| Select methods, techniques, or criteria for data warehousing evaluative procedures. | 71% |
| Implement business rules via stored procedures, middleware, or other technologies. | 71% |
| Prepare functional or technical documentation for data warehouses. | 66% |
| Test software systems or applications for software enhancements or new products. | 63% |
