Skip navigation

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.

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.

View report: Summary  Details  Custom

Tasks  |  Tools & Technology  |  Credentials  |  Interests  |  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.

back to top

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 — Rapid-I RapidMiner *; SAP NetWeaver Business Warehouse; 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.

back to top

Credentials

Find Training Find Certifications

back to top

Interests

Interest code: IC

Investigative — Investigative occupations frequently involve working with ideas, and require an extensive amount of thinking. These occupations can involve searching for facts and figuring out problems mentally.
Conventional — Conventional occupations frequently involve following set procedures and routines. These occupations can include working with data and details more than with ideas. Usually there is a clear line of authority to follow.

back to top

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.

back to top

Wages & Employment Trends

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 (2013) $39.59 hourly, $82,340 annual
State wages Local Salary Info
 
Employment (2012) 206,000 employees
Projected growth (2012-2022) Slower than average (3% to 7%) Slower than average (3% to 7%)
Projected job openings (2012-2022) 40,200
State trends Employment Trends
 
Top industries (2012)

Source: Bureau of Labor Statistics 2013 wage data external site and 2012-2022 employment projections external site. "Projected growth" represents the estimated change in total employment over the projections period (2012-2022). "Projected job openings" represent openings due to growth and replacement.

back to top

Job Openings on the Web

Find Jobs Job Banks

back to top