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  |  Technology Skills  |  Tools Used  |  Detailed Work Activities  |  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.
  • 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.

Find occupations related to multiple tasks

back to top

Technology Skills

  • Analytical or scientific software — SAS Hot technology ; SPSS Hot technology ; StataCorp Stata Hot technology ; The MathWorks MATLAB Hot technology
  • Application server software — Oracle WebLogic Server Hot technology
  • Backup or archival software — Veritas NetBackup Hot technology
  • Business intelligence and data analysis software — IBM Cognos Impromptu Hot technology ; MicroStrategy Hot technology ; Qlik Tech QlikView Hot technology ; TIBCO Spotfire (see all 6 examples)
  • Clustering software — Aster Data nCluster
  • Communications server software — IBM Domino Hot technology
  • Configuration management software — Perforce Helix software Hot technology
  • Customer relationship management CRM software — Blackbaud The Raiser's Edge Hot technology
  • Data base management system software — Apache Hadoop Hot technology ; Apache Oozie; Apache Pig Hot technology ; Oracle PL/SQL Hot technology (see all 24 examples)
  • Data base reporting software — IBM Netezza TwinFin; Microsoft SQL Server Reporting Services Hot technology ; Oracle SQL Loader; SAP Crystal Reports Hot technology (see all 5 examples)
  • Data base user interface and query software — Apache Hive Hot technology ; Cloudera Impala; Structured query language SQL Hot technology ; Teradata BTEQ (see all 8 examples)
  • Data mining software — Rapid-I RapidMiner; SAP NetWeaver Business Warehouse; Teradata Parallel Transporter; Teradata Tpump (see all 5 examples)
  • Development environment software — C Hot technology ; Common business oriented language COBOL Hot technology ; Microsoft .NET Framework Hot technology ; Microsoft Visual Basic Scripting Edition VBScript Hot technology (see all 8 examples)
  • Document management software — Teradata FastExport
  • Electronic mail software — Microsoft Outlook Hot technology
  • Enterprise application integration software — Extensible markup language XML Hot technology ; IBM WebSphere Hot technology ; SMSi Twister Data Integrator; Talend Open Studio (see all 6 examples)
  • Enterprise resource planning ERP software Hot technology — IBM Clarity Systems Clarity; Oracle Hyperion Hot technology ; Oracle PeopleSoft Hot technology ; SAP Hot technology (see all 6 examples)
  • Enterprise system management software — Splunk Enterprise Hot technology
  • File versioning software — Apache Subversion SVN Hot technology
  • Graphics or photo imaging software — Microsoft Visio Hot technology
  • Information retrieval or search software — Apache Avro
  • Map creation software — ESRI ArcGIS software Hot technology
  • Metadata management software — CA Erwin Data Modeler Hot technology ; Oracle Warehouse Builder; SAS Data Integration Server; Talend Data Fabric (see all 16 examples)
  • Network monitoring software — Nagios Hot technology
  • Object or component oriented development software — C++ Hot technology ; Objective C Hot technology ; Python Hot technology ; Spark (see all 8 examples)
  • Object oriented data base management software — PostgreSQL Hot technology
  • Office suite software — Microsoft Office
  • Operating system software — Apple Macintosh OS; Linux Hot technology ; Oracle Solaris Hot technology ; Ubuntu Hot technology (see all 10 examples)
  • Portal server software — Apache HTTP Server Hot technology
  • Presentation software — Microsoft PowerPoint Hot technology
  • Project management software — Microsoft Project Hot technology ; Microsoft SharePoint Hot technology
  • Requirements analysis and system architecture software — Unified modeling language UML Hot technology
  • Spreadsheet software — Microsoft Excel Hot technology
  • Transaction security and virus protection software — McAfee Hot technology ; Symantec Hot technology
  • Web platform development software — Ruby on Rails Hot technology
  • Word processing software — Microsoft Word

Hot technology Hot Technology — a technology requirement frequently included in employer job postings.

back to top

Tools Used

  • 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

back to top

Detailed Work Activities

  • Develop procedures for data management.
  • Design software applications.
  • Develop diagrams or flow charts of system operation.
  • Develop models of information or communications systems.
  • Document operational procedures.
  • Write computer programming code.
  • Analyze data to identify trends or relationships among variables.
  • Create databases to store electronic data.
  • Develop performance metrics or standards related to information technology.
  • Develop testing routines or procedures.
  • Evaluate data quality.
  • Evaluate project designs to determine adequacy or feasibility.
  • Modify software programs to improve performance.
  • Test software performance.
  • Troubleshoot issues with computer applications or systems.

Find occupations related to multiple detailed work activities

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 (2016) $41.59 hourly, $86,510 annual
State wages Local Salary Info
 
Employment (2014) 233,000 employees
Projected growth (2014-2024) Slower than average (2% to 4%) Slower than average (2% to 4%)
Projected job openings (2014-2024) 37,700
State trends Employment Trends
 
Top industries (2014)

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

back to top

Job Openings on the Web

Find Jobs

back to top