Skip navigation

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.

This title represents an occupation for which data collection is currently underway.

View report: Summary  Details  Custom

Tasks  |  Tools & Technology  |  Detailed Work Activities  |  Credentials  |  Interests  |  Work Values  |  Wages & Employment  |  Job Openings

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. See more occupations related to this task.
  • Develop data warehouse process models, including sourcing, loading, transformation, and extraction. See more occupations related to this task.
  • Create or implement metadata processes and frameworks. See more occupations related to this task.
  • Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing. See more occupations related to this task.
  • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. See more occupations related to this task.
  • Design and implement warehouse database structures. See more occupations related to this task.
  • Develop and implement data extraction procedures from other systems, such as administration, billing, or claims. See more occupations related to this task.
  • 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. See more occupations related to this task.
  • Implement business rules via stored procedures, middleware, or other technologies. See more occupations related to this task.
  • Map data between source systems, data warehouses, and data marts. See more occupations related to this task.
  • Perform system analysis, data analysis or programming, using a variety of computer languages and procedures. See more occupations related to this task.
  • Select methods, techniques, or criteria for data warehousing evaluative procedures. See more occupations related to this task.
  • Verify the structure, accuracy, or quality of warehouse data. See more occupations related to this task.
  • Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies. See more occupations related to this task.
  • Prepare functional or technical documentation for data warehouses. See more occupations related to this task.
  • Provide or coordinate troubleshooting support for data warehouses. See more occupations related to this task.
  • Review designs, codes, test plans, or documentation to ensure quality. See more occupations related to this task.
  • Test software systems or applications for software enhancements or new products. See more occupations related to this task.

Find occupations related to multiple tasks

back to top

Tools & Technology   Save Table (XLS/CSV)

Tools used in this occupation:

  • Computer servers — Storage servers See more occupations related to this tool.
  • Desktop computers See more occupations related to this tool.
  • High end computer servers — Data warehouse appliances See more occupations related to this tool.
  • Mainframe computers See more occupations related to this tool.
  • Notebook computers — Laptop computers See more occupations related to this tool.
  • Personal computers See more occupations related to this tool.
  • Special purpose telephones — Multi-line telephone systems See more occupations related to this tool.

Technology used in this occupation:

  • Analytical or scientific software — SAS Hot technology ; SPSS Hot technology ; StataCorp Stata Hot technology ; The MathWorks MATLAB Hot technology See more occupations related to this technology.
  • Application server software — Oracle WebLogic Server Hot technology See more occupations related to this technology.
  • Backup or archival software — Veritas NetBackup Hot technology See more occupations related to this technology.
  • Business intelligence and data analysis software — IBM Cognos Impromptu Hot technology ; Qlik Tech QlikView Hot technology ; Tableau Hot technology ; TIBCO Spotfire (see all 6 examples) See more occupations related to this technology.
  • Clustering software — Aster Data nCluster See more occupations related to this technology.
  • Communications server software — IBM Domino Hot technology See more occupations related to this technology.
  • Configuration management software — Perforce Helix software Hot technology See more occupations related to this technology.
  • Customer relationship management CRM software — Blackbaud The Raiser's Edge Hot technology See more occupations related to this technology.
  • Data base management system software — Apache Hadoop Hot technology ; Apache Oozie; Oracle PL/SQL Hot technology ; Teradata Database Hot technology (see all 24 examples) See more occupations related to this technology.
  • 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) See more occupations related to this technology.
  • 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) See more occupations related to this technology.
  • Data mining software — Rapid-I RapidMiner; SAP NetWeaver Business Warehouse; Teradata Parallel Transporter; Teradata Tpump (see all 5 examples) See more occupations related to this technology.
  • 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) See more occupations related to this technology.
  • Document management software — Teradata FastExport See more occupations related to this technology.
  • Electronic mail software — Microsoft Outlook Hot technology See more occupations related to this 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) See more occupations related to this technology.
  • 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) See more occupations related to this technology.
  • Enterprise system management software — Splunk Enterprise Hot technology See more occupations related to this technology.
  • File versioning software — Apache Subversion SVN Hot technology See more occupations related to this technology.
  • Graphics or photo imaging software — Microsoft Visio Hot technology See more occupations related to this technology.
  • Information retrieval or search software — Apache Avro See more occupations related to this technology.
  • Map creation software — ESRI ArcGIS software Hot technology See more occupations related to this technology.
  • Metadata management software — CA Erwin Data Modeler Hot technology ; Oracle Warehouse Builder; SAS Data Integration Server; Talend Data Fabric (see all 16 examples) See more occupations related to this technology.
  • Network monitoring software — Nagios Hot technology See more occupations related to this technology.
  • Object or component oriented development software — C++ Hot technology ; Objective C Hot technology ; Python Hot technology ; Spark (see all 8 examples) See more occupations related to this technology.
  • Object oriented data base management software — PostgreSQL Hot technology See more occupations related to this technology.
  • Office suite software — Microsoft Office See more occupations related to this technology.
  • Operating system software — Apple Macintosh OS; Linux Hot technology ; Oracle Solaris Hot technology ; Ubuntu Hot technology (see all 10 examples) See more occupations related to this technology.
  • Presentation software — Microsoft PowerPoint Hot technology See more occupations related to this technology.
  • Project management software — Microsoft Project Hot technology ; Microsoft SharePoint Hot technology See more occupations related to this technology.
  • Requirements analysis and system architecture software — Unified modeling language UML Hot technology See more occupations related to this technology.
  • Spreadsheet software — Microsoft Excel Hot technology See more occupations related to this technology.
  • Transaction security and virus protection software — McAfee Hot technology ; Symantec Hot technology See more occupations related to this technology.
  • Web platform development software — Ruby on Rails Hot technology See more occupations related to this technology.
  • Word processing software — Microsoft Word See more occupations related to this technology.

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

