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  |  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.
  • 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.

back to top

Tools & Technology   Save Table (XLS/CSV)

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; TIBCO Spotfire
Data base management system software — Microsoft SQL Server; Oracle software; SAP Sybase IQ; Talendforge * (see all 12 examples)
Data base reporting software — IBM Netezza TwinFin; Oracle Business Intelligence Discoverer; Oracle SQL Loader; SAP BusinessObjects software (see all 6 examples)
Data base user interface and query software — Microsoft Access; Structured query language SQL; Teradata BTEQ; Transact SQL (see all 6 examples)
Data mining software — Rapid-I RapidMiner *; SAP NetWeaver Business Warehouse; Teradata Parallel Transporter; Teradata Tpump (see all 5 examples)
Development environment software — Adeptia ETL Suite; C; CloverETL *
Document management software — Teradata FastExport
Electronic mail software — Microsoft Outlook
Enterprise application integration software — IBM InfoSphere DataStage; Jitterbit; SMSi Twister Data Integrator; Talend Open Studio *
Metadata management software — Altova MapForce; Apatar *; Oracle Warehouse Builder; SAS Data Integration Server (see all 15 examples)
Object or component oriented development software — C++; Python
Operating system software — Apple Macintosh OS; Linux; Microsoft Windows; UNIX
Spreadsheet software — Microsoft Excel

* Software developed by a government agency and/or distributed as freeware or shareware.

See all 30 T2 categories

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.
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.
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.
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.
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.
11   Social — Social occupations frequently involve working with, communicating with, and teaching people. These occupations often involve helping or providing service to others.

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.
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.
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.
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.
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.
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.

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 (2013) $39.59 hourly, $82,340 annual
State wages Local Salary Info
 
Employment (2012) 206,000 employees
Projected growth (2012-2022) Slower than average (3% to 7%) Slower than average (3% to 7%)
Projected job openings (2012-2022) 40,200
State trends Employment Trends
 
Top industries (2012)
Government (44% employed in this sector)

Source: Bureau of Labor Statistics 2013 wage data external site and 2012-2022 employment projections external site. "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.

back to top

Job Openings on the Web

Find Jobs Job Banks

back to top