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.
- 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; TIBCO Spotfire
- Backup or archival software — Veritas NetBackup
- Business intelligence and data analysis software — IBM Cognos Impromptu; MicroStrategy software; Qlik Tech QlikView; Tableau software
- Clustering software — Aster Data nCluster
- Data base management system software — Apache Hadoop; SAP Sybase IQ; Sybase software; Teradata Database (see all 19 examples)
- Data base reporting software — IBM Netezza TwinFin; Microsoft SQL Server Reporting Services; MicroStrategy; SAP Crystal Reports (see all 6 examples)
- Data base user interface and query software — Microsoft Access; Structured query language SQL; Teradata BTEQ; Transact SQL (see all 5 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 Visual Basic; Microsoft Visual Basic Scripting Edition VBScript (see all 6 examples)
- Document management software — Teradata FastExport
- Electronic mail software — Microsoft Outlook
- Enterprise application integration software — IBM InfoSphere DataStage; IBM WebSphere; SMSi Twister Data Integrator; Talend Open Studio (see all 5 examples)
- Enterprise resource planning ERP software — IBM Clarity Systems Clarity; Oracle Hyperion software; Oracle PeopleSoft software; SAP Business Objects software (see all 5 examples)
- Enterprise system management software — Splunk Enterprise
- Graphics or photo imaging software — Microsoft Visio
- Metadata management software — Altova MapForce; CA Erwin Data Modeler; Oracle Warehouse Builder; SAS Data Integration Server (see all 16 examples)
- Network conferencing software — Microsoft SharePoint
- Object or component oriented development software — C++; Practical extraction and reporting language Perl; Python; R
- Object oriented data base management software — PostgreSQL software
- Office suite software — Microsoft Office software
- Operating system software — Apple Macintosh OS; KornShell; Oracle Solaris; UNIX (see all 8 examples)
- Presentation software — Microsoft PowerPoint
- Project management software — Microsoft Project
- Requirements analysis and system architecture software — Unified modeling language UML
- Spreadsheet software — Microsoft Excel
- Transaction security and virus protection software — Symantec security software
- Word processing software — Microsoft Word
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 (2014)||$40.10 hourly, $83,410 annual|
|Employment (2012)||206,000 employees|
|Projected growth (2012-2022)||Slower than average (3% to 7%)|
|Projected job openings (2012-2022)||40,200|
|Top industries (2012)|
Source: Bureau of Labor Statistics 2014 wage data and 2012-2022 employment projections . "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.