Career Details
Career Details
Use this dropdown to update your zip code
Back to top
Career Details
15-1243.01 - Data Warehousing Specialists
15-1243.01 - Data Warehousing Specialists
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
Key Facts

Bright Outlook
Career Details
Green Job
Career Details
Current Employment
N/A
Estimate
Forecasted Employment
N/A
Estimate
Change in Employment
N/A
Estimate
Change in Employment %
N/A
Estimate
Tasks

Tasks
The tasks listed below can be performed to prepare you for a career in this field.
Core
- Test software systems or applications for software enhancements or new products.
- Review designs, codes, test plans, or documentation to ensure quality.
- Provide or coordinate troubleshooting support for data warehouses.
- Prepare functional or technical documentation for data warehouses.
- Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
- Verify the structure, accuracy, or quality of warehouse data.
- Select methods, techniques, or criteria for data warehousing evaluative procedures.
- Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
- Map data between source systems, data warehouses, and data marts.
- Implement business rules via stored procedures, middleware, or other technologies.
- Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
- 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.
- Design and implement warehouse database structures.
- Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
- Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
- Create or implement metadata processes and frameworks.
- Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- 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.
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Knowledge

Knowledge
The items listed below are organized into sections that contain knowledge useful for pursuing a career in this field. Each section also contains a "Percentage of Importance" statistic that shows how relevant an item is to the occupation.
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Tools

Tools
The tools listed below include machines, equipment, tools, and software that is useful for individuals who are interested in this career.
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Technology

Technology
The technologies listed below include machines, equipment, tools, and software that is useful for individuals who are interested in this career.
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Certifications

Certifications
The certifications listed below are useful to pursue if you are interested in a career in this field.
No specific certifications are listed for this career
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Licensing

Licensing
The licensing information below is organized into sections and is useful for pursuing if you are interested in a career in this field.
No specific licensing information is listed for this occupation in the area you have selected.
All data sourced from US Department of Labor, Employment & Training Administration O*Net Database.
Related Programs

Online Programs related to this career, offered by participating institution(s), are listed below.
Clicking on the Degree programs in the list below will take you away from the Careers page.
Clicking on the Degree programs in the list below will take you away from the Careers page.
INSTITUTION
PROGRAMS