Skip to content

Data Warehousing Specialists

Computer and Mathematical (15-1243)
Bright Outlook

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

At a Glance

Data Warehousing Specialists earns a median of $135,980/yr with +8.7% projected growth. Typical entry: Bachelor's degree. Top skills: Working with Computers, Analyzing Data or Information, UNIX Shell.

Median Annual Wage

$135,980/yr

Projected Growth (2024-34)

+8.7%

Annual Openings

4

Typical Education

Bachelor's degree

Skills & Requirements

Skills (10)

Critical Thinking

Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.

3.9
Reading Comprehension

Understanding written sentences and paragraphs in work-related documents.

3.9
Programming

Writing computer programs for various purposes.

3.8
Complex Problem Solving

Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.

3.6
Systems Analysis

Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.

3.5
Active Listening

Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.

3.5
Judgment and Decision Making

Considering the relative costs and benefits of potential actions to choose the most appropriate one.

3.4
Speaking

Talking to others to convey information effectively.

3.4
Systems Evaluation

Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system.

3.3
Writing

Communicating effectively in writing as appropriate for the needs of the audience.

3.3

Knowledge (1)

Computers and Electronics

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

4.3

Abilities (12)

Written Comprehension

The ability to read and understand information and ideas presented in writing.

3.9
Information Ordering

The ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations).

3.9
Inductive Reasoning

The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).

3.8
Oral Comprehension

The ability to listen to and understand information and ideas presented through spoken words and sentences.

3.8
Deductive Reasoning

The ability to apply general rules to specific problems to produce answers that make sense.

3.8
Near Vision

The ability to see details at close range (within a few feet of the observer).

3.6
Speech Recognition

The ability to identify and understand the speech of another person.

3.5
Oral Expression

The ability to communicate information and ideas in speaking so others will understand.

3.5
Written Expression

The ability to communicate information and ideas in writing so others will understand.

3.5
Category Flexibility

The ability to generate or use different sets of rules for combining or grouping things in different ways.

3.5
Problem Sensitivity

The ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing that there is a problem.

3.4
Speech Clarity

The ability to speak clearly so others can understand you.

3.4

Technology (63)

UNIX Shell

Category: Operating system software | Hot Technology

4.5
Microsoft Office software

Category: Office suite software | Hot Technology | In Demand

4.5
Microsoft Outlook

Category: Electronic mail software | Hot Technology | In Demand

4.5
Microsoft Power BI

Category: Business intelligence and data analysis software | Hot Technology

4.5
Microsoft PowerPoint

Category: Presentation software | Hot Technology | In Demand

4.5
Microsoft Project

Category: Project management software | Hot Technology

4.5
Microsoft SharePoint

Category: Document management software | Hot Technology

4.5
Microsoft SQL Server

Category: Data base user interface and query software | Hot Technology

4.5
Microsoft SQL Server Integration Services SSIS

Category: Enterprise application integration software | Hot Technology

4.5
Microsoft SQL Server Reporting Services SSRS

Category: Object or component oriented development software | Hot Technology

4.5
Microsoft Visio

Category: Process mapping and design software | Hot Technology

4.5
Microsoft Visual Basic

Category: Development environment software | Hot Technology

4.5
Microsoft Visual Studio

Category: Development environment software | Hot Technology

4.5
Microsoft Windows

Category: Operating system software | Hot Technology

4.5
Microsoft Word

Category: Word processing software | Hot Technology

4.5
MongoDB

Category: Data base management system software | Hot Technology

4.5
MySQL

Category: Data base user interface and query software | Hot Technology

4.5
NoSQL

Category: Data base management system software | Hot Technology

4.5
Oracle Database

Category: Data base user interface and query software | Hot Technology

4.5
Oracle Java

Category: Object or component oriented development software | Hot Technology

4.5
Oracle PeopleSoft

Category: Enterprise resource planning ERP software | Hot Technology

4.5
Oracle PL/SQL

Category: Data base management system software | Hot Technology

4.5
Perl

Category: Object or component oriented development software | Hot Technology

4.5
PostgreSQL

Category: Object oriented data base management software | Hot Technology

4.5
Python

Category: Object or component oriented development software | Hot Technology

4.5
R

Category: Object or component oriented development software | Hot Technology

4.5
Red Hat Enterprise Linux

Category: Operating system software | Hot Technology

4.5
SAP software

Category: Enterprise resource planning ERP software | Hot Technology

4.5
SAS

Category: Analytical or scientific software | Hot Technology

