Data Warehousing Specialists
Computer and Mathematical Occupations- O*NET-SOC code
- 15-1243.01
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
- Data source: BLSPublished: 2026-08
Very high· relative
LowFour relative bandsVery highGroup-level value
Scale, basis and source
Four relative bands (Low / Moderate / High / Very high)
831 detailed occupations in the BLS Employment Projections table. Assigned per National Employment Matrix (NEM) code, so occupations sharing a NEM code carry the same band
- Data source: AnthropicPublished: 2026-03
0.579
0.000Range of values carried here0.745Group-level value
Scale, basis and source
Observed exposure index, 0–1 as published
Mapped onto O*NET tasks
Published per SOC 2018 occupation; every O*NET occupation with the same SOC 2018 code carries this value
- Data source: ILOPublished: 2025
0.49–0.57· 3 ISCO-08 groups
Scale, basis and source
Generative AI exposure index, 0–1 as published
Published per ISCO-08 unit group. Linked to this occupation, wholly or in part, by applying U.S. Bureau of Labor Statistics crosswalks (ISCO-08 to 2010 SOC, 2010 SOC to 2018 SOC) as published
What kind of figure this source publishes
The BLS category is a relative rank, not an absolute level, and it is not a first-hand measurement: it groups an occupation's percentile ranks across several published studies into four bands. It is not an employment or wage forecast, not a probability of adoption, and it does not separate automation from augmentation.
ILO value for each linked ISCO-08 group
- ISCO-08 2519Software and Applications Developers and Analysts Not Elsewhere Classified0.55
- ISCO-08 2521Database Designers and Administrators0.57
- ISCO-08 2529Database and Network Professionals Not Elsewhere Classified0.49
Task-level exposure
Show 1 hidden task18 rated tasks · 18 tasks with β ≥ 0.5 (100.0%)
β = direct exposure (E1) + 0.5 × exposure when tools are available (E2), per the source repository's definition.
- Source unit: O*NET 27.2 tasks → O*NET 31.0 occupation code
- All rated tasks are in the O*NET 31.0 task list.
- Source
- OpenAI "GPTs are GPTs" exposure rubric
- Release
- gh-main-0471612
- License
- MIT License, Copyright (c) 2024 OpenAI
Tasks of O*NET-SOC 2010 occupation 15-1199.07 Data Warehousing Specialists, linked to this occupation by the O*NET-SOC 2010 to 2019 crosswalk
| Task (O*NET 20.1) | Claude.aiRaw / share % |
|---|---|
Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.15-1199.07 | 1.459185.1 |
Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.15-1199.07 | 0.09125.3 |
Design and implement warehouse database structures.15-1199.07 | 0.02621.5 |
Map data between source systems, data warehouses, and data marts.15-1199.07 | 0.02011.2 |
Prepare functional or technical documentation for data warehouses.15-1199.07 | 0.01981.2 |
Implement business rules via stored procedures, middleware, or other technologies.15-1199.07 | 0.01901.1 |
Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.15-1199.07 | 0.01651.0 |
Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.15-1199.07 | 0.01040.6 |
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.15-1199.07 | 0.00950.6 |
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.15-1199.07 | 0.00910.5 |
Create or implement metadata processes and frameworks.15-1199.07 | 0.00660.4 |
Develop data warehouse process models, including sourcing, loading, transformation, and extraction.15-1199.07 | 0.00640.4 |
Provide or coordinate troubleshooting support for data warehouses.15-1199.07 | 0.00610.4 |
Test software systems or applications for software enhancements or new products.15-1199.07 | 0.00510.3 |
Review designs, codes, test plans, or documentation to ensure quality.15-1199.07 | 0.00390.2 |
Select methods, techniques, or criteria for data warehousing evaluative procedures.15-1199.07 | 0.00290.2 |
Verify the structure, accuracy, or quality of warehouse data.15-1199.07 | 0.00250.1 |
Values in this tab are predicted labels, not observations. Eloundou et al. (2023) published two rating regimes — human raters and GPT-4 — and the β shown here is derived from the GPT-4 rater basis alone; the same task can take a different value under the other regime. The unit and the meaning differ from the observed shares (%) in the other tabs, so do not place them on the same axis.
| Task (O*NET 27.2) | βE1 + 0.5 × E2 |
|---|---|
Test software systems or applications for software enhancements or new products.O*NET Task ID 16116 | 1.0 |
Review designs, codes, test plans, or documentation to ensure quality.O*NET Task ID 16117 | 1.0 |
Prepare functional or technical documentation for data warehouses.O*NET Task ID 16119 | 1.0 |
Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.O*NET Task ID 16120 | 1.0 |
Select methods, techniques, or criteria for data warehousing evaluative procedures.O*NET Task ID 16122 | 1.0 |
Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.O*NET Task ID 16123 | 1.0 |
Map data between source systems, data warehouses, and data marts.O*NET Task ID 16124 | 1.0 |
Implement business rules via stored procedures, middleware, or other technologies.O*NET Task ID 16125 | 1.0 |
Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.O*NET Task ID 16126 | 1.0 |
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.O*NET Task ID 16127 | 1.0 |
Design and implement warehouse database structures.O*NET Task ID 16128 | 1.0 |
Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.O*NET Task ID 16129 | 1.0 |
Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.O*NET Task ID 16130 | 1.0 |
Create or implement metadata processes and frameworks.O*NET Task ID 16131 | 1.0 |
Develop data warehouse process models, including sourcing, loading, transformation, and extraction.O*NET Task ID 16132 | 1.0 |
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.O*NET Task ID 16133 | 1.0 |
Provide or coordinate troubleshooting support for data warehouses.O*NET Task ID 16118 | 0.5 |
Verify the structure, accuracy, or quality of warehouse data.O*NET Task ID 16121 | 0.5 |
β = E1 + 0.5 × E2 · E1 = tasks where direct LLM access alone cuts time by at least 50%, E2 = tasks where software built on top of an LLM cuts time by at least 50%. Values take only 0 / 0.5 / 1.0.
Data sources & licenses — O*NET®, Anthropic Economic Index, Eloundou et al. (2023): see full notices on the Credits page
All O*NET 31.0 task statements (18)
All O*NET 31.0 task statements for this occupation (English, as published; task type core or supplemental). Exposure values are not listed here; they are in the table above, next to each task statement as worded in the O*NET version each source used.
| Task (O*NET 31.0) | Type |
|---|---|
| Test software systems or applications for software enhancements or new products. | Core |
| Review designs, codes, test plans, or documentation to ensure quality. | Core |
| Provide or coordinate troubleshooting support for data warehouses. | Core |
| Prepare functional or technical documentation for data warehouses. | Core |
| Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies. | Core |
| Verify the structure, accuracy, or quality of warehouse data. | Core |
| Select methods, techniques, or criteria for data warehousing evaluative procedures. | Core |
| Perform system analysis, data analysis or programming, using a variety of computer languages and procedures. | Core |
| Map data between source systems, data warehouses, and data marts. | Core |
| Implement business rules via stored procedures, middleware, or other technologies. | Core |
| Develop and implement data extraction procedures from other systems, such as administration, billing, or claims. | Core |
| 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. | Core |
| Design and implement warehouse database structures. | Core |
| Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. | Core |
| Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing. | Core |
| Create or implement metadata processes and frameworks. | Core |
| Develop data warehouse process models, including sourcing, loading, transformation, and extraction. | Core |
| 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. | Core |
0.00/ 3· Robot exposure index
Scale, basis and source
Each physical task is graded 0–3 by the setting in which robots that have been deployed, sold or demonstrated could do it (0 none · 1 purpose-built robot settings such as a fenced machine cell or a bottling line · 2 structured facilities such as a hospital pharmacy or a container port · 3 unstructured settings such as a private home or a construction site), and the grades are averaged by share of working time
Physical tasks among this occupation's O*NET 29.3 tasks
Anthropic estimated the grades and time shares with Claude Opus 5 using web search, as of 2026.
The robot exposure index is a different measure from the AI exposure figures on this site and cannot be added to or compared with them. It does not measure actual adoption or cost, and 0 also covers occupations with no physical tasks.
Tier of each physical task
None of this occupation's O*NET 29.3 tasks is classified as a physical task.
Occupation information
Employment outlook (BLS)
Values for the whole SOC 15-1243 group (Database architects), not for this O*NET occupation alone.
- Employment, 2025
- 70K
- Projected employment, 2035
- 76K
- Change (2025–35)
- +9.4%
- Median annual wage, 2025
- $139,500
- Typical education needed for entry
- Bachelor's degree
Korea classification links (KSCO)
Links from the current release of the Korea Occupation Direct Crosswalk v1.1, made by AI Changing Work. Relation values are read from the O*NET-SOC occupation side.
| KSCO code | KSCO title | Relation | Status |
|---|---|---|---|
| 22411 | 데이터 설계 및 프로그래머 | This occupation is narrower | confirmed |
Relation and status definitions(kr-direct v1.1)
ILO occupational description
AI Changing Work links the ISCO-08 unit groups below to this occupation by applying the U.S. Bureau of Labor Statistics crosswalks (2018 SOC to 2010 SOC, 2010 SOC to ISCO-08) as published, without case-by-case selection; each link may be whole or partial.
- ISCO-08 2519Software and Applications Developers and Analysts Not Elsewhere Classified
- ISCO-08 2521Database Designers and Administrators
- ISCO-08 2529Database and Network Professionals Not Elsewhere Classified
Sources: ILO ISCO-08 — details: Credits
ESCO occupational vocabulary
Each entry below is matched to this occupation in the published ESCO-O*NET Crosswalk (version 1, 2022). The match types are that crosswalk's; the wording is AI Changing Work's.
- data warehouse designerESCO 2521.5Same scope
Data warehouse designers are responsible for planning, connecting, designing, scheduling, and deploying data warehouse systems. They develop, monitor and maintain ETL processes, reporting applications and data warehouse design.
- database administratorESCO 2521.1This occupation is broader
Database administrators test, implement and administer computer databases. They use their expertise in database management systems to plan, coordinate and implement security measures to safeguard computer databases. They also use scripts and configuration files to tailor a database to users' needs.
- database designerESCO 2521.2This occupation is broader
Database designers specify the database's logical structure, processes, and information flows. They design data models and databases to serve data acquisition.
- database developerESCO 2521.3This occupation is broader
Database developers program, implement and coordinate changes to computer databases based on their expertise of database management systems.
- database integratorESCO 2521.4This occupation is broader
Database integrators perform integration among different databases. They maintain integration and ensure interoperability.
Source: European Commission, DG EMPL — ESCO API 2026-08-08 (bridge v1.2.1)
License: CC BY 4.0 (EU Reuse Notice)
ESCO reuse terms and the modification notice are in Credits.
France classification links (ROME)
AI Changing Work's links between this occupation and ROME 4.0 job profiles, judged with AI models. Relations are read from this occupation's side. Links marked “provisional” were adopted on the judgments of two judges from the same model family (Claude) alone, or by an operator rule applied to their judgments, so they rest on weaker evidence than confirmed links.
| ROME code | ROME title (French) | Relation |
|---|---|---|
| M1824 | Développeur / Développeuse décisionnel - Business Intelligence | Overlapping, not the sameprovisional |
| M1811 | Data engineer | Related, not a matchprovisional |
| M1868 | Architecte base de données | Related, not a matchprovisional |
Source: France Travail — Répertoire Opérationnel des Métiers et des Emplois (ROME 4.0), version 61, last updated 15 June 2026 (https://www.data.gouv.fr/datasets/repertoire-operationnel-des-metiers-et-des-emplois-rome). Licence Ouverte 2.0.
ROME codes and titles are reproduced unchanged; the links to O*NET-SOC occupations are AI Changing Work's own judgment and are not a France Travail correspondence.
(AI Changing Work link release: fr-direct v1)
Spain classification links (CNO-11)
AI Changing Work's links between this occupation and CNO-11 occupations, judged with AI models. Relations are read from this occupation's side.
| CNO-11 code | CNO-11 title (Spanish) | Relation |
|---|---|---|
| 2721 | Diseñadores y administradores de bases de datos | This occupation is narrowerprovisional |
Source: Instituto Nacional de Estadística (INE), National Classification of Occupations 2011 (CNO-11, Royal Decree 1591/2010) — www.ine.es · Licensed CC BY 4.0. CNO-11 codes and Spanish titles are reproduced unchanged; the links to O*NET occupations are AI Changing Work's own judgment and are not an INE correspondence.
(AI Changing Work link release: es-direct v1)
Germany classification links (KldB)
AI Changing Work's links between this occupation and KldB occupations, judged with AI models. Relations are read from this occupation's side.
| KldB code | KldB title (German) | Relation |
|---|---|---|
| 43353 | Berufe in der Datenbankentwicklung und -administration - komplexe Spezialistentätigkeiten | This occupation is narrowerprovisional |
Source: © Statistik der Bundesagentur für Arbeit — Klassifikation der Berufe 2010 – überarbeitete Fassung 2020, https://statistik.arbeitsagentur.de. KldB codes and titles are reproduced unchanged; the links to O*NET occupations are AI Changing Work's own mapping (eigene Zuordnung) and are not a Bundesagentur für Arbeit correspondence.
(AI Changing Work link release: de-direct v1)
Japan classification links (JSCO)
AI Changing Work's links between this occupation and JSCO occupations, judged with AI models. Relations are read from this occupation's side.
| JSCO code | JSCO title (Japanese) | Relation |
|---|---|---|
| 104 | ソフトウェア作成者 | This occupation is narrower |
Source: Ministry of Internal Affairs and Communications (MIC), Japan Standard Occupational Classification (Dec. 2009, MIC Notification No. 555). JSCO codes and Japanese titles are reproduced unchanged; the links to O*NET occupations are AI Changing Work's own judgment and are not a MIC correspondence.
(AI Changing Work link release: jp-direct v1)
Sources, licenses and AI Changing Work's modification and translation notices for this page: Credits & sources