Details Report for:
15-1199.07 - Data Warehousing Specialists
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
The occupation code you requested, 15-1099.09 (Data Warehousing Specialists), is no longer in use. In the future, please use 15-1199.07 (Data Warehousing Specialists) instead.
This title represents an occupation for which data collection is currently underway.
Tasks | Tools & Technology | Wages & Employment | Additional Information
Tasks Save Table (XLS/CSV)
- 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.
- Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- Create or implement metadata processes and frameworks.
- Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
- Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
- Design and implement warehouse database structures.
- 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.
- Implement business rules via stored procedures, middleware, or other technologies.
- Map data between source systems, data warehouses, and data marts.
- Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
- Select methods, techniques, or criteria for data warehousing evaluative procedures.
- Verify the structure, accuracy, or quality of warehouse data.
- Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
- Prepare functional or technical documentation for data warehouses.
- Provide or coordinate troubleshooting support for data warehouses.
- Review designs, codes, test plans, or documentation to ensure quality.
- Test software systems or applications for software enhancements or new products.
Tools & Technology Save Table (XLS/CSV)
Tools used in this occupation:
| Computer servers — Storage servers |
| Desktop computers |
| High end computer servers — Data warehouse appliances |
| Mainframe computers |
| Notebook computers — Laptop computers |
| Personal computers |
| Special purpose telephones — Multi-line telephone systems |
Technology used in this occupation:
| Analytical or scientific software — SAS software; SPSS software; TIBCO Spotfire |
| Data base management system software — Microsoft SQL Server; Oracle software; SAP Sybase IQ; Talendforge * (see all 12 examples) |
| Data base reporting software — IBM Netezza TwinFin; Oracle Business Intelligence Discoverer; Oracle SQL Loader; SAP BusinessObjects software (see all 6 examples) |
| Data base user interface and query software — Microsoft Access; Structured query language SQL; Teradata BTEQ; Transact SQL (see all 5 examples) |
| Data mining software — IBM Cognos Business Intelligence; Rapid-I RapidMiner *; Teradata Parallel Transporter; Teradata Tpump (see all 6 examples) |
| Development environment software — Adeptia ETL Suite; C; CloverETL * |
| Document management software — Teradata FastExport |
| Electronic mail software — Microsoft Outlook |
| Enterprise application integration software — IBM InfoSphere DataStage; Jitterbit; SMSi Twister Data Integrator; Talend Open Studio * |
| Metadata management software — Altova MapForce; Apatar *; Oracle Warehouse Builder; SAS Data Integration Server (see all 15 examples) |
| Object or component oriented development software — C++; Python |
| Operating system software — Apple Macintosh OS; Linux; Microsoft Windows; UNIX |
| Spreadsheet software — Microsoft Excel |
* Software developed by a government agency and/or distributed as freeware or shareware.
Wages & Employment Trends
National
Median wages data collected from Computer Occupations, All Other*.
Employment data collected from Computer Specialists, All Other.
Industry data collected from Computer Specialists, All Other.
| Median wages (2010) | $38.10 hourly, $79,240 annual |
| Employment (2008) | 209,000 employees |
| Projected growth (2008-2018) | 
Average (7% to 13%)
|
| Projected job openings (2008-2018) | 72,600 |
| Top industries (2008) | Government (37% employed in this sector)
|
State & National
Source: Bureau of Labor Statistics 2010 wage data
and 2008-2018 employment projections
.
"Projected growth" represents the estimated change in total employment over the projections period (2008-2018). "Projected job openings" represent openings due to growth and replacement.
Sources of Additional Information
Disclaimer: Sources are listed to provide additional information on related jobs, specialties, and/or industries. Links to non-DOL Internet sites are provided for your convenience and do not constitute an endorsement.
- Computer network, systems, and database administrators
. Bureau of Labor Statistics, U.S. Department of Labor. Occupational Outlook Handbook, 2010-11 Edition.