Data Warehousing Specialists
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
- Tasks
- 18 tasks18 core
- Family
- Computer & MathematicalOne of its 38 occupations
- Code
- 15-1243.01SOC 2018: 15-1243
What the work is made of
All 18 are core tasks, each quoted as published, with the survey it came from.
Core: central to the job
- Task 1. Develop data warehouse process models, including sourcing, loading, transformation, and extraction.Core taskTask 16132Rated by 23 occupational experts, August 2018
- Task 2. Verify the structure, accuracy, or quality of warehouse data.Core taskTask 16121Rated by 23 occupational experts, August 2018
- Task 3. Map data between source systems, data warehouses, and data marts.Core taskTask 16124Rated by 23 occupational experts, August 2018
- Task 4. Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.Core taskTask 16126Rated by 23 occupational experts, August 2018
- Task 5. Design and implement warehouse database structures.Core taskTask 16128Rated by 23 occupational experts, August 2018
- Task 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 taskTask 16127Rated by 23 occupational experts, August 2018
- Task 7. Provide or coordinate troubleshooting support for data warehouses.Core taskTask 16118Rated by 23 occupational experts, August 2018
- Task 8. Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.Core taskTask 16120Rated by 23 occupational experts, August 2018
- Task 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 taskTask 16133Rated by 23 occupational experts, August 2018
- Task 10. Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.Core taskTask 16123Rated by 23 occupational experts, August 2018
- Task 11. Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.Core taskTask 16129Rated by 23 occupational experts, August 2018
- Task 12. Create or implement metadata processes and frameworks.Core taskTask 16131Rated by 23 occupational experts, August 2018
- Task 13. Review designs, codes, test plans, or documentation to ensure quality.Core taskTask 16117Rated by 23 occupational experts, August 2018
- Task 14. Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.Core taskTask 16130Rated by 23 occupational experts, August 2018
- Task 15. Select methods, techniques, or criteria for data warehousing evaluative procedures.Core taskTask 16122Rated by 23 occupational experts, August 2018
- Task 16. Implement business rules via stored procedures, middleware, or other technologies.Core taskTask 16125Rated by 23 occupational experts, August 2018
- Task 17. Prepare functional or technical documentation for data warehouses.Core taskTask 16119Rated by 23 occupational experts, August 2018
- Task 18. Test software systems or applications for software enhancements or new products.Core taskTask 16116Rated by 23 occupational experts, August 2018
Where this comes from
Quoted from the U.S. Department of Labor, and credited. Nothing on this page is written by us.
How we copy and credit sources- Published byO*NET 29.0, U.S. Department of LaborEmployment and Training Administration
- ClassificationStandard Occupational Classification 2018, 15-1243
- LicenseCC BY 4.0Free to copy and reuse, with credit
- Changed by usNothing.
More in Computer & Mathematical
37 other occupations in this family, each with its own page.
- Actuaries15 tasks
- Bioinformatics Technicians19 tasks
- Biostatisticians25 tasks
- Blockchain Engineers17 tasks
- Business Intelligence Analysts17 tasks
- Clinical Data Managers21 tasks
- Computer and Information Research Scientists15 tasks
- Computer Network Architects33 tasks
- Computer Network Support Specialists26 tasks
- Computer Occupations, All OtherNo tasks listed
- Computer Programmers17 tasks
- Computer Systems Analysts22 tasks
- Computer Systems Engineers/Architects28 tasks
- Computer User Support Specialists16 tasks
- Data Scientists16 tasks
- Database Administrators18 tasks
- Database Architects25 tasks
- Digital Forensics Analysts20 tasks
- Document Management Specialists23 tasks
- Geographic Information Systems Technologists and Technicians29 tasks
- Health Informatics Specialists17 tasks
- Information Security Analysts11 tasks
- Information Security Engineers20 tasks
- Information Technology Project Managers21 tasks
- Mathematical Science Occupations, All OtherNo tasks listed
- Mathematicians11 tasks
- Network and Computer Systems Administrators20 tasks
- Operations Research Analysts17 tasks
- Penetration Testers22 tasks
- Software Developers19 tasks
- Software Quality Assurance Analysts and Testers30 tasks
- Statisticians19 tasks
- Telecommunications Engineering Specialists26 tasks
- Video Game Designers24 tasks
- Web Administrators35 tasks
- Web and Digital Interface Designers30 tasks
- Web Developers29 tasks
Use this record
Every task on this page is free to reuse, with credit to O*NET. The code and data behind the record are public.
Partner with us
Fund the next pass, contribute data, or build on the record. Tell us what you have in mind.
Partner with us