Will AI replace Data Warehousing Specialists?
Estimated risk score: 87 out of 100
Very high replacement risk
Estimate from published task research, not reviewed by a person · how we estimate
Within about 19 points for 4 in 5 of the jobs we checked (68 to 100).
Data Engineer? We score that job by hand: 56/100
For the occupation as a whole, from ratings of its 18 O*NET tasks published in 2023 and calibrated to our hand scores. A specialty inside it can sit higher or lower.
O*NET-SOC 15-1243.01 · Computer and Mathematical
Tasks rated in 2023 as ones AI could do or speed up
Tasks a GPT-4-class model could do, or do in half the time or less: 17 of its 18 rated tasks; the first 6 are shown. In O*NET’s words.
- Create or implement metadata processes and frameworks.
- Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
- Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
- Design and implement warehouse database structures.
- 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.
- Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
Tasks rated in 2023 as not sped up by AI
Tasks such a model was rated as not speeding up or taking over: 0 of its 18 rated tasks. In O*NET’s words.
None of its rated tasks.
What the job is
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
Also called: Data Warehouse Analyst, Data Warehouse Solution Architect, ETL Tester, Storage Engineer, Analytics Manager, Data Warehouse Engineer, Data Management Engineer, Data Warehouse Developer.
Scored by hand
We score Data Engineer (56) by hand: a related job, so the numbers can differ.
Source. This site includes information from the O*NET 30.1 Database by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA). Used under the CC BY 4.0 license. O*NET® is a trademark of USDOL/ETA. USDOL/ETA has not approved, endorsed, or tested these modifications. (O*NET, CC BY 4.0.) Task ratings: Eloundou, Manning, Mishkin and Rock (2023), “GPTs are GPTs: An Early Look at the Labor Market Impact Potential of Large Language Models”, data used under the MIT licence (licence texts). Our change: we averaged the ratings over this occupation’s tasks and calibrated them to our 0–100 scale. It is not a prediction about any one person and not career advice. Disagree? Write to hello@yourstopwashit.com. How we estimate