Computer and Mathematical · Holland code CIE

Data Warehousing Specialists

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.

O*NET 15-1243.01

At a glance

US median annual pay: $139,500; Middle half earn $109,370 to $169,290. BLS OEWS, May 2025.
Most common education: Bachelor's Degree; 78% of workers surveyed by O*NET report this level.
Preparation needed: Job Zone 4 of 5; Considerable preparation. Zone 1 is little or none; zone 5 is graduate-level.

What the work involves

The tasks workers in this occupation rate as most important, from the O*NET survey.

Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
Verify the structure, accuracy, or quality of warehouse data.
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.

Skills and knowledge it leans on

Skills

Reading Comprehension3.9 / 5
Critical Thinking3.9 / 5
Active Listening3.5 / 5
Speaking3.4 / 5
Writing3.3 / 5
Mathematics3.0 / 5

Knowledge areas

Computers and Electronics4.3 / 5
Mathematics3.2 / 5
English Language3.2 / 5
Design3.0 / 5
Engineering and Technology2.9 / 5
Administration and Management2.6 / 5

Importance ratings on O*NET’s 1 to 5 scale. Higher means the occupation depends on it more.

Who tends to enjoy it

How strongly this occupation draws on each of the six Holland interest types, which is the same profile the career interests test compares you against.

Realistic32
Investigative63
Artistic10
Social17
Enterprising34
Conventional90

The same work abroad

Other countries classify jobs differently, so these are the closest matches through the international ISCO-08 standard, not exact equivalents.

European occupation titles (ESCO)

chief data officer · DE Leiter der Datenverarbeitung/Leiterin der Datenverarbeitung · FR directeur des données/directrice des données
business intelligence manager · DE Business-Intelligence-Manager/Business-Intelligence-Managerin · FR veilleur stratégique/veilleuse stratégique
data analyst · DE Datenanalytiker/Datenanalytikerin · FR analyste de données
data scientist · DE Datenwissenschaftler/Datenwissenschaftlerin · FR scientifique des données
data quality specialist · DE Datenqualitätsexperte/Datenqualitätsexpertin · FR analyste qualité des données
database administrator · DE Datenbankadministrator/Datenbankadministratorin · FR administrateur de base de données/administratrice de base de données

Closest UK occupation groups (SOC 2020)

Management consultants and business analysts (2431)245,700 employed
Information technology directors (1137)197,000 employed
IT managers (2132)276,800 employed

Employment is the UK Annual Population Survey for April 2025 to March 2026, all workers in the group, which can be broader than this one occupation.

Pay across Europe, for the whole group

Median annual earnings of all employees in “Professionals”. This is the broad ISCO group this occupation falls in, not the occupation itself, so treat it as context for the wage level, not as a salary for this job.

Median annual earnings, Professionals, by country
Country	Median pay
Belgium	€61,714
Germany	€59,529
Ireland	€56,877
Austria	€55,374
Netherlands	€53,595
Sweden	€43,567
France	€41,515
Spain	€35,735
Italy	€33,649
Portugal	€26,072
Poland	€14,380

Eurostat Structure of Earnings Survey, businesses with ten or more employees outside public administration, in euro and not adjusted for the cost of living. Reference years differ between sources: the US, Japan and Europe figures on this page come from different survey years, so compare them as rough levels, not to the euro or yen.

Is it a fit for you?

Interest is one input, alongside ability, pay and what is hiring near you. The career interests test takes about thirteen minutes and ranks occupations by how closely their profile matches yours.

Take the career interests test