# Data Warehousing Specialists

> Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.

- Code: 15-1243.01 (O*NET-SOC; SOC 2018 15-1243)
- Family: [Computer & Mathematical](https://foundation.org.ai/occupations#family-15), one of its 38 occupations
- Tasks: 18 tasks (18 core)
- Page: https://foundation.org.ai/occupations/15-1243.01
- JSON: https://foundation.org.ai/data/tasks/15-1243.01.json

## What the work is made of

1. Develop data warehouse process models, including sourcing, loading, transformation, and extraction.  
   Core task · Task 16132 · Rated by 23 occupational experts, August 2018
2. Verify the structure, accuracy, or quality of warehouse data.  
   Core task · Task 16121 · Rated by 23 occupational experts, August 2018
3. Map data between source systems, data warehouses, and data marts.  
   Core task · Task 16124 · Rated by 23 occupational experts, August 2018
4. Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.  
   Core task · Task 16126 · Rated by 23 occupational experts, August 2018
5. Design and implement warehouse database structures.  
   Core task · Task 16128 · Rated by 23 occupational experts, August 2018
6. 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 task · Task 16127 · Rated by 23 occupational experts, August 2018
7. Provide or coordinate troubleshooting support for data warehouses.  
   Core task · Task 16118 · Rated by 23 occupational experts, August 2018
8. Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.  
   Core task · Task 16120 · Rated by 23 occupational experts, August 2018
9. 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.  
   Core task · Task 16133 · Rated by 23 occupational experts, August 2018
10. Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.  
   Core task · Task 16123 · Rated by 23 occupational experts, August 2018
11. Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.  
   Core task · Task 16129 · Rated by 23 occupational experts, August 2018
12. Create or implement metadata processes and frameworks.  
   Core task · Task 16131 · Rated by 23 occupational experts, August 2018
13. Review designs, codes, test plans, or documentation to ensure quality.  
   Core task · Task 16117 · Rated by 23 occupational experts, August 2018
14. Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.  
   Core task · Task 16130 · Rated by 23 occupational experts, August 2018
15. Select methods, techniques, or criteria for data warehousing evaluative procedures.  
   Core task · Task 16122 · Rated by 23 occupational experts, August 2018
16. Implement business rules via stored procedures, middleware, or other technologies.  
   Core task · Task 16125 · Rated by 23 occupational experts, August 2018
17. Prepare functional or technical documentation for data warehouses.  
   Core task · Task 16119 · Rated by 23 occupational experts, August 2018
18. Test software systems or applications for software enhancements or new products.  
   Core task · Task 16116 · Rated by 23 occupational experts, August 2018

## More in Computer & Mathematical

- [Actuaries](https://foundation.org.ai/occupations/15-2011.00): 15 tasks
- [Bioinformatics Technicians](https://foundation.org.ai/occupations/15-2099.01): 19 tasks
- [Biostatisticians](https://foundation.org.ai/occupations/15-2041.01): 25 tasks
- [Blockchain Engineers](https://foundation.org.ai/occupations/15-1299.07): 17 tasks
- [Business Intelligence Analysts](https://foundation.org.ai/occupations/15-2051.01): 17 tasks
- [Clinical Data Managers](https://foundation.org.ai/occupations/15-2051.02): 21 tasks
- [Computer and Information Research Scientists](https://foundation.org.ai/occupations/15-1221.00): 15 tasks
- [Computer Network Architects](https://foundation.org.ai/occupations/15-1241.00): 33 tasks
- [Computer Network Support Specialists](https://foundation.org.ai/occupations/15-1231.00): 26 tasks
- [Computer Occupations, All Other](https://foundation.org.ai/occupations/15-1299.00): no tasks listed
- [Computer Programmers](https://foundation.org.ai/occupations/15-1251.00): 17 tasks
- [Computer Systems Analysts](https://foundation.org.ai/occupations/15-1211.00): 22 tasks
- [Computer Systems Engineers/Architects](https://foundation.org.ai/occupations/15-1299.08): 28 tasks
- [Computer User Support Specialists](https://foundation.org.ai/occupations/15-1232.00): 16 tasks
- [Data Scientists](https://foundation.org.ai/occupations/15-2051.00): 16 tasks
- [Database Administrators](https://foundation.org.ai/occupations/15-1242.00): 18 tasks
- [Database Architects](https://foundation.org.ai/occupations/15-1243.00): 25 tasks
- [Digital Forensics Analysts](https://foundation.org.ai/occupations/15-1299.06): 20 tasks
- [Document Management Specialists](https://foundation.org.ai/occupations/15-1299.03): 23 tasks
- [Geographic Information Systems Technologists and Technicians](https://foundation.org.ai/occupations/15-1299.02): 29 tasks
- [Health Informatics Specialists](https://foundation.org.ai/occupations/15-1211.01): 17 tasks
- [Information Security Analysts](https://foundation.org.ai/occupations/15-1212.00): 11 tasks
- [Information Security Engineers](https://foundation.org.ai/occupations/15-1299.05): 20 tasks
- [Information Technology Project Managers](https://foundation.org.ai/occupations/15-1299.09): 21 tasks
- [Mathematical Science Occupations, All Other](https://foundation.org.ai/occupations/15-2099.00): no tasks listed
- [Mathematicians](https://foundation.org.ai/occupations/15-2021.00): 11 tasks
- [Network and Computer Systems Administrators](https://foundation.org.ai/occupations/15-1244.00): 20 tasks
- [Operations Research Analysts](https://foundation.org.ai/occupations/15-2031.00): 17 tasks
- [Penetration Testers](https://foundation.org.ai/occupations/15-1299.04): 22 tasks
- [Software Developers](https://foundation.org.ai/occupations/15-1252.00): 19 tasks
- [Software Quality Assurance Analysts and Testers](https://foundation.org.ai/occupations/15-1253.00): 30 tasks
- [Statisticians](https://foundation.org.ai/occupations/15-2041.00): 19 tasks
- [Telecommunications Engineering Specialists](https://foundation.org.ai/occupations/15-1241.01): 26 tasks
- [Video Game Designers](https://foundation.org.ai/occupations/15-1255.01): 24 tasks
- [Web Administrators](https://foundation.org.ai/occupations/15-1299.01): 35 tasks
- [Web and Digital Interface Designers](https://foundation.org.ai/occupations/15-1255.00): 30 tasks
- [Web Developers](https://foundation.org.ai/occupations/15-1254.00): 29 tasks

## Where this comes from

Quoted from O*NET 29.0, U.S. Department of Labor, Employment and Training Administration, under CC BY 4.0: free to copy and reuse, with credit. Nothing on this page is written by the Org.AI Foundation.
