45 lines
2.9 KiB
Markdown
45 lines
2.9 KiB
Markdown
# Tasks & work activities — data warehouse designer
|
|
|
|
Source: O*NET 30.3, occupation 15-1243.01 (Data Warehousing Specialists).
|
|
|
|
## Task statements
|
|
|
|
- **[Core]** Test software systems or applications for software enhancements or new products.
|
|
- **[Core]** Review designs, codes, test plans, or documentation to ensure quality.
|
|
- **[Core]** Provide or coordinate troubleshooting support for data warehouses.
|
|
- **[Core]** Prepare functional or technical documentation for data warehouses.
|
|
- **[Core]** Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
|
|
- **[Core]** Verify the structure, accuracy, or quality of warehouse data.
|
|
- **[Core]** Select methods, techniques, or criteria for data warehousing evaluative procedures.
|
|
- **[Core]** Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
|
|
- **[Core]** Map data between source systems, data warehouses, and data marts.
|
|
- **[Core]** Implement business rules via stored procedures, middleware, or other technologies.
|
|
- **[Core]** Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
|
|
- **[Core]** 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.
|
|
- **[Core]** Design and implement warehouse database structures.
|
|
- **[Core]** Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
|
|
- **[Core]** Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
|
|
- **[Core]** Create or implement metadata processes and frameworks.
|
|
- **[Core]** Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
|
|
- **[Core]** 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.
|
|
|
|
## Detailed work activities
|
|
|
|
- Analyze data to identify trends or relationships among variables.
|
|
- Apply information technology to solve business or other applied problems.
|
|
- Apply new technologies to improve work processes.
|
|
- Create databases to store electronic data.
|
|
- Design software applications.
|
|
- Develop diagrams or flow charts of system operation.
|
|
- Develop models of information or communications systems.
|
|
- Develop performance metrics or standards related to information technology.
|
|
- Develop procedures for data management.
|
|
- Develop testing routines or procedures.
|
|
- Document operational procedures.
|
|
- Evaluate data quality.
|
|
- Evaluate project designs to determine adequacy or feasibility.
|
|
- Modify software programs to improve performance.
|
|
- Test software performance.
|
|
- Troubleshoot issues with computer applications or systems.
|
|
- Write computer programming code.
|