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.

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