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

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

How Much Do Data Warehousing Specialists Make ? 2020

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

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

Data Warehousing Specialists 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.
  • 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?

  • Develop models of information or communications systems.
  • Evaluate data quality.
  • Develop diagrams or flow charts of system operation.
  • Develop procedures for data management.
  • Create databases to store electronic data.
  • Develop procedures for data management.
  • Troubleshoot issues with computer applications or systems.
  • Write computer programming code.
  • Modify software programs to improve performance.
  • Design software applications.
  • Develop procedures for data management.
  • Analyze data to identify trends or relationships among variables.
  • Design software applications.
  • Write computer programming code.
  • 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.
  • Oral Comprehension - Listening and understanding what people say.
  • Deductive Reasoning - Using rules to solve problems.
  • Inductive Reasoning - Making general rules or coming up with answers from lots of detailed information.
  • Near Vision - Seeing details up close.
  • Written Expression - Communicating by writing.
  • Oral Expression - Communicating by speaking.
  • Speech Recognition - Recognizing spoken words.
  • Category Flexibility - Grouping things in different ways.
  • Speech Clarity - Speaking clearly.
  • Problem Sensitivity - Noticing when problems happen.

What Are Typical Data Warehousing Specialists Skills? 2020

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

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

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

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

Data Warehousing Specialists Jobs Near Me .

Job Title Company Location Date Posted Federal Contractor

Data Warehousing Specialists Jobs Near Me .

Data Warehousing Specialists 2020 Salary Guide By State

Common Careers