back to top

Detailed Work Activities   Save Table (XLS/CSV)

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

Find occupations related to multiple detailed work activities

back to top

Credentials

Find Training Find Certifications

back to top

Interests   Save Table (XLS/CSV)


Occupational Interest
Interest
78 
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.See more occupations related to this interest.
61 
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.See more occupations related to this interest.
33 
Enterprising — Enterprising occupations frequently involve starting up and carrying out projects. These occupations can involve leading people and making many decisions. Sometimes they require risk taking and often deal with business.See more occupations related to this interest.
17 
Artistic — Artistic occupations frequently involve working with forms, designs and patterns. They often require self-expression and the work can be done without following a clear set of rules.See more occupations related to this interest.
11 
Realistic — Realistic occupations frequently involve work activities that include practical, hands-on problems and solutions. They often deal with plants, animals, and real-world materials like wood, tools, and machinery. Many of the occupations require working outside, and do not involve a lot of paperwork or working closely with others.See more occupations related to this interest.
11 
Social — Social occupations frequently involve working with, communicating with, and teaching people. These occupations often involve helping or providing service to others.See more occupations related to this interest.

back to top

Work Values   Save Table (XLS/CSV)


Extent
Work Value
83 
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.See more occupations related to this work value.
72 
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.See more occupations related to this work value.
67 
Independence — Occupations that satisfy this work value allow employees to work on their own and make decisions. Corresponding needs are Creativity, Responsibility and Autonomy.See more occupations related to this work value.
50 
Recognition — Occupations that satisfy this work value offer advancement, potential for leadership, and are often considered prestigious. Corresponding needs are Advancement, Authority, Recognition and Social Status.See more occupations related to this work value.
50 
Support — Occupations that satisfy this work value offer supportive management that stands behind employees. Corresponding needs are Company Policies, Supervision: Human Relations and Supervision: Technical.See more occupations related to this work value.
28 
Relationships — Occupations that satisfy this work value allow employees to provide service to others and work with co-workers in a friendly non-competitive environment. Corresponding needs are Co-workers, Moral Values and Social Service.See more occupations related to this work value.

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 (2015) $40.98 hourly, $85,240 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)
Government (38% employed in this sector)

Source: Bureau of Labor Statistics 2015 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