# Data Warehousing Specialists

> Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
- **Entity Type:** role
- **Schema Version:** role.v1
- **Soc Code:** 15-1243.01
- **Summary:** Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.

## Aliases

- Data Warehouse Analyst
- Data Warehouse Solution Architect
- Analytics Manager
- Big Data Engineer
- Data Integrity Specialist
- Data Management Engineer
- Data Management Manager
- Data Management Specialist
- Data Migration Specialist
- Data Quality Analyst
- Data Specialist
- Data Storage Specialist

## Tasks

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

## Emerging Tasks


## Activities

| Name | Iwa |
| --- | --- |
| Test software performance. | 4.A.1.b.2.h |
| Evaluate project designs to determine adequacy or feasibility. | 4.A.2.a.1.j |
| Troubleshoot issues with computer applications or systems. | 4.A.3.b.1.d |
| Document operational procedures. | 4.A.3.b.6.h |
| Modify software programs to improve performance. | 4.A.2.b.2.b |
| Design software applications. | 4.A.2.b.2.b |
| Write computer programming code. | 4.A.3.b.1.a |
| Evaluate data quality. | 4.A.2.a.2.a |
| Develop performance metrics or standards related to information technology. | 4.A.3.b.2.a |
| Analyze data to identify trends or relationships among variables. | 4.A.2.a.4.d |
| Develop diagrams or flow charts of system operation. | 4.A.2.b.2.o |
| Apply new technologies to improve work processes. | 4.A.2.b.1.i |
| Apply information technology to solve business or other applied problems. | 4.A.2.b.2.b |
| Develop procedures for data management. | 4.A.3.b.2.f |
| Create databases to store electronic data. | 4.A.2.b.2.f |
| Develop testing routines or procedures. | 4.A.3.b.2.f |
| Develop models of information or communications systems. | 4.A.3.b.2.d |

## Capabilities

| Name | Family | Value |
| --- | --- | --- |
| Computers and Electronics | knowledge | 4.26 |
| Reading Comprehension | essential_skill | 3.88 |
| Critical Thinking | essential_skill | 3.88 |
| Written Comprehension | ability | 3.88 |
| Information Ordering | ability | 3.88 |
| Programming | transferable_skill | 3.75 |
| Oral Comprehension | ability | 3.75 |
| Deductive Reasoning | ability | 3.75 |
| Inductive Reasoning | ability | 3.75 |
| Complex Problem Solving | transferable_skill | 3.62 |
| Near Vision | ability | 3.62 |
| Active Listening | essential_skill | 3.5 |
| Systems Analysis | transferable_skill | 3.5 |
| Oral Expression | ability | 3.5 |
| Written Expression | ability | 3.5 |
| Category Flexibility | ability | 3.5 |
| Speech Recognition | ability | 3.5 |
| Speaking | essential_skill | 3.38 |
| Judgment and Decision Making | transferable_skill | 3.38 |
| Problem Sensitivity | ability | 3.38 |
| Speech Clarity | ability | 3.38 |
| Writing | essential_skill | 3.25 |
| Systems Evaluation | transferable_skill | 3.25 |
| Mathematics | knowledge | 3.23 |
| English Language | knowledge | 3.18 |
| Coordination | transferable_skill | 3.12 |
| Fluency of Ideas | ability | 3.12 |
| Mathematical Reasoning | ability | 3.12 |
| Design | knowledge | 3.04 |
| Mathematics | essential_skill | 3 |
| Active Learning | essential_skill | 3 |
| Social Perceptiveness | transferable_skill | 3 |
| Originality | ability | 3 |
| Number Facility | ability | 3 |
| Flexibility of Closure | ability | 3 |
| Selective Attention | ability | 3 |
| Monitoring | essential_skill | 2.88 |
| Time Management | transferable_skill | 2.88 |
| Engineering and Technology | knowledge | 2.87 |
| Persuasion | transferable_skill | 2.75 |

## Skills

| Name | Type |
| --- | --- |
| 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 |
| Active Listening | Common Skill |
| Writing | Common Skill |
| Mathematics | Common Skill |
| English Language | Common Skill |
| Unix Shell | Specialized Skill |
| Unix | Specialized Skill |
| Transact-SQL | Specialized Skill |
| Social Perceptiveness | Common Skill |
| Shell Script | Specialized Skill |
| Red Hat Enterprise Linux | Specialized Skill |
| PostgreSQL | Specialized Skill |
| NoSQL | Specialized Skill |
| MySQL | Specialized Skill |
| MongoDB | Specialized Skill |
| Microsoft Word | Common Skill |
| Microsoft Windows | Common Skill |
| Microsoft Visual Studio | Specialized Skill |
| Microsoft Visio | Specialized Skill |
| Microsoft SharePoint | Specialized Skill |
| Microsoft Project | Specialized Skill |
| Linux | Specialized Skill |
| Apache Spark | Specialized Skill |
| Apache Kafka | Specialized Skill |
| Apache Hive | Specialized Skill |
| Apache Hadoop | Specialized Skill |
| Apache Cassandra | Specialized Skill |
| Amazon Redshift | Specialized Skill |
| Amazon DynamoDB | Specialized Skill |

