Data Warehousing Specialists

O*NET-SOC 代码: 15-1243.01

Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.

数据来源: BLS发布时间: 2026-08
很高· 相对
低四级相对区间很高
职业群单位数值
尺度 · 母数 · 来源
四级相对类别（低 / 中等 / 高 / 很高）
以BLS就业预测表中831个细分职业为基数。取值按 NEM（全国就业矩阵）代码给定，因此共用同一 NEM 代码的职业得到相同分档
来源数据集（XLSX 文件下载）
数据来源: Anthropic发布时间: 2026-03
0.579
0.000此处所载数值的范围0.745
职业群单位数值
尺度 · 母数 · 来源
观测暴露度指数，按发布原值0–1
以O*NET任务映射为基准
按 SOC 2018 职业发布的数值；具有相同 SOC 2018 代码的所有 O*NET 职业均显示此值
来源数据集（CSV 文件下载）
数据来源: ILO发布时间: 2025
0.49–0.57· ISCO-08 职业组 3 个
尺度 · 母数 · 来源
生成式AI暴露度指数，按发布原值0–1
按 ISCO-08 细类（4 位）发布的数值。按原样应用美国劳工统计局（BLS）的官方对照表（ISCO-08→2010 SOC、2010 SOC→2018 SOC）关联到本职业，对应关系为全部或部分对应
来源数据集（PDF 文件下载）

该来源发布的是什么性质的数值

BLS的类别是相对排位而非绝对水平，也不是一手测量：它把多项已发表研究给出的职业百分位排名归并为四个等级。它不是就业或工资预测，不是采用概率，也不区分自动化与增强。

各关联 ISCO-08 职业组的 ILO 数值

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

仅显示有暴露的工作

已评分任务 18 项 · β ≥ 0.5 的任务 18 项（100.0%）

β = 直接暴露（E1）+ 0.5 × 借助工具时的暴露（E2），依据原始代码库的定义。

原始单位：O*NET 27.2 任务 → O*NET 31.0 职业代码
所有已评分任务均在 O*NET 31.0 任务列表中。

来源: OpenAI "GPTs are GPTs" exposure rubric
版本: gh-main-0471612
许可: MIT License, Copyright (c) 2024 OpenAI

以下为 O*NET-SOC 2010 职业 15-1199.07 Data Warehousing Specialists 的工作任务，由本站依据 O*NET-SOC 2010→2019 官方对照表关联到此职业

Task (O*NET 20.1)	Claude.aiRaw / share %	APIRaw / share %
Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies. 15-1199.07	2.845394.0	2.840982.0
Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. 15-1199.07	0.05161.7	0.08912.6
Provide or coordinate troubleshooting support for data warehouses. 15-1199.07	0.02720.9	0.00760.2
Develop and implement data extraction procedures from other systems, such as administration, billing, or claims. 15-1199.07	0.02360.8	0.03381.0
Design and implement warehouse database structures. 15-1199.07	0.01620.5	0.01370.4
Prepare functional or technical documentation for data warehouses. 15-1199.07	0.01360.4	0.00260.1
Map data between source systems, data warehouses, and data marts. 15-1199.07	0.01020.3	0.03491.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. 15-1199.07	0.00920.3	0.00660.2
Perform system analysis, data analysis or programming, using a variety of computer languages and procedures. 15-1199.07	0.00870.3	0.367610.6
Develop data warehouse process models, including sourcing, loading, transformation, and extraction. 15-1199.07	0.00820.3	0.00690.2
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.00790.3	0.00850.2
Create or implement metadata processes and frameworks. 15-1199.07	0.00240.1	0.02360.7
Implement business rules via stored procedures, middleware, or other technologies. 15-1199.07	0.00220.1	0.02800.8
Select methods, techniques, or criteria for data warehousing evaluative procedures. 15-1199.07	0.00210.1	0.00210.1
再显示 4 项工作 ▾收起 ▴
Not observed on any surface — 4 task(s) — These tasks have no row in the source for this release. The 0 in the share row is a display-stage composition ratio; absence is what the — in the raw row states.
Test software systems or applications for software enhancements or new products.	—0	—0
Review designs, codes, test plans, or documentation to ensure quality.	—0	—0
Verify the structure, accuracy, or quality of warehouse data.	—0	—0
Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.	—0	—0

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
再显示 8 项工作 ▾收起 ▴

β = 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

O*NET 31.0 全部任务（18 项）

本职业在 O*NET 31.0 中的全部任务（英文原文；任务类型为核心或补充）。暴露值不列在此清单中，而在上方表格里，位于各来源所用 O*NET 版本的任务表述旁。

