Data Warehousing Specialists
Information TechnologyO*NET 15-1243.01United States
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
- Median annual earnings
- $138,502
- Projected change
- +12.3%
- Typical education
- Bachelor's degree
- Employment
- 68.45K jobs
50th percentile, United States
2025 to 2035
78.3% of the workforce
Growing to 76.84K by 2035
Explore this career by location
Compare nationwide estimates with state or county job-market data.
Showing United States
Loading available locations…
Build the skills
ASU learning related to this career
These courses and certificates are connected through catalog career relationships and Lightcast skill tags.
Loading related ASU learning
The work
What data warehousing specialists do
Tasks reported for this occupation, ordered by how often they come up in the role.
- 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.
- Implement business rules via stored procedures, middleware, or other technologies.
- Prepare functional or technical documentation for data warehouses.
- Test software systems or applications for software enhancements or new products.
Pay and outlook
What the job pays and where it is heading
Annual earnings range
Reported earnings by percentile, United States
- 10th percentile
- $84,791
- 25th percentile
- $107,835
- 50th percentile
- $138,502
- 75th percentile
- $168,828
- 90th percentile
- $204,471
The gold marker shows the median. Half earn more than $138,502 and half earn less.
Employment outlook
2025 to 2035 projection
+12.3%faster than average
202568,447 jobs
2035 projected76,843 jobs
8,396 more positions over the decade, before replacement hiring.
Preparation
Education levels
What people currently working in the career hold. These are not entry requirements.
- Bachelor's degree
- 78.3%
- High school diploma or less
- 4.4%
- Certificate
- 4.4%
- Some college
- 4.4%
- Associate degree
- 4.4%
- Master's or Professional degree
- 4.4%
Skills
Skills employers ask for
Technical skills appearing most often in job postings for this occupation.
How the work gets done
Core competencies
Broad capabilities associated with strong performance in this occupation.
- Reading Comprehension
- Understanding written sentences and paragraphs in work-related documents.
- Critical Thinking
- Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
- Programming
- Writing computer programs for various purposes.
- Complex Problem Solving
- Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
- 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.
- Systems Analysis
- Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
- Speaking
- Talking to others to convey information effectively.
- Judgment and Decision Making
- Considering the relative costs and benefits of potential actions to choose the most appropriate one.
- 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.
- Writing
- Communicating effectively in writing as appropriate for the needs of the audience.
- Coordination
- Adjusting actions in relation to others' actions.
- Mathematics
- Using mathematics to solve problems.
- Active Learning
- Understanding the implications of new information for both current and future problem-solving and decision-making.
- Social Perceptiveness
- Being aware of others' reactions and understanding why they react as they do.
- Monitoring
- Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.
- Time Management
- Managing one's own time and the time of others.
- Operations Analysis
- Analyzing needs and product requirements to create a design.
- Persuasion
- Persuading others to change their minds or behavior.
- Instructing
- Teaching others how to do something.
- Technology Design
- Generating or adapting equipment and technology to serve user needs.
In the market
Job titles and employers
Recent job postings in United StatesCommon job titles
- 01Data Specialists1,119 postings
- 02Oncology Data Specialists356 postings
- 03Data Warehouse Developers292 postings
- 04Master Data Specialists243 postings
- 05Provider Data Specialists220 postings
- 06Research Data Specialists198 postings
- 07Clinical Data Specialists129 postings
- 08Data Support Specialists118 postings
- 09Marketing Data Specialists107 postings
- 10Data Management Specialists104 postings
- 11Product Data Specialists95 postings
- 12Data Stewards94 postings
- 13Google Specialists88 postings
- 14IT Data Specialists87 postings
- 15Human Resources Data Specialists64 postings
- 16Clinical Research Data Specialists60 postings
- 17Data Curators56 postings
- 18Data Integrity Specialists54 postings
- 19Enterprise Specialists54 postings
- 20Bid Specialists53 postings
Top employers
- 01Dodge Construction Network152 postings
- 02Waste Management104 postings
- 03Accenture93 postings
- 04TriWest Healthcare Alliance91 postings
- 05Contact Government Services90 postings
- 06Beacon Hill Staffing Group88 postings
- 07Insight Global61 postings
- 08CVS Health54 postings
- 09Robert Half54 postings
- 10Datavant53 postings
- 11Boeing52 postings
- 12Stiftelsen Norstella51 postings
- 13Indotronix International Corporation47 postings
- 14Parexel47 postings
- 15Intermountain Health46 postings
- 16Rws Trainai45 postings
- 17SitusAMC44 postings
- 18St George Tanaq Corporation40 postings
- 19Caterpillar37 postings
- 20Dana-Farber Cancer Institute27 postings
Keep looking