Data Warehousing Specialists
In short: today's best AI models could do about 46% of this job's working time (projected from METR's April 2026 measurement and Epoch's November 2026 index) if the work were set up for them, and about 100% by the end of 2028 if progress keeps its long-run pace. The people and hands-on work, about 0% of the time, stays with people.
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).
A typical 40-hour week
Not yet reviewed task by task- AI could take on18 h
- A person checks AI's work0 h
- Desk work AI can't do yet22 h
- Stays with people0 h
Data Warehousing Specialists, now: of a 40-hour week, AI could take on 18 hours, 0 hours become checking its work, 22 hours are desk work it can't do yet, and 0 hours stay with people.
The largest pieces: Perform system analysis, data analysis or programming, using a variety of computer languages and procedures (about 2 h); Develop and implement data extraction procedures from other systems, such as administration, billing, or claims (about 2 h); Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies (about 2 h).
Estimates for a typical week of this job, if progress keeps its long-run pace, counting work the best models finish four times in five. Every task is below.
of the working time. Now is projected from METR's April 2026 measurement and Epoch's November 2026 index.
- 100%
- 0%
- 0%
of the work: Anthropic's measure of what people already bring to Claude at work (2025). It counts help with part of a task, so it can be higher than the share within reach.
On the chosen pace and reliability. Estimate.
Share of the working time within reach, now to 2030
Change assumptionsHide assumptionsLong-run pace, four in five
What each choice means: , , , , . Every pace starts from .
At this date and pace, models finish tasks up to 2.4 work days 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: 46%.
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.
Measured use over time
Of the Claude.ai conversations Anthropic sampled and tied to a work task, 1.8% went to this job's tasks in May 2026, the 10th largest of the 447 jobs that showed up at all; 6 of its 18 tasks showed up. Within each of Anthropic's methods, never across a change: 1.7% to 0.6% (released February and March 2025); 5.5% to 3.3% (August 2025 to February 2026); 1.9% to 1.8% (April to May 2026).
Each release
| Conversations | Share | Rank | Tasks seen |
|---|---|---|---|
| Released February 2025 | 1.7% | 7 of 708 | 17 of 18 |
| Released March 2025 | 0.6% | 29 of 703 | 15 of 18 |
| The week of Aug 4, 2025 (released September 2025) | 5.5% | 2 of 655 | 14 of 18 |
| The week of Nov 13, 2025 (released January 2026) | 4.1% | 3 of 672 | 14 of 18 |
| The week of Feb 5, 2026 (released March 2026) | 3.3% | 4 of 677 | 14 of 18 |
| April 2026 (released June 2026) | 1.9% | 8 of 434 | 5 of 18 |
| May 2026 (released June 2026) | 1.8% | 10 of 447 | 6 of 18 |
Measured, not estimated: Anthropic's samples of Claude.ai conversations, each tied by a model to an O*NET task, from the Anthropic Economic Index. It says where Claude's use goes, not how much of this job's working time it covers, so it is not on the same scale as the reach above. The releases differ in their sample, their classifier and the smallest share they report (the June 2026 file rounds each task to a hundredth of a percent, so a smaller task reads as none), which is why a change of method starts a new line. At least 96% of each older release's task-tied use matched this site's tasks, and all of the newest. Claude.ai only, so use through other tools and other companies' models is not in it. Every job ranked.
Robots and the physical work
Anthropic rates almost none of this job's working time as physical work, so robots do not reach it.
Anthropic's rating, not this site's estimate: Claude Opus 5, searching the web, rated each physical O*NET task by the kind of setting in which a robot it could cite (deployed, sold or demonstrated) does most of the task, weighted by its own estimate of each task's share of the time (What work can robots do?, September 30, 2026, data CC BY 4.0; every job ranked). A robot shown somewhere is not a robot in your building: cost, setup and safety decide that. The share within reach on this page still counts no body work. The robot behind each rated task is under the task below.
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 | 7%Half by Sep 2027 | |
| 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 | 31%Half by Mar 2027 | |
| 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 | 35%Half by Jan 2027 | |
| 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 | 55%Half by now | |
| 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 | 61%Half by now | |
| 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 | 55%Half by now | |
| 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 | 73%Half by now | |
| 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 | 61%Half by now | |
| 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 | 31%Half by Mar 2027 | |
| 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 | 69%Half by now | |
| 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 | 80%Half by now | |
| 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 | 61%Half by now |
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.
Questions about this job
- How much of the work of Data Warehousing Specialists is within reach of AI now?
- An estimated 46% of the working time is within reach of AI models now and 100% by the end of 2028, on METR's long-run pace at four in five (91% to 100% across the three paces the site shows). Within reach means a model could finish work that long at that reliability. It is not a forecast of jobs lost or of savings.
- Which tasks of Data Warehousing Specialists come within reach first?
- Weighted by the time each takes, the tasks with the most within reach now (projected from METR's April 2026 measurement and Epoch's November 2026 index) are: Perform system analysis, data analysis or programming, using a variety of computer languages and procedures (73% of the task's time now, 100% by the end of 2028); Develop and implement data extraction procedures from other systems, such as administration, billing, or claims (61% of the task's time now, 100% by the end of 2028); and Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies (55% of the task's time now, 100% by the end of 2028).
- Which tasks of Data Warehousing Specialists stay with people?
- Every task has a desk part, so each can come partly within reach; the people and body work in them stay with people, about 0% of the working time.
- Do people already use AI for the work of Data Warehousing Specialists?
- In the Claude.ai conversations Anthropic sampled for May 2026 and tied to a work task, 1.8% went to this job's tasks, the 10th largest share of the 447 jobs that showed up; 6 of its 18 tasks appeared. Anthropic's labor market measure puts the share of the job's tasks seen in real Claude use at work at 58%. These are measures of use, not of how much of the work AI could finish, and they cover Claude only.
- Can robots do the physical work of Data Warehousing Specialists?
- Anthropic's robot exposure rating (September 2026) finds almost none of the working time is physical work, so robots do not reach it.
- How is this estimated?
- From the 18 tasks O*NET lists for the occupation, each with an estimated length checked against GDPval and a share of the working time, each classed as desk, people or body work, and METR's measurements of how long a task the best AI models can finish, carried forward to the date from the latest, Claude Mythos Preview (early) in April 2026. Data checked November 10, 2026.
This job in your state or metro area
Embed these figures on your site
A small card with the share of working time within reach now and at the end of 2027, 2028 and 2030, the date and a link back. Free under CC BY 4.0; the card carries the credit.
Your own version of this job
The page above is the occupation. Your job is your title and what you actually do: give both, and they are read against these tasks in your browser, nothing sent anywhere. The headline is free: how much of your working time is within reach now and by the end of 2028, and how many of the tasks your description names.
This occupation has not been reviewed task by task yet, so the full personal report is not offered for it; 402 of 923 occupations are reviewed so far, largest first.