Computer & Mathematical
Data Warehousing Specialists
Also called: Data Warehouse Analyst, Data Warehouse Solution Architect
US median pay
$139,500
per year, 2025
Job growth 2025–35
+9.4%
faster than average
Openings a year (US)
3,900
69,500 employed
Typical entry education
Bachelor's degree
Preparation 4/5 · Considerable preparation
What this job is
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
What they do day to day
- 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.
Skills and knowledge that matter most
Skills
- Programming3.8/5
- Complex Problem Solving3.6/5
- Systems Analysis3.5/5
- Judgment and Decision Making3.4/5
- Systems Evaluation3.2/5
- Coordination3.1/5
- Social Perceptiveness3.0/5
- Time Management2.9/5
Knowledge
- Computers and Electronics4.3/5
- Mathematics3.2/5
- English Language3.2/5
- Design3.0/5
- Engineering and Technology2.9/5
- Administration and Management2.6/5
Importance rated by people working in the job (1 = not important, 5 = extremely important).
Education and preparation
Preparation level 4 of 5 — Considerable preparation. Usually a bachelor's degree and several years of related experience.
Typical entry education (BLS): Bachelor's degree, plus less than 5 years of related work experience.
Highest education of people in this job:
- Bachelor's degree78%
Who this job suits
Mostly Conventional
Organising data, details and procedures
Investigative
Ideas, research and solving problems
Enterprising
Leading, persuading and starting things
Based on the Holland (RIASEC) interest profile for this occupation.