Log In

Register

Recover Password

2020 Data Warehousing Specialists Salary Guide

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

Data Warehousing Specialists Salary

Salary

$88.6K

Growth

10%

Bright Outlook

Bright

Green

No

What Do Data Warehousing Specialists Do?

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

Also known as:

Data Warehouse Solution Architect, Data Warehouse Manager, Data Warehouse Analyst

How Much Do Data Warehousing Specialists Make ? 2020 Data Warehousing Specialists Salary Guide

Percentile 10% 25% 50% (Median) 75% 90%
Annual Wage $43,780 $62,620 $88,550 $117,260 $146,440
Hourly Wage $21.05 $30.10 $42.57 $56.38 $70.40

How Much Do Data Warehousing Specialists Make ? 2020 Data Warehousing Specialists Salary Guide

Percentile
10%
25%
50% (Median)
75%
90%
Annual Wage
$43,780
$62,620
$88,550
$117,260
$146,440
Hourly Wage
$21.05
$30.10
$42.57
$56.38
$70.40

What Tasks Do Data Warehousing Specialists Perform? 2020 Data Warehousing Specialists Salary Guide

  • 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.
  • 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.
  • Provide or coordinate troubleshooting support for data warehouses.
  • Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
  • 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.
  • Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
  • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
  • Create or implement metadata processes and frameworks.
  • Review designs, codes, test plans, or documentation to ensure quality.
  • Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
  • Select methods, techniques, or criteria for data warehousing evaluative procedures.
  • Prepare functional or technical documentation for data warehouses.
  • Test software systems or applications for software enhancements or new products.

What Activities Do Data Warehousing Specialists Do? 2020 Data Warehousing Specialists Salary Guide

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

Typical Data Warehousing Specialists Knowledge? 2020 Data Warehousing Specialists Salary Guide

  • Computers and Electronics - Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.

What Are Typical Data Warehousing Specialists Abilities? 2020 Data Warehousing Specialists Salary Guide

  • Information Ordering - Ordering or arranging things.
  • Written Comprehension - Reading and understanding what is written.
  • Deductive Reasoning - Using rules to solve problems.
  • Oral Comprehension - Listening and understanding what people say.
  • Inductive Reasoning - Making general rules or coming up with answers from lots of detailed information.
  • Near Vision - Seeing details up close.
  • Oral Expression - Communicating by speaking.
  • Written Expression - Communicating by writing.
  • Category Flexibility - Grouping things in different ways.
  • Speech Recognition - Recognizing spoken words.
  • Problem Sensitivity - Noticing when problems happen.
  • Speech Clarity - Speaking clearly.

What Are Typical Data Warehousing Specialists Skills? 2020 Salary Guide

  • Critical Thinking - Thinking about the pros and cons of different ways to solve a problem.
  • Reading Comprehension - Reading work-related information.
  • Programming - Writing computer programs.
  • Complex Problem Solving - Noticing a problem and figuring out the best way to solve it.
  • Systems Analysis - Figuring out how a system should work and how changes in the future will affect it.
  • Active Listening - Listening to others, not interrupting, and asking good questions.
  • Speaking - Talking to others.
  • Judgment and Decision Making - Thinking about the pros and cons of different options and picking the best one.

What Are Typical Data Warehousing Specialists Interests? 2020 Data Warehousing Specialists Salary Guide

  • Conventional - Occupations related to Conventional interests frequently involve following set procedures and routines. They include working with data and details more than with ideas. Usually there is a clear line of authority to follow.
  • Investigative - Occupations with Investigative interests frequently involve working with ideas, and require an extensive amount of thinking. They often involve research and figuring out problems mentally.

What Is The Projected Employment For Data Warehousing Specialists ? 2020 Data Warehousing Specialists Salary Guide

Location 2018 Employment 2028 Employment Percent change Annual projected job openings
United States 412,800 455,000 10% 35,700

What Is The Projected Employment For Data Warehousing Specialists ? 2020 Data Warehousing Specialists Salary Guide

Location
2018 Employment
2028 Employment
Percent change
Annual projected job openings
United States
412,800
455,000
10%
35,700

What Is The Required Data Warehousing Specialists Education & Experience? 2020 Data Warehousing Specialists Salary Guide

  • Bachelor's degree
  • No work experience
  • No on-the-job training

Where Can I Find Data Warehousing Specialists Training In ? 2020 Data Warehousing Specialists Salary Guide

School Program Name Location Length / Graduates
Aaniiih Nakoda College Computer and Information Sciences, General Harlem, MT 2 years: 2
Abilene Christian University Computer Science Abilene, TX 4 years: 20
Academy College Computer and Information Sciences, General Bloomington, MN 4 years: 1
Ace Institute of Technology Information Science/Studies New York, NY At least one but less than two years: 59
Adelphi University Computer and Information Sciences, General Garden City, NY 4 years: 31
Adelphi University Information Science/Studies Garden City, NY 4 years: 15
Adirondack Community College Computer Science Queensbury, NY 2 years: 13
Advanced Training Associates Computer and Information Sciences, General El Cajon, CA 2 years: 12
Less than one year: 16
Aiken Technical College Data Processing and Data Processing Technology/Technician Graniteville, SC 2 years: 6
Less than one year: 3
Aims Community College Computer and Information Sciences, General Greeley, CO 2 years: 7
Less than one year: 7

Where Can I Find Data Warehousing Specialists Training In ? 2020 Data Warehousing Specialists Salary Guide

School
Program Name
Location
Length / Graduates
Computer and Information Sciences, General
Harlem, MT
2 years: 2
Computer Science
Abilene, TX
4 years: 20
Computer and Information Sciences, General
Bloomington, MN
4 years: 1
Information Science/Studies
New York, NY
At least one but less than two years: 59
Computer and Information Sciences, General
Garden City, NY
4 years: 31
Information Science/Studies
Garden City, NY
4 years: 15
Computer Science
Queensbury, NY
2 years: 13
Computer and Information Sciences, General
El Cajon, CA
2 years: 12
Less than one year: 16
Data Processing and Data Processing Technology/Technician
Graniteville, SC
2 years: 6
Less than one year: 3
Computer and Information Sciences, General
Greeley, CO
2 years: 7
Less than one year: 7

Data Warehousing Specialists Job Openings. 2020 Data Warehousing Specialists Salary Guide

Job Title Company Location Date Posted Federal Contractor

Data Warehousing Specialists Job Openings. 2020 Data Warehousing Specialists Salary Guide

Data Warehousing Specialists 2020 Salary Guide By State

Common Careers