4.5
Scala

Category: Object or component oriented development software | Hot Technology

4.5
Shell script

Category: Operating system software | Hot Technology

4.5
Splunk Enterprise

Category: Cloud-based management software | Hot Technology

4.5
Structured query language SQL

Category: Data base user interface and query software | Hot Technology

4.5
Tableau

Category: Business intelligence and data analysis software | Hot Technology

4.5
Teradata Database

Category: Data base management system software | Hot Technology

4.5
The MathWorks MATLAB

Category: Analytical or scientific software | Hot Technology

4.5
Transact-SQL

Category: Data base user interface and query software | Hot Technology

4.5
UNIX

Category: Operating system software | Hot Technology

4.5
Amazon DynamoDB

Category: Data base management system software | Hot Technology

4.5
Amazon Elastic Compute Cloud EC2

Category: Data base user interface and query software | Hot Technology

4.5
Amazon Redshift

Category: Data base user interface and query software | Hot Technology

4.5
Amazon Web Services AWS software

Category: Data base user interface and query software | Hot Technology

4.5
Apache Cassandra

Category: Data base management system software | Hot Technology

4.5
Apache Hadoop

Category: Data base management system software | Hot Technology

4.5
Apache Hive

Category: Data base management system software | Hot Technology

4.5
Apache Kafka

Category: Development environment software | Hot Technology

4.5
Apache Spark

Category: Business intelligence and data analysis software | Hot Technology

4.5
Apache Subversion SVN

Category: File versioning software | Hot Technology

4.5
Apple macOS

Category: Operating system software | Hot Technology

4.5
Atlassian JIRA

Category: Content workflow software | Hot Technology

4.5
Bash

Category: Operating system software | Hot Technology

4.5
C

Category: Development environment software | Hot Technology

4.5
Eclipse IDE

Category: Development environment software | Hot Technology

4.5
ESRI ArcGIS software

Category: Geographic information system | Hot Technology

4.5
Extensible markup language XML

Category: Enterprise application integration software | Hot Technology

4.5
IBM SPSS Statistics

Category: Analytical or scientific software | Hot Technology

4.5
Informatica software

Category: Metadata management software | Hot Technology | In Demand

4.5
Linux

Category: Operating system software | Hot Technology

4.5
Microsoft .NET Framework

Category: Development environment software | Hot Technology

4.5
Microsoft Access

Category: Data base user interface and query software | Hot Technology

4.5
Microsoft Azure software

Category: Development environment software | Hot Technology

4.5
Microsoft Excel

Category: Spreadsheet software | Hot Technology | In Demand

4.5
Operational Data Store ODS software

Category: Data base user interface and query software | In Demand

4.0

Work Activities (15)

Working with Computers

Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.

5.0
Analyzing Data or Information

Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.

4.6
Processing Information

Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.

4.5
Getting Information

Observing, receiving, and otherwise obtaining information from all relevant sources.

4.4
Updating and Using Relevant Knowledge

Keeping up-to-date technically and applying new knowledge to your job.

4.2
Identifying Objects, Actions, and Events

Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.

4.1
Making Decisions and Solving Problems

Analyzing information and evaluating results to choose the best solution and solve problems.

4.0
Thinking Creatively

Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.

4.0
Communicating with Supervisors, Peers, or Subordinates

Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.

3.9
Interpreting the Meaning of Information for Others

Translating or explaining what information means and how it can be used.

3.8
Organizing, Planning, and Prioritizing Work

Developing specific goals and plans to prioritize, organize, and accomplish your work.

3.7
Establishing and Maintaining Interpersonal Relationships

Developing constructive and cooperative working relationships with others, and maintaining them over time.

3.5
Providing Consultation and Advice to Others

Providing guidance and expert advice to management or other groups on technical, systems-, or process-related topics.

3.4
Evaluating Information to Determine Compliance with Standards

Using relevant information and individual judgment to determine whether events or processes comply with laws, regulations, or standards.

3.4
Developing Objectives and Strategies

Establishing long-range objectives and specifying the strategies and actions to achieve them.

3.3

Work Styles (1)

Dependability

A tendency to be reliable, responsible, and consistent in meeting work-related obligations.

3.6

Careers with Overlapping Skills

These occupations share the most skills. A career transition between them means many of your skills transfer directly.

Explore Key Skills

Frequently Asked Questions

Want to build these skills?

Sign up to find courses that teach these skills, track your progress, and build a skills passport aligned to Data Warehousing Specialists.

Get Started Free