## Tools

| Example | Category | Hot | In Demand |
| --- | --- | --- | --- |
| Microsoft Access | Data base user interface and query software | yes | yes |
| Microsoft Excel | Spreadsheet software | yes | yes |
| Microsoft Office software | Office suite software | yes | yes |
| Microsoft Outlook | Electronic mail software | yes | yes |
| Microsoft Power BI | Business intelligence and data analysis software | yes | yes |
| Microsoft PowerPoint | Presentation software | yes | yes |
| Python | Object or component oriented development software | yes | yes |
| Structured query language SQL | Data base user interface and query software | yes | yes |
| Tableau | Business intelligence and data analysis software | yes | yes |
| Amazon DynamoDB | Data base management system software | yes | no |
| Amazon Elastic Compute Cloud EC2 | Data base user interface and query software | yes | no |
| Amazon Redshift | Data base user interface and query software | yes | no |
| Amazon Web Services AWS software | Data base user interface and query software | yes | no |
| Apache Cassandra | Data base management system software | yes | no |
| Apache Hadoop | Data base management system software | yes | no |
| Apache Hive | Data base user interface and query software | yes | no |
| Apache Kafka | Development environment software | yes | no |
| Apache Spark | Object or component oriented development software | yes | no |
| Apache Subversion SVN | File versioning software | yes | no |
| Apple macOS | Operating system software | yes | no |
| Atlassian JIRA | Content workflow software | yes | no |
| Bash | Operating system software | yes | no |
| C | Development environment software | yes | no |
| C# | Object or component oriented development software | yes | no |
| C++ | Object or component oriented development software | yes | no |
| Eclipse IDE | Development environment software | yes | no |
| ESRI ArcGIS software | Geographic information system | yes | no |
| Extensible markup language XML | Enterprise application integration software | yes | no |
| IBM SPSS Statistics | Analytical or scientific software | yes | no |
| Informatica software | Metadata management software | yes | no |
| Linux | Operating system software | yes | no |
| Microsoft .NET Framework | Development environment software | yes | no |
| Microsoft Azure software | Development environment software | yes | no |
| Microsoft Project | Project management software | yes | no |
| Microsoft SharePoint | Document management software | yes | no |
| Microsoft SQL Server | Data base user interface and query software | yes | no |
| Microsoft SQL Server Integration Services SSIS | Enterprise application integration software | yes | no |
| Microsoft SQL Server Reporting Services SSRS | Data base reporting software | yes | no |
| Microsoft Visio | Process mapping and design software | yes | no |
| Microsoft Visual Basic | Development environment software | yes | no |

## Work Context

| Name | Value |
| --- | --- |
| E-Mail | 5 |
| Spend Time Sitting | 4.86 |
| Indoors, Environmentally Controlled | 4.83 |
| Face-to-Face Discussions with Individuals and Within Teams | 4.45 |
| Importance of Being Exact or Accurate | 4.43 |
| Telephone Conversations | 4.32 |
| Work With or Contribute to a Work Group or Team | 4.3 |
| Freedom to Make Decisions | 4.09 |
| Determine Tasks, Priorities and Goals | 3.91 |
| Contact With Others | 3.43 |
| Importance of Repeating Same Tasks | 3.39 |
| Time Pressure | 3.3 |
| Impact of Decisions on Co-workers or Company Results | 3.26 |
| Spend Time Making Repetitive Motions | 3.09 |
| Coordinate or Lead Others in Accomplishing Work Activities | 3.04 |
| Level of Competition | 3 |
| Frequency of Decision Making | 2.87 |
| Physical Proximity | 2.78 |
| Written Letters and Memos | 2.77 |
| Work Outcomes and Results of Other Workers | 2.65 |
| Conflict Situations | 2.61 |
| Degree of Automation | 2.39 |
| Consequence of Error | 2.22 |
| Spend Time Using Your Hands to Handle, Control, or Feel Objects, Tools, or Controls | 2.17 |
| Dealing With Unpleasant, Angry, or Discourteous People | 2.04 |
| Public Speaking | 1.91 |
| Deal With External Customers or the Public in General | 1.91 |
| Exposed to Sounds, Noise Levels that are Distracting or Uncomfortable | 1.91 |
| Spend Time Standing | 1.74 |
| Health and Safety of Other Workers | 1.52 |
| Spend Time Walking or Running | 1.43 |
| Exposed to Contaminants | 1.32 |
| Exposed to Radiation | 1.17 |
| Spend Time Keeping or Regaining Balance | 1.17 |
| Exposed to Extremely Bright or Inadequate Lighting Conditions | 1.13 |
| Spend Time Bending or Twisting Your Body | 1.13 |
| In an Enclosed Vehicle or Operate Enclosed Equipment | 1.09 |
| Indoors, Not Environmentally Controlled | 1.04 |
| Exposed to Very Hot or Cold Temperatures | 1.04 |
| Exposed to Hazardous Conditions | 1.04 |

