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.
- 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.
Tools & Technology
Tools used in this occupation:
- 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
Technology used in this occupation:
- Analytical or scientific software — SAS software ; SPSS software ; StataCorp Stata ; The MathWorks MATLAB
- Backup or archival software — Veritas NetBackup
- Business intelligence and data analysis software — IBM Cognos Impromptu ; Oracle Business Intelligence Enterprise Edition ; Tableau software ; TIBCO Spotfire (see all 6 examples)
- Clustering software — Aster Data nCluster
- Customer relationship management CRM software — Blackbaud The Raiser's Edge
- Data base management system software — Apache Hadoop ; Apache Oozie; Talend Big Data Integration; Teradata Database (see all 24 examples)
- Data base reporting software — IBM Netezza TwinFin; Microsoft SQL Server Reporting Services ; Oracle SQL Loader; SAP Crystal Reports (see all 5 examples)
- Data base user interface and query software — Apache Hive; Cloudera Impala; Structured query language SQL ; 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 ; Common business oriented language COBOL ; Microsoft .NET Framework ; Microsoft Visual Basic Scripting Edition VBScript (see all 8 examples)
- Document management software — Teradata FastExport
- Electronic mail software — Microsoft Outlook
- Enterprise application integration software — Extensible markup language XML ; IBM WebSphere ; SMSi Twister Data Integrator; Talend Open Studio (see all 6 examples)
- Enterprise resource planning ERP software — IBM Clarity Systems Clarity; Oracle Hyperion software ; Oracle PeopleSoft software ; SAP software (see all 6 examples)
- Enterprise system management software — Splunk Enterprise
- Graphics or photo imaging software — Microsoft Visio
- Information retrieval or search software — Apache Avro
- Map creation software — ESRI ArcGIS software
- Metadata management software — CA Erwin Data Modeler ; Oracle Warehouse Builder; SAS Data Integration Server; Talend Data Fabric (see all 16 examples)
- Object or component oriented development software — C++ ; Objective C ; Python ; Spark (see all 8 examples)
- Object oriented data base management software — PostgreSQL software
- Office suite software — Microsoft Office software
- Operating system software — Apple Macintosh OS; KornShell ; Linux ; Oracle Solaris (see all 9 examples)
- Presentation software — Microsoft PowerPoint
- Project management software — Microsoft Project ; Microsoft SharePoint software
- Requirements analysis and system architecture software — Unified modeling language UML
- Spreadsheet software — Microsoft Excel
- Transaction security and virus protection software — McAfee software ; Symantec security software
- Web platform development software — Ruby on Rails
- Word processing software — Microsoft Word
Hot Technology — a technology requirement frequently included in employer job postings.
Detailed Work Activities
- Analyze data to identify trends or relationships among variables.
- Develop testing routines or procedures.
- Develop procedures for data management.
- Develop performance metrics or standards related to information technology.
- Create databases to store electronic data.
- Modify software programs to improve performance.
- Evaluate data quality.
- Test software performance.
- Design software applications.
- Troubleshoot issues with computer applications or systems.
- Develop models of information or communications systems.
- Write computer programming code.
- Evaluate project designs to determine adequacy or feasibility.
- Document operational procedures.
- Develop diagrams or flow charts of system operation.
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.
- 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
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|
|Employment (2014)||233,000 employees|
|Projected growth (2014-2024)||Slower than average (2% to 4%)|
|Projected job openings (2014-2024)||37,700|
|Top industries (2014)|
Source: Bureau of Labor Statistics 2015 wage data and 2014-2024 employment projections . "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.