# Data Warehousing Specialists

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

- **SOC code:** 15-1243.01
- **Canonical URL:** https://singulariki.com/roles/role-15-1243-01
- **Also known as:** Data Warehouse Analyst, Data Warehouse Solution Architect, Analytics Manager, Big Data Engineer, Data Integrity Specialist, Data Management Engineer, Data Management Manager, Data Management Specialist
- **Frame:** "AI exposure" means task overlap (how codifiable the work is), not jobs lost or a forecast. Every figure below is traced to a named public dataset.

## What this work is

**Core tasks** (O*NET):
- Verify the structure, accuracy, or quality of warehouse data.
- Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- Map data between source systems, data warehouses, and data marts.
- Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
- Design and implement warehouse database structures.
- 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.
- Provide or coordinate troubleshooting support for data warehouses.
- Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
- 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.
- Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
- Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
- Create or implement metadata processes and frameworks.

## Skills, tools, capabilities

**Knowledge, skills & abilities** (O*NET, highest importance first):
- Computers and Electronics _(knowledge)_
- Reading Comprehension _(essential_skill)_
- Critical Thinking _(essential_skill)_
- Written Comprehension _(ability)_
- Information Ordering _(ability)_
- Programming _(transferable_skill)_
- Oral Comprehension _(ability)_
- Deductive Reasoning _(ability)_
- Inductive Reasoning _(ability)_
- Complex Problem Solving _(transferable_skill)_
- Near Vision _(ability)_
- Active Listening _(essential_skill)_

**Skills in demand:**
- Reading Comprehension _(Common Skill)_
- Information Ordering _(Specialized Skill)_
- Critical Thinking _(Common Skill)_
- Inductive Reasoning _(Common Skill)_
- Deductive Reasoning _(Common Skill)_
- Complex Problem Solving _(Common Skill)_
- Systems Analysis _(Specialized Skill)_
- Speech Recognition _(Specialized Skill)_
- Microsoft PowerPoint _(Common Skill)_
- Microsoft Outlook _(Common Skill)_
- Microsoft Excel _(Common Skill)_
- Microsoft Access _(Specialized Skill)_

**Tools & technology:**
- Microsoft Access _(hot technology, in demand)_
- Microsoft Excel _(hot technology, in demand)_
- Microsoft Office software _(hot technology, in demand)_
- Microsoft Outlook _(hot technology, in demand)_
- Microsoft Power BI _(hot technology, in demand)_
- Microsoft PowerPoint _(hot technology, in demand)_
- Python _(hot technology, in demand)_
- Structured query language SQL _(hot technology, in demand)_
- Tableau _(hot technology, in demand)_
- Amazon DynamoDB _(hot technology)_
- Amazon Elastic Compute Cloud EC2 _(hot technology)_
- Amazon Redshift _(hot technology)_

## AI exposure & outlook

- **AI task-overlap index:** 98th percentile (High) across all occupations — composite of current-era exposure studies (ai-exposure-index-v1).
- **LLM task exposure, γ (OpenAI / Eloundou):** 95th percentile (High) — source: eloundou_gamma.
- **AI assistant applicability (Microsoft):** 91st percentile (High) — source: microsoft_applicability.
- **Projected employment (BLS 2024–34):** 8.7% growth (Growing fast); 4k annual openings; 66.9k → 72.7k jobs.
- **Pay & employment (BLS OEWS, May 2024):** median $135,980; 64,770 employed.

## Sources

- **O*NET** (30.3) — U.S. Department of Labor / National Center for O*NET Development. https://www.onetcenter.org/database.html
- **BLS Occupational Employment and Wage Statistics (OEWS)** (May 2024) — U.S. Bureau of Labor Statistics. https://www.bls.gov/oes/
- **BLS Employment Projections** (2024–2034) — U.S. Bureau of Labor Statistics. https://www.bls.gov/emp/
- **Anthropic Economic Index** (v4 (2026-01-15) + v2 (2025-03-27)) — Anthropic. https://www.anthropic.com/economic-index
- **Microsoft “Working with AI”** (working-with-ai) — Microsoft Research. https://www.microsoft.com/en-us/research/
- **“GPTs are GPTs” (Eloundou et al.)** (arXiv 2303.10130) — OpenAI / academic. https://arxiv.org/abs/2303.10130

---
_Generated from Singulariki's joined dataset; data snapshot 2026-06-02T21:00:32.945303+00:00. https://singulariki.com/roles/role-15-1243-01_