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

$93.8K

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 $51,800 $68,340 $93,750 $120,880 $148,060
Hourly Wage $24.91 $32.86 $45.07 $58.12 $71.18

How Much Do Data Warehousing Specialists Make ? 2021

Percentile
10%
25%
50% (Median)
75%
90%
Annual Wage
$51,800
$68,340
$93,750
$120,880
$148,060
Hourly Wage
$24.91
$32.86
$45.07
$58.12
$71.18

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

  • Written Comprehension - Reading and understanding what is written.
  • Information Ordering - Ordering or arranging things.
  • 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.
  • Speech Recognition - Recognizing spoken words.
  • Written Expression - Communicating by writing.
  • 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

  • Reading Comprehension - Reading work-related information.
  • Critical Thinking - Thinking about the pros and cons of different ways to solve a problem.
  • 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.
  • 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 Information Science/Studies Garden City, NY 4 years: 10
Adelphi University Computer and Information Sciences, General Garden City, NY 4 years: 1
4 years: 20
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
Information Science/Studies
Garden City, NY
4 years: 10
Computer and Information Sciences, General
Garden City, NY
4 years: 1
4 years: 20
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
Data Warehouse ManpowerGroup Lafayette, Indiana 04/14/2021 Yes
Data Warehousing/ETL Consultant Deloitte Mechanicsburg, Pennsylvania 04/14/2021 Yes
Data Warehousing/ETL Consultant Deloitte Charlotte, North Carolina 04/14/2021 Yes
Data Warehousing/ETL Consultant Deloitte New York, New York 04/14/2021 Yes
Data Warehousing/ETL Consultant Deloitte Minneapolis, Minnesota 04/14/2021 Yes
Data Warehousing/ETL Consultant Deloitte Minneapolis, Minnesota 04/14/2021 Yes
Data Warehousing/ETL Consultant Deloitte New York, New York 04/14/2021 Yes
Data Warehousing/ETL Consultant Deloitte Boston, Massachusetts 04/14/2021 Yes
Data Warehousing/ETL Consultant Deloitte Minneapolis, Minnesota 04/14/2021 Yes
Data Warehousing/ETL Consultant Deloitte Austin, Texas 04/14/2021 Yes

Data Warehousing Specialists Jobs Near Me .

Job Title
Company
Location
Date Posted
Federal Contractor
ManpowerGroup
Lafayette, Indiana
04/14/2021
Yes
Deloitte
Mechanicsburg, Pennsylvania
04/14/2021
Yes
Deloitte
Charlotte, North Carolina
04/14/2021
Yes
Deloitte
New York, New York
04/14/2021
Yes
Deloitte
Minneapolis, Minnesota
04/14/2021
Yes
Deloitte
Minneapolis, Minnesota
04/14/2021
Yes
Deloitte
New York, New York
04/14/2021
Yes
Deloitte
Boston, Massachusetts
04/14/2021
Yes
Deloitte
Minneapolis, Minnesota
04/14/2021
Yes
Deloitte
Austin, Texas
04/14/2021
Yes

Data Warehousing Specialists 2021 Salary Guide By State

Common Careers