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.
AI exposure
- 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
AI exposure (OpenAI rubric)
18 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
Task statements from the O*NET® 31.0 Database, core tasks first.
| Task | Type | β (OpenAI) |
|---|---|---|
| Test software systems or applications for software enhancements or new products. | Core | 1 |
| Review designs, codes, test plans, or documentation to ensure quality. | Core | 1 |
| Provide or coordinate troubleshooting support for data warehouses. | Core | 0.5 |
| Prepare functional or technical documentation for data warehouses. | Core | 1 |
| Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies. | Core | 1 |
| Verify the structure, accuracy, or quality of warehouse data. | Core | 0.5 |
| Select methods, techniques, or criteria for data warehousing evaluative procedures. | Core | 1 |
| Perform system analysis, data analysis or programming, using a variety of computer languages and procedures. | Core | 1 |
| Map data between source systems, data warehouses, and data marts. | Core | 1 |
| Implement business rules via stored procedures, middleware, or other technologies. | Core | 1 |
| Develop and implement data extraction procedures from other systems, such as administration, billing, or claims. | Core | 1 |
| 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 | 1 |
| Design and implement warehouse database structures. | Core | 1 |
| Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. | Core | 1 |
| Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing. | Core | 1 |
| Create or implement metadata processes and frameworks. | Core | 1 |
| Develop data warehouse process models, including sourcing, loading, transformation, and extraction. | Core | 1 |
| 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 | 1 |
Occupation information
Sources and attribution
This page includes information from the O*NET® 31.0 Database (https://www.onetcenter.org/database.html) by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA). Used under the CC BY 4.0 license (https://creativecommons.org/licenses/by/4.0/). O*NET® is a trademark of USDOL/ETA. AI Changing Work has modified all or some of this information: the O*NET-SOC code, title and task statements are reproduced in English without change; task-type labels are shown in the page's language and tasks are listed core first; any Korean occupation title shown on the Korean-language page is AI Changing Work's translation; any KSCO-8 unit groups linked to this occupation were paired with it by AI Changing Work's judgment, and the relation labels and statuses are AI Changing Work's additions. USDOL/ETA has not approved, endorsed, or tested these modifications.
Any AI exposure figures on this page are published by third parties, not by AI Changing Work, and none is part of the O*NET information. OpenAI publishes task-level scores (MIT License) for O*NET 27.2 task statements; each is shown next to the O*NET 31.0 task statement with the same task ID, whose wording can differ from the 27.2 statement that was scored. OpenAI also publishes occupation-level scores for O*NET-SOC codes in the same release, and any such score is shown on the O*NET occupation with the same code. Anthropic publishes an observed exposure index in the Anthropic Economic Index (CC-BY), and the U.S. Bureau of Labor Statistics publishes relative AI exposure categories (public domain); both are published per SOC code, and each value is shown on every O*NET occupation with that code. The International Labour Organization publishes a generative AI exposure index in ILO Working Paper 140 (CC BY 4.0) for ISCO-08 unit groups; AI Changing Work links those groups to O*NET occupations by applying the U.S. Bureau of Labor Statistics ISCO-08 to 2010 SOC and 2010 SOC to 2018 SOC crosswalks as published, without case-by-case selection, and these crosswalks match many groups only in part. Where several unit groups are linked, each group's published value is listed, and any summary shows only the lowest and highest of those values with the number of groups; no exposure figure is averaged or recalculated. Any employment figures are published by the U.S. Bureau of Labor Statistics for the SOC group containing this occupation. Each source is credited where its figures are shown.
O*NET OnLine: 15-1243.01 Data Warehousing Specialists
KSCO 코드·명칭: 한국표준직업분류(제8차 개정) — 통계청 고시 제2024-328호 (2024-07-01 고시, 2025-01-01 시행). 저작권법 제7조 제2호의 고시 항목이다. 명칭 표기(가운뎃점·띄어쓰기)는 해설서 2차 정오 반영판의 표기를 따랐으며, 고시 항목표와는 18개 명칭에서 가운뎃점 글리프나 띄어쓰기만 다르다. 통계청은 2025년 10월 국가데이터처로 개편되었다. 이 페이지의 KSCO 연결은 통계청·국가데이터처의 공식 연계표가 아니다.