Data Warehousing Specialists

Statistics
National
State
City
State
City
$134,700
Median Wage (USD, 2023)
4,200
Projected Job Openings (2022-2032)
10.80%
Projected Growth (2022-2032)

Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.

Experience Requirements Overview

  • Job Zone Four: Considerable Preparation Needed
  • A considerable amount of work-related skill, knowledge, or experience is needed for these occupations. For example, an accountant must complete four years of college and work for several years in accounting to be considered qualified.
  • Most of these occupations require a four-year bachelor's degree, but some do not.
  • Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.

Education, Training and Experience

Required Level of Education: Bachelor's Degree

Related Work Experience: Over 2 years, up to and including 4 years

On-Site or In-Plant Training: N.A.

On-the-Job Training: Over 1 month, up to and including 3 months

Detailed Work Activities

  • Test software performance.
  • Evaluate project designs to determine adequacy or feasibility.
  • Troubleshoot issues with computer applications or systems.
  • Document operational procedures.
  • Modify software programs to improve performance.

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

Recognition

Relationships

Support

Independence

Tasks

  • Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
  • Verify the structure, accuracy, or quality of warehouse data.
  • Map data between source systems, data warehouses, and data marts.
  • Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
  • Design and implement warehouse database structures.

Work Styles

Achievement/Effort

Job requires establishing and maintaining personally challenging achievement goals and exerting effort toward mastering tasks.

Persistence

Initiative

Leadership

Cooperation

Concern for Others

Social Orientation

Self-Control

Stress Tolerance

Adaptability/Flexibility

Dependability

Attention to Detail

Integrity

Independence

Innovation

Analytical Thinking

Data Source: This page includes information from the O*NET 28.0 Database by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA). Used under the CC BY 4.0 license. O*NET® is a trademark of USDOL/ETA. This page includes Employment Projections program, Occupational Employment and Wage Statistics program, U.S. Bureau of Labor Statistics.