Occupations/15-1243.01
Data Warehousing Specialists
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
Usually a four-year bachelor’s degree.
AI automation risk
82%
Higher automation risk
Human characteristics
22%
Fewer uniquely human demands
Task orientation
64%
Higher automation risk
A day in this job
- Task
Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- Task
Verify the structure, accuracy, or quality of warehouse data.
- Task
Map data between source systems, data warehouses, and data marts.
These are core tasks from O*NET. The wording didn’t clearly split routine from human, so they are listed without that label.
Core tasks
- 01Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- 02Verify the structure, accuracy, or quality of warehouse data.
- 03Map data between source systems, data warehouses, and data marts.
- 04Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
- 05Design and implement warehouse database structures.
- 06Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
Model drivers (O*NET 1–5)
- Repeating same tasks3.39
- Degree of automation2.39
- Time sitting4.86
- Originality (ability)3.00
- Conflict situations2.61
- Hands-on objects/tools2.17
- Outdoors / weather1.00
- Disease exposure1.00
- Decision freedom4.09
Top abilities
- Written Comprehension3.88
- Information Ordering3.88
- Oral Comprehension3.75
- Inductive Reasoning3.75
- Deductive Reasoning3.75
- Near Vision3.62
- Written Expression3.50
- Speech Recognition3.50
Essential skills
- Reading Comprehension3.88
- Active Listening3.50
- Writing3.25
- Speaking3.38
- Mathematics3.00
- Science1.88
- Critical Thinking3.88
- Active Learning3.00
- Learning Strategies2.62
- Monitoring2.88
CIP matches
Schools offering related programs
12 of 92 shown
Earnings are College Scorecard medians for that program, 1 and 2 years after completion. A dash means the Department suppressed the cell or the campus is not in the field file.
| Institution | Program | Tuition | Admit | Grad 6-yr | Earnings |
|---|---|---|---|---|---|
Stanford University Stanford, CA · Private nonprofit | Computer Science 11.0701 | $62,400 | 4% | 96% | 1 yr $147,858 2 yr $136,499 Bachelor's · CIP 11.07 |
University of California-San Diego La Jolla, CA · Public | Computer and Information Sciences, General 11.0101 | $15,200 | 24% | 87% | 1 yr $109,429 2 yr $110,878 Bachelor's · CIP 11.01 |
University of California-Berkeley Berkeley, CA · Public | Computer and Information Sciences, General 11.0101 | $14,800 | 11% | 93% | 1 yr $109,392 2 yr $120,462 Bachelor's · CIP 11.01 |
Columbia University in the City of New York New York, NY · Private nonprofit | Computer and Information Sciences, General 11.0101 | $68,200 | 4% | 96% | 1 yr $103,078 2 yr $100,127 Master's · CIP 11.01 |
University of Michigan-Ann Arbor Ann Arbor, MI · Public | Computer and Information Sciences, General 11.0101 | $17,700 | 18% | 93% | 1 yr $101,903 2 yr $94,281 Bachelor's · CIP 11.01 |
Georgetown University Washington, DC · Private nonprofit | Computer Science 11.0701 | $65,400 | 12% | 95% | 1 yr $93,342 2 yr $88,639 Bachelor's · CIP 11.07 |
Georgia Institute of Technology-Main Campus Atlanta, GA · Public | Computer and Information Sciences, General 11.0101 | $11,800 | 17% | 91% | 1 yr $88,731 2 yr $91,152 Bachelor's · CIP 11.01 |
The University of Texas at Austin Austin, TX · Public | Computer and Information Sciences, General 11.0101 | $11,700 | 31% | 88% | 1 yr $87,663 2 yr $79,558 Bachelor's · CIP 11.01 |
The University of Texas at Dallas Richardson, TX · Public | Computer and Information Sciences, General 11.0101 | $14,600 | 65% | 73% | 1 yr $86,867 2 yr — Master's · CIP 11.01 |
University of St Thomas St. Paul, MN · Private nonprofit | Computer and Information Sciences, General 11.0101 | $50,200 | 77% | 82% | 1 yr $84,021 2 yr $88,527 Master's · CIP 11.01 |
New York University New York, NY · Private nonprofit | Computer and Information Sciences, General 11.0101 | $60,400 | 12% | 88% | 1 yr $81,158 2 yr $79,957 Bachelor's · CIP 11.01 |
Texas A & M University-College Station College Station, TX · Public | Computer and Information Sciences, General 11.0101 | $13,200 | 63% | 83% | 1 yr $78,244 2 yr $77,024 Bachelor's · CIP 11.01 |