Data Warehousing Specialists
Official O*NET title: Data Warehousing Specialists (15-1243.01)
Also called: data engineer, etl developer, data warehouse, data warehouse analyst, data warehouse solution architect
Do you do this at work?
Answer each card — it takes about a minute.
Do you do this at work?
Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies
Swipe right for yes, left for not me. On a keyboard: → yes, ← not me, Z undo. +2 XP per answer.
How AI is changing data warehousing specialists work
15 of 18 measurable main tasks for this job show up in real AI-use data, so we rate it Red (lots of AI use) — 83%.
This shows where people already use AI, not whether the job will disappear. How we measure this.
Tasks in this job and recorded AI use
- Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies (main task) — a lot of recorded AI use
- Create supporting documentation (main task) — a lot of recorded AI use
- Perform system analysis, data analysis or programming, using a variety of computer languages and procedures (main task) — a lot of recorded AI use
- Put in place business rules via stored procedures, middleware, or other technologies (main task) — some recorded AI use
- Map data between source systems, data warehouses, and data marts (main task) — some recorded AI use
- Design and put in place warehouse database structures (main task) — some recorded AI use
- Prepare functional or technical documentation for data warehouses (main task) — some recorded AI use
- Design, put in place, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements (main task) — some recorded AI use
- Provide or coordinate troubleshooting support for data warehouses (main task) — some recorded AI use
- Develop and put in place data extraction procedures from other systems (main task) — some recorded AI use
- Develop data warehouse process models (main task) — some recorded AI use
- Develop or maintain standards (main task) — some recorded AI use
- Create or put in place metadata processes and frameworks (main task) — some recorded AI use
- Verify the structure, accuracy, or quality of warehouse data (main task) — some recorded AI use
- Test software systems or applications for software enhancements or new products (main task) — some recorded AI use
- Review designs, codes, test plans, or documentation to make sure quality (main task) — no recorded AI use
- Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing (main task) — no recorded AI use
- Select methods, techniques, or criteria for data warehousing evaluative procedures (main task) — no recorded AI use
Tasks: O*NET 31.0. AI use: Anthropic Economic Index (exact or close text match).
Your first steps (guidance)
- Week 1: Open a free AI assistant and say hello. Follow our “Getting started with AI” guide. Ask it one simple question about your work.
- Week 2: Use AI on one task you do often. Try the prompt for: “Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies”. Try the prompt for: “Create supporting documentation”.
Tick your own tasks above to get a plan based on what you really do. The first 2 weeks are free; Premium (coming soon) adds weeks 3–12. New to AI? Read our beginner’s guide.
Questions about AI and data warehousing specialists
Will AI replace data warehousing specialists?
Our data can’t predict job losses, and we don’t try to. What it does show: 15 of the 18 main tasks for this job match tasks people already use AI for (Anthropic Economic Index), giving a Red rating (lots of AI use). Using AI on a task is not the same as AI doing the whole job, and 3 of the 18 listed tasks show no recorded AI use yet.
Which data warehousing specialist tasks is AI used for most?
In the data, the most AI use among this job’s tasks is for: write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies; create supporting documentation; perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
Which data warehousing specialist tasks show little or no AI use?
For example: review designs, codes, test plans, or documentation to make sure quality; create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing; select methods, techniques, or criteria for data warehousing evaluative procedures. These are good places to keep building your own skills.
How does this job compare to others?
In Microsoft Research’s “Working with AI” study, this job’s AI applicability score is equal to or higher than 90% of the occupations they scored. That measures overlap with AI chat use, not risk of job loss.
How can a data warehousing specialist start learning AI?
Start small: open a free AI assistant, try it on one task you do often, and always check facts and numbers yourself. The plan on this page is guidance, not professional advice.
See how this job ranks
Data Warehousing Specialists ranks #20 of 572 jobs for the share of main tasks with AI use (#1 = most), and #3 of 30 in Tech. It’s in our top 50 jobs most changed by AI.
Related jobs
- Will AI change it managers?
- Will AI change computer systems analysts?
- Will AI change cybersecurity analysts?
- Will AI change computer research scientists?
- Will AI change computer network support specialists?
- Will AI change it support specialists?
- Will AI change database architects?
- Will AI change database administrators?
- Will AI change software developers?
- Will AI change computer systems engineers and architects?
- See all jobs