O*NET-SOC 15-1243.01

Data Warehousing Specialists

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

Preparation

ItemValue
Preparation zoneZone 4 – Considerable preparation needed
What O*NET says the zone requiresConsiderable skill, knowledge, or experience is needed
Broad occupation in O*NETFalse (No)
Skills listed for this occupation6
Abilities listed for this occupation6
Tasks listed for this occupation5
Interest scores given for this occupation6

Skills

The 6 skills with the highest importance values in this occupation's records.

SkillO*NET elementImportanceDate
Critical Thinking2.A.2.a3.8808/2018
Reading Comprehension2.A.1.a3.8808/2018
Programming2.B.3.e3.7508/2018
Complex Problem Solving2.B.2.i3.6208/2018
Active Listening2.A.1.b3.508/2018
Systems Analysis2.B.4.g3.508/2018

The importance value is what each record itself carries on O*NET's importance scale; the date is the date in each record.

Abilities

The 6 abilities with the highest importance values in this occupation's records.

AbilityO*NET elementImportanceDate
Information Ordering1.A.1.b.63.8808/2018
Written Comprehension1.A.1.a.23.8808/2018
Deductive Reasoning1.A.1.b.43.7508/2018
Inductive Reasoning1.A.1.b.53.7508/2018
Oral Comprehension1.A.1.a.13.7508/2018
Near Vision1.A.4.a.13.6208/2018

The importance value is what each record itself carries on O*NET's importance scale; the date is the date in each record.

Tasks

The tasks O*NET records for this occupation, with the type, respondent count and date each record carries.

TaskTypeIncumbents respondingDate
Develop data warehouse process models, including sourcing, loading, transformation, and extraction.Core2308/2018
Verify the structure, accuracy, or quality of warehouse data.Core2308/2018
Map data between source systems, data warehouses, and data marts.Core2308/2018
Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.Core2308/2018
Design and implement warehouse database structures.Core2308/2018

Work interests

The interest scores O*NET gives this occupation, on the six interest types.

InterestScoreDate
Conventional6.3711/2023
Investigative4.7111/2023
Enterprising3.0911/2023
Realistic2.8711/2023
Social2.011/2023
Artistic1.6211/2023

More occupations in preparation zone 4

Source: O*NET 29.1 Database (Occupation Data, Job Zones, Skills, Abilities, Task Statements, Interests), U.S. Department of Labor, Employment and Training Administration. Data fetched 2026-10-31. See about and sources.