Log In

Register

Recover Password

2021 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

$98.9K

Growth

10%

Bright Outlook

Bright

Green

No

Data Warehousing Specialists Job Description

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 Analyst, Data Warehouse Solution Architect

How Much Do Data Warehousing Specialists Make ? 2021

Percentile 10% 25% 50% (Median) 75% 90%
Annual Wage $54,070 $71,900 $98,860 $126,890 $155,660
Hourly Wage $25.99 $34.57 $47.53 $61 $74.84

How Much Do Data Warehousing Specialists Make ? 2021

Percentile
10%
25%
50% (Median)
75%
90%
Annual Wage
$54,070
$71,900
$98,860
$126,890
$155,660
Hourly Wage
$25.99
$34.57
$47.53
$61
$74.84

Data Warehousing Specialists Tasks

  • Verify the structure, accuracy, or quality of warehouse data.
  • Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
  • 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.
  • Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
  • Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
  • 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.
  • Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
  • 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 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?

  • 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.
  • Write computer programming code.
  • Design software applications.
  • Troubleshoot issues with computer applications or systems.
  • Modify software programs to improve performance.
  • Develop procedures for data management.
  • Design software applications.
  • Write computer programming code.
  • Analyze data to identify trends or relationships among variables.
  • 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?

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

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

What Are Typical Data Warehousing Specialists Skills? 2021

  • 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.
  • Active Listening - Listening to others, not interrupting, and asking good questions.
  • Systems Analysis - Figuring out how a system should work and how changes in the future will affect it.
  • Judgment and Decision Making - Thinking about the pros and cons of different options and picking the best one.
  • Speaking - Talking to others.

What Are Typical Data Warehousing Specialists Interests?

  • 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 ? 2021

Location 2019 Employment 2029 Employment Percent change Annual projected job openings
United States 132,500 145,300 10% 9,900

What Is The Projected Employment For Data Warehousing Specialists ? 2021

Location
2019 Employment
2029 Employment
Percent change
Annual projected job openings
United States
132,500
145,300
10%
9,900

What Is The Required Data Warehousing Specialists Education & Experience? 2021

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

Data Warehousing Specialists Schools ?

School Program Name Location Length / Graduates
Aaniiih Nakoda College Computer and Information Sciences, General Harlem, MT 2 years: 5
ABCO Technology Data Modeling/Warehousing and Database Administration Inglewood, CA Less than one year: 7
Abilene Christian University Computer Science Abilene, TX 4 years: 14
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: 63
Adelphi University Computer and Information Sciences, General Garden City, NY 4 years: 1
4 years: 20
Adelphi University Information Science/Studies Garden City, NY 4 years: 10
Adirondack Community College Computer Science Queensbury, NY 2 years: 10
Adirondack Community College Computer and Information Systems Security/Information Assurance Queensbury, NY 2 years: 2
Advanced Training Associates Computer and Information Sciences, General El Cajon, CA 2 years: 3
Less than one year: 7

Data Warehousing Specialists Schools ?

School
Program Name
Location
Length / Graduates
Computer and Information Sciences, General
Harlem, MT
2 years: 5
Data Modeling/Warehousing and Database Administration
Inglewood, CA
Less than one year: 7
Computer Science
Abilene, TX
4 years: 14
Computer and Information Sciences, General
Bloomington, MN
4 years: 1
Information Science/Studies
New York, NY
At least one but less than two years: 63
Computer and Information Sciences, General
Garden City, NY
4 years: 1
4 years: 20
Information Science/Studies
Garden City, NY
4 years: 10
Computer Science
Queensbury, NY
2 years: 10
Computer and Information Systems Security/Information Assurance
Queensbury, NY
2 years: 2
Computer and Information Sciences, General
El Cajon, CA
2 years: 3
Less than one year: 7

Data Warehousing Specialists Jobs Near Me .

Job Title Company Location Date Posted Federal Contractor
Business Intelligence Specialist Penn Foster Boston, Massachusetts 06/18/2021 No
Business Intelligence Specialist Penn Foster Scranton, Pennsylvania 06/18/2021 No
Business Intelligence Specialist Penn Foster Norcross, Georgia 06/18/2021 No
Commerce Specialist 1 - Housing Assistance Unit (06097) Washington State Olympia, Washington 06/17/2021 No
Corporate Recruiter OPPORTUNITIES INC OF JEFFERSON CO FORT ATKINSON, Wisconsin 06/18/2021 No
Data Architect - Data Lake & Analytics - Nationwide Opportun Amazon Corporate LLC Denver, Colorado 06/17/2021 No
Data Architect, Data Lake Analytics Amazon.com Services Inc Detroit, Michigan 06/17/2021 No
Distribution Center Operations Analyst Nike Boston, Massachusetts 06/18/2021 Yes
Education Data Specialist Virginia State Government Richmond, Virginia 06/17/2021 No
FTE Quality Specialist II, QA Production Support, 2nd shift (M-Th 4:00pm – 2:30am) Cogent Infotech Wilson, North Carolina 06/17/2021 No

Data Warehousing Specialists Jobs Near Me .

Job Title
Company
Location
Date Posted
Federal Contractor
Penn Foster
Boston, Massachusetts
06/18/2021
No
Penn Foster
Scranton, Pennsylvania
06/18/2021
No
Penn Foster
Norcross, Georgia
06/18/2021
No
Washington State
Olympia, Washington
06/17/2021
No
OPPORTUNITIES INC OF JEFFERSON CO
FORT ATKINSON, Wisconsin
06/18/2021
No
Amazon Corporate LLC
Denver, Colorado
06/17/2021
No
Amazon.com Services Inc
Detroit, Michigan
06/17/2021
No
Nike
Boston, Massachusetts
06/18/2021
Yes
Virginia State Government
Richmond, Virginia
06/17/2021
No

Data Warehousing Specialists 2021 Salary Guide By State

Common Careers