Summary 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.
This title represents an occupation for which data collection is currently underway.
Tasks | Tools & Technology | Work Values | Wages & Employment | Job Openings
Tasks
- 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.
Tools & Technology
Tools used in this occupation:
| Computer servers — Storage servers |
| High end computer servers — Data warehouse appliances |
| Mainframe computers |
| Notebook computers — Laptop computers |
| Special purpose telephones — Multi-line telephone systems |
Technology used in this occupation:
| Data base management system software — Microsoft SQL Server; Oracle software; SAP Sybase IQ; Talendforge * |
| Data base reporting software — IBM Netezza TwinFin; Oracle Business Intelligence Discoverer; Oracle SQL Loader; SAP BusinessObjects software |
| Data base user interface and query software — Microsoft Access; Structured query language SQL; Teradata BTEQ; Transact SQL |
| Data mining software — IBM Cognos Business Intelligence; Rapid-I RapidMiner *; Teradata Parallel Transporter; Teradata Tpump |
| Metadata management software — Altova MapForce; Apatar *; Oracle Warehouse Builder; SAS Data Integration Server |
* Software developed by a government agency and/or distributed as freeware or shareware.
Work Values
| Achievement — Occupations that satisfy this work value are results oriented and allow employees to use their strongest abilities, giving them a feeling of accomplishment. Corresponding needs are Ability Utilization and Achievement. |
| Working Conditions — Occupations that satisfy this work value offer job security and good working conditions. Corresponding needs are Activity, Compensation, Independence, Security, Variety and Working Conditions. |
| Independence — Occupations that satisfy this work value allow employees to work on their own and make decisions. Corresponding needs are Creativity, Responsibility and Autonomy. |
Wages & Employment Trends
National
Median wages data collected from Computer Occupations, All Other.
Employment data collected from Computer Occupations, All Other.
Industry data collected from Computer Occupations, All Other.
| Median wages (2012) | $39.01 hourly, $81,140 annual |
| Employment (2010) | 210,000 employees |
| Projected growth (2010-2020) | 
Slower than average (3% to 9%)
|
| Projected job openings (2010-2020) | 51,600 |
| Top industries (2010) |
State & National
Source: Bureau of Labor Statistics 2012 wage data
and 2010-2020 employment projections
.
"Projected growth" represents the estimated change in total employment over the projections period (2010-2020). "Projected job openings" represent openings due to growth and replacement.