## Preparation

- **Job Zone:** 4
- **Job Zone Name:** Job Zone Four: Considerable Preparation Needed
- **Education:** Most of these occupations require a four-year bachelor's degree, but some do not.
- **Experience:** A considerable amount of work-related skill, knowledge, or experience is needed for these occupations. For example, an accountant must complete four years of college and work for several years in accounting to be considered qualified.
- **Svp Range:** (7.0 to < 8.0)

### Education Distribution

| Label | Percentage |
| --- | --- |
| Bachelor's Degree | 78.26 |
| High School Diploma | 4.35 |
| Post-Secondary Certificate | 4.35 |
| Some College Courses | 4.35 |
| Associate's Degree (or other 2-year degree) | 4.35 |
| Master's Degree | 4.35 |

## Person Fit

| Name | Family | Value |
| --- | --- | --- |
| Information Technology | specific_interest_area | 6.58 |
| Conventional | career_interest_type | 6.38 |
| Dependability | work_style | 5 |
| Investigative | career_interest_type | 4.79 |
| Attention to Detail | work_style | 4 |
| Mathematics/Statistics | specific_interest_area | 3.52 |
| Enterprising | career_interest_type | 3.05 |
| Integrity | work_style | 3 |
| Realistic | career_interest_type | 2.93 |
| Management/Administration | specific_interest_area | 2.79 |
| Office Work | specific_interest_area | 2.5 |
| Accounting | specific_interest_area | 2.31 |
| Engineering | specific_interest_area | 2.17 |
| Intellectual Curiosity | work_style | 2.16 |
| Cautiousness | work_style | 2.06 |
| Social | career_interest_type | 2.03 |

## Related Roles

| Soc Code | Slug | Title | Tier |
| --- | --- | --- | --- |
| 15-1243.00 | role-15-1243-00 | Database Architects | Primary-Short |
| 15-1242.00 | role-15-1242-00 | Database Administrators | Primary-Short |
| 15-1252.00 | role-15-1252-00 | Software Developers | Primary-Short |
| 15-1211.00 | role-15-1211-00 | Computer Systems Analysts | Primary-Short |
| 15-1299.08 | role-15-1299-08 | Computer Systems Engineers/Architects | Primary-Short |
| 15-1253.00 | role-15-1253-00 | Software Quality Assurance Analysts and Testers | Primary-Long |
| 15-2051.00 | role-15-2051-00 | Data Scientists | Primary-Long |
| 15-1299.07 | role-15-1299-07 | Blockchain Engineers | Primary-Long |
| 15-2051.01 | role-15-2051-01 | Business Intelligence Analysts | Primary-Long |
| 15-1251.00 | role-15-1251-00 | Computer Programmers | Primary-Long |
| 15-1299.03 | role-15-1299-03 | Document Management Specialists | Supplemental |
| 15-1244.00 | role-15-1244-00 | Network and Computer Systems Administrators | Supplemental |

## Career Clusters

| Cluster | Slug |
| --- | --- |
| Digital Technology | digital-technology |

## Education Level

- **Category:** Bachelor's degree

## Study Programs

| Title | Slug |
| --- | --- |
| Business, Management, Marketing, and Related Support Services | business-management-marketing-and-related-support-services |
| Computer and Information Sciences and Support Services | computer-and-information-sciences-and-support-services |
| Engineering | engineering |
| Multi/Interdisciplinary Studies | multi-interdisciplinary-studies |

## Market

- **Median Wage:** 135980
- **Mean Wage:** 142620
- **Pct10Wage:** 81630
- **Pct25Wage:** 107900
- **Pct75Wage:** 169480
- **Pct90Wage:** 209990
- **Employment:** 64770
- **Area Title:** U.S.

## Industries


### Top

