Data Warehousing Specialists
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
$139,500 a year (for the broader BLS group this job sits in).
of the working time. Estimate.
- 100%
- 0%
- 0%
Measured, from Anthropic's usage data (2025). Counts help on part of a task.
On the chosen pace and reliability. Estimate.
Share of the working time within reach, now to 2030
What each choice means: , , , , . Every pace starts from .
At this date and pace, models finish tasks up to 4.4 h long four times in five.
How far this has come
With GPT-4, measured in March 2023, 0% of this job's working time was within reach at . With Claude 3.7 Sonnet, measured in February 2025, 0%. With Claude Mythos Preview (early), measured in April 2026, 4%. Today's estimate: 7%.
A backcast: today's task data with the best model METR had measured by each date. It shows how fast the models have moved, not what anyone forecast at the time.
The tasks
Sorted by . 18 tasks from .
| Task | Kind | |||
|---|---|---|---|---|
| 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.Done more than yearly by most who do it. AI observed on this task. | 17% | 4.2 work days1.7 work days to 2.5 work weeks | 0%Half by Sep 2028 | |
| Develop data warehouse process models, including sourcing, loading, transformation, and extraction.Done daily by most who do it. AI observed on this task. | 13% | 1.7 work days3.3 h to 4.2 work days | 2%Half by Feb 2028 | |
| Design and implement warehouse database structures.Done more than weekly by most who do it. AI observed on this task. | 11% | 2.1 work days6.7 h to 4.2 work days | 0%Half by Jan 2028 | |
| Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.Done daily by most who do it. AI observed on this task. | 9% | 6.7 h1.7 h to 2.5 work days | 8%Half by Sep 2027 | |
| Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.Done more than monthly by most who do it. AI observed on this task. | 8% | 1 work day3.3 h to 3.1 work days | 6%Half by Sep 2027 | |
| Implement business rules via stored procedures, middleware, or other technologies.Done more than monthly by most who do it. AI observed on this task. | 8% | 6.7 h1.7 h to 2.5 work days | 8%Half by Sep 2027 | |
| Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.Done daily by most who do it. AI observed on this task. | 7% | 5 h1.7 h to 2.1 work days | 15%Half by Jun 2027 | |
| Map data between source systems, data warehouses, and data marts.Done more than weekly by most who do it. AI observed on this task. | 4% | 6.7 h1.7 h to 2.1 work days | 9%Half by Aug 2027 | |
| Create or implement metadata processes and frameworks.Done more than yearly by most who do it. AI observed on this task. | 4% | 1.7 work days3.3 h to 4.2 work days | 2%Half by Feb 2028 | |
| Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.Done more than monthly by most who do it. | 3% | 6.7 h2.5 h to 2.5 work days | 9%Half by Jul 2027 | |
| Verify the structure, accuracy, or quality of warehouse data.Done daily by most who do it. | 3% | 3.3 h50 min to 1.3 work days | 25%Half by Mar 2027 | |
| Test software systems or applications for software enhancements or new products.Done more than yearly by most who do it. | 3% | 6.7 h1.7 h to 2.1 work days | 9%Half by Aug 2027 |
Within reach, per task: the share of the task's time whose instances are short enough for a model to finish at the chosen date, pace and reliability. Half by: the date half of that time comes within reach.
Jobs that share skills with this one
From O*NET's related occupations. Within reach now and by the end of 2028, long-run pace, four in five.
Where this job works
The industry groups that employ the most of it (BLS, May 2025). Counts are for the broader BLS group this job sits in.
- Computer Systems Design and Related Services16,410 people
- Management of Companies and Enterprises6,830 people
- Management, Scientific, and Technical Consulting Services4,340 people
- Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services3,970 people
- Software Publishers3,770 people
Where the most of these jobs are
The metro areas with the most people in it (BLS, May 2025). Counts are for the broader BLS group this job sits in.