任务（O*NET 31.0）	类型
Test software systems or applications for software enhancements or new products.	核心
Review designs, codes, test plans, or documentation to ensure quality.	核心
Provide or coordinate troubleshooting support for data warehouses.	核心
Prepare functional or technical documentation for data warehouses.	核心
Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.	核心
Verify the structure, accuracy, or quality of warehouse data.	核心
Select methods, techniques, or criteria for data warehousing evaluative procedures.	核心
Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.	核心
Map data between source systems, data warehouses, and data marts.	核心
Implement business rules via stored procedures, middleware, or other technologies.	核心
Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.	核心
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.	核心
Design and implement warehouse database structures.	核心
Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.	核心
Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.	核心
Create or implement metadata processes and frameworks.	核心
Develop data warehouse process models, including sourcing, loading, transformation, and extraction.	核心
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.	核心

就业展望（BLS）

这些数值属于整个 SOC 15-1243 组（Database architects），并非仅属于该 O*NET 职业。

就业人数，2025: 70K
预计就业人数，2035: 76K
变化 (2025–35): +9.4%
年薪中位数，2025: $139,500
入职通常所需学历: Bachelor's degree

最低 $30,890BLS EP 2025–35 中 825 个细分职业的工资中位数范围最高 $559,030

来源: U.S. Bureau of Labor Statistics, Employment Projections 2025–35 — Employment by detailed occupation, 2025 and projected 2035

韩国职业分类关联（KSCO）

来自 AI Changing Work 制作的 Korea Occupation Direct Crosswalk v1.1 当前版本的关联。关系值从 O*NET-SOC 职业一侧解读。

KSCO 代码	KSCO 名称	关系	状态
22411	데이터 설계 및 프로그래머	本职业范围更窄	已确认

关系与状态的定义(kr-direct v1.1)

国际劳工组织（ILO）职业说明

以下 ISCO-08 职业组由 AI Changing Work 原样套用美国劳工统计局（BLS）发布的对照表（2018 SOC→2010 SOC、2010 SOC→ISCO-08）、不逐案取舍，与本职业相关联；每项关联可能是完全对应，也可能是部分对应。

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
其他未列明的数据库和网络专业人员

自行翻译

自行翻译 · 非 ISCO 官方词汇 — 未经国际劳工组织审核。

Sources: ILO ISCO-08 — details: Credits

ESCO 职业词汇

以下每一项都是在已公开的ESCO-O*NET Crosswalk（第 1 版，2022 年）中与本职业逐项对应的。对应类型出自该对照表；表述出自 AI Changing Work。

data warehouse designerESCO 2521.5范围相同
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.1本职业范围更宽
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.2本职业范围更宽
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.3本职业范围更宽
Database developers program, implement and coordinate changes to computer databases based on their expertise of database management systems.
database integratorESCO 2521.4本职业范围更宽
Database integrators perform integration among different databases. They maintain integration and ensure interoperability.

来源: European Commission, DG EMPL — ESCO API 2026-08-08 (bridge v1.2.1)

许可: CC BY 4.0 (EU Reuse Notice)

查看原文

ESCO reuse terms and the modification notice are in Credits.

法国职业分类关联（ROME）

本职业与 ROME 4.0 职业条目（fiche）之间的关联，由 AI Changing Work 借助 AI 模型判定。关系从本职业一侧解读。标为「暂定」的关联仅凭同一模型系列（Claude）两位判定者的判定采纳，或对其判定适用运营方规则后采纳，因此其依据弱于已确认的关联。

ROME 代码	ROME 名称（法语）	关系
M1824	Développeur / Développeuse décisionnel - Business Intelligence	有重叠，但不相同暂定
M1811	Data engineer	相关，但不对应暂定
M1868	Architecte base de données	相关，但不对应暂定

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)

西班牙职业分类关联（CNO-11）

本职业与 CNO-11 职业之间的关联，由 AI Changing Work 借助 AI 模型判定。关系从本职业一侧解读。

CNO-11 代码	CNO-11 名称（西班牙语）	关系
2721	Diseñadores y administradores de bases de datos	本职业范围更窄暂定

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)

德国职业分类关联（KldB）

本职业与 KldB 职业之间的关联，由 AI Changing Work 借助 AI 模型判定。关系从本职业一侧解读。

KldB 代码	KldB 名称（德语）	关系
43353	Berufe in der Datenbankentwicklung und -administration - komplexe Spezialistentätigkeiten	本职业范围更窄暂定

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)

日本职业分类关联（JSCO）

本职业与 JSCO 职业之间的关联，由 AI Changing Work 借助 AI 模型判定。关系从本职业一侧解读。

JSCO 代码	JSCO 名称（日语）	关系
104	ソフトウェア作成者	本职业范围更窄

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)

本页数据的来源与许可，以及 AI Changing Work 的修改与翻译说明：致谢与来源