| Naics | Slug | Title | Level | Employment | Median Wage | Lq |
| --- | --- | --- | --- | --- | --- | --- |
| 54 | 54 | Professional, Scientific, and Technical Services | Sector | 24380 | 138610 | 5.39 |
| 52 | 52 | Finance and Insurance | Sector | 9580 | 138540 | 3.66 |
| 51 | 51 | Information | Sector | 8510 | 151460 | 6.97 |
| 55 | 55 | Management of Companies and Enterprises | Sector | 6710 | 134330 | 5.69 |
| 56 | 56 | Administrative and Support and Waste Management and Remediation Services | Sector | 3560 | 136890 | 0.94 |
| 42 | 42 | Wholesale Trade | Sector | 2900 | 129820 | 1.14 |
| 561320 | 561320 | Temporary Help Services | National industry | 2020 | 140630 | 1.81 |
| 62 | 62 | Health Care and Social Assistance | Sector | 2020 | 123410 | 0.21 |
| 31-33 | 31-33 | Manufacturing | Sector | 1900 | 129460 | 0.35 |
| 524114 | 524114 | Direct Health and Medical Insurance Carriers | National industry | 1660 | 132860 | 8.8 |
| 61 | 61 | Educational Services | Sector | 1480 | 108410 | 0.26 |
| 541330 | 541330 | Engineering Services | National industry | 730 | 127520 | 1.5 |

### Concentrated

| Naics | Slug | Title | Level | Employment | Lq |
| --- | --- | --- | --- | --- | --- |
| 524114 | 524114 | Direct Health and Medical Insurance Carriers | National industry | 1660 | 8.8 |
| 51 | 51 | Information | Sector | 8510 | 6.97 |
| 55 | 55 | Management of Companies and Enterprises | Sector | 6710 | 5.69 |
| 54 | 54 | Professional, Scientific, and Technical Services | Sector | 24380 | 5.39 |
| 52 | 52 | Finance and Insurance | Sector | 9580 | 3.66 |
| 561320 | 561320 | Temporary Help Services | National industry | 2020 | 1.81 |
| 541330 | 541330 | Engineering Services | National industry | 730 | 1.5 |
| 22 | 22 | Utilities | Sector | 320 | 1.31 |
- **Count:** 28

## Ai Signals


## Ai Outlook


### Index

- **Value:** 93
- **Percentile:** 98
- **Band:** High
- **Version:** ai-exposure-index-v1

#### Components

| Percentile | Source |
| --- | --- |
| 95 | openai_gpts_are_gpts |
| 91 | microsoft_working_with_ai |
- **Component Count:** 2

### Exposure

| Source | Label | Value | Percentile | Band | Note |
| --- | --- | --- | --- | --- | --- |
| eloundou_gamma | LLM task exposure, γ (OpenAI / Eloundou) | 1 | 95 | High | Share of this job's tasks where a large language model plus simple tools could cut the time to do them by at least half. γ is capped at 1.0 and many jobs reach that ceiling, so treat a top score as 'in the top group', not a precise rank. |
| microsoft_applicability | AI assistant applicability (Microsoft) | 0.31196565455544734 | 91 | High | How applicable today's AI assistants are to this job's activities, measured from real Microsoft Copilot conversations. Applicability is not the same as replacement. |

### Eloundou

- **Alpha:** 0.8888888888888888
- **Beta:** 0.9444444444444444
- **Gamma:** 1

### Usage Tasks

| Task | Usage Percent | Importance |
| --- | --- | --- |
| Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies. | 0.31017752014099725 | 3.91 |
| Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. | 0.08627454202597275 | 3.78 |
| Perform system analysis, data analysis or programming, using a variety of computer languages and procedures. | 0.0562838678931346 | 3.83 |
| Implement business rules via stored procedures, middleware, or other technologies. | 0.02084968098961008 | 3.55 |
| Map data between source systems, data warehouses, and data marts. | 0.017152200617068392 | 4.22 |
| Design and implement warehouse database structures. | 0.01622783052393297 | 4.09 |
- **Usage Release:** 2026-01-15-v4-plus-2025-03-27-v2

### Bls

- **Growth Percent:** 8.7
- **Growth Percentile:** 90
- **Direction:** Growing fast
- **Annual Openings Thousands:** 4
- **Annual Openings Percentile:** 43
- **Employment2024Thousands:** 66.9
- **Employment2034Thousands:** 72.7

### Sources

| Source | Version |
| --- | --- |
| bls_employment_projections | 2024-2034 |
| microsoft_working_with_ai | working-with-ai |
| openai_gpts_are_gpts | gpts-are-gpts |

## Counts

- **Tasks:** 18
- **Skills:** 84
- **Capabilities:** 120
- **Tools:** 159
- **Related Roles:** 20

## Source

- **Dataset:** gold.onet_role_starter_surface
- **Version:** 30.3
- **Generated At:** 2026-06-02T21:00:32.945303+00:00
- **Content Hash:** 1ee501657fa4cac2