JobAfterNext

Data Warehousing Specialists

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

Wages

BLS doesn't publish wages for Data Warehousing Specialists separately. These are the figures for Database Architects (15-1243), its parent occupation.

Median annual wage, U.S.$139,500
Employment, U.S.67,140
Median hourly wage$67.07
Annual wage percentiles, U.S., May 2025
10th25thMedian75th90th
$86,240$109,370$139,500$169,290$204,000
By state (49)
StateEmploymentMedian annualLocation quotient
Alabama270$105,4500.29
Alaska70$112,5000.53
Arizona1,200$156,1000.86
Arkansas360$104,0700.63
California6,210$170,1600.79
Colorado1,950$154,5601.57
Connecticut1,140$144,4601.55
Delaware$147,800
District of Columbia790$150,0102.61
Florida1,810$138,3200.42
Georgia2,590$139,5001.23
Hawaii60$134,0400.22
Idaho260$121,3800.69
Illinois1,590$142,5000.60
Indiana500$132,8300.36
Iowa240$124,0400.36
Kansas360$129,9900.57
Kentucky350$125,4000.40
Maine190$133,1200.69
Maryland1,370$132,9401.14
Massachusetts2,690$161,6501.71
Michigan1,390$131,0000.73
Minnesota1,240$133,0500.98
Mississippi100$98,4200.20
Missouri1,410$110,5701.11
Montana$109,990
Nebraska610$134,3201.39
Nevada420$140,2000.63
New Hampshire120$139,9900.40
New Jersey3,090$120,7901.67
New Mexico120$117,9500.32
New York3,850$141,3500.92
North Carolina4,070$134,6301.91
North Dakota60$109,4300.30
Ohio1,820$132,9100.76
Oklahoma860$110,1101.17
Oregon730$138,2500.86
Pennsylvania2,840Not available1.09
Rhode Island160$140,3200.72
South Carolina1,160$130,0001.16
South Dakota40$136,5400.20
Tennessee650$115,1700.46
Texas8,270$151,3701.36
Utah630$131,7400.84
Virginia5,260$160,3602.96
Washington2,990$128,7601.95
West Virginia120Not available0.40
Wisconsin520$137,8100.41
Wyoming160Not available1.35

Similar occupations

Similarity is our measure: the cosine of importance x level over all 120 O*NET skills, knowledge areas and abilities. It is not an O*NET finding. More.

One skill away

Among the 50 occupations most similar to Data Warehousing Specialists, those at the same Job Zone or lower, where exactly one skill rated at least 3 in importance needs a level more than 0.75 points higher (on O*NET's 0-7 level scale). Our definition. Change the thresholds.

OccupationSkill to buildLevel gapSimilarity
Database ArchitectsTechnology Design3.000.975
Business Intelligence AnalystsActive Learning0.870.963
Software Quality Assurance Analysts and TestersQuality Control Analysis3.620.957
Software DevelopersTechnology Design3.620.951
Video Game DesignersTechnology Design3.000.938
Web AdministratorsQuality Control Analysis3.380.935
Bioinformatics TechniciansScience3.380.934
Computer Hardware EngineersActive Learning0.870.924
Social Science Research AssistantsScience3.380.923
Statistical AssistantsMathematics1.630.916

Software to learn next

Software used by at least 3 of the 20 occupations most similar to Data Warehousing Specialists, excluding software Data Warehousing Specialists already lists and any you named. Ranked by how many of them use it, weighted by how much more common it is among them than across all occupations (lift). Our ranking.

SoftwareSimilar jobs using itLift
Go15 of 2024.7x
Amazon Web Services AWS CloudFormation13 of 2031.6x
GitHub15 of 2019.8x
Spring Framework12 of 2034.6x
Node.js13 of 2025.0x
Elasticsearch13 of 2024.0x
Git15 of 2014.7x
PHP15 of 2014.7x
Microsoft Windows Server13 of 2022.2x
Red Hat WildFly12 of 2027.7x

Skills

From O*NET data. Importance is rated 1 to 5 and level 0 to 7.

SkillTypeImportanceLevel
Reading ComprehensionEssential skill 3.88 4.00
Critical ThinkingEssential skill 3.88 3.88
ProgrammingTransferable skill 3.75 3.75
Complex Problem SolvingTransferable skill 3.62 3.50
Active ListeningEssential skill 3.50 3.62
Systems AnalysisTransferable skill 3.50 3.50
Judgment and Decision MakingTransferable skill 3.38 3.62
SpeakingEssential skill 3.38 3.62
Systems EvaluationTransferable skill 3.25 3.50
WritingEssential skill 3.25 3.38
CoordinationTransferable skill 3.12 3.38
Active LearningEssential skill 3.00 3.25
MathematicsEssential skill 3.00 3.25
Social PerceptivenessTransferable skill 3.00 3.00
MonitoringEssential skill 2.88 3.12
Time ManagementTransferable skill 2.88 2.75
Operations AnalysisTransferable skill 2.75 3.38
PersuasionTransferable skill 2.75 3.12
Technology DesignTransferable skill 2.62not rated
InstructingTransferable skill 2.62 3.38
Learning StrategiesEssential skill 2.62 2.75
NegotiationTransferable skill 2.62 2.62
Service OrientationTransferable skill 2.62 2.62
Operations MonitoringTransferable skill 2.50 2.25
Quality Control AnalysisTransferable skill 2.38not rated
Management of Personnel ResourcesTransferable skill 2.12 2.00
Operation and ControlTransferable skill 1.88not rated
ScienceEssential skill 1.88not rated
Management of Material ResourcesTransferable skill 1.88 1.62
Management of Financial ResourcesTransferable skill 1.75 1.38
TroubleshootingTransferable skill 1.62 1.00
Equipment SelectionTransferable skill 1.50not rated
Equipment MaintenanceTransferable skill 1.12not rated
RepairingTransferable skill 1.12not rated
InstallationTransferable skill 1.00not rated
Knowledge (33) and abilities (52)
Knowledge
NameImportanceLevel
Computers and Electronics 4.26 5.61
Mathematics 3.23 4.55
English Language 3.18 3.36
Design 3.04 3.35
Engineering and Technology 2.87 3.00
Administration and Management 2.61 3.48
Customer and Personal Service 2.43 2.61
Education and Training 2.22 3.00
Economics and Accounting 2.22 2.43
Production and Processing 2.13 2.17
Telecommunications 2.04 2.04
Personnel and Human Resources 2.00 2.61
Administrative 1.91 2.26
Sales and Marketing 1.74 1.91
Law and Government 1.61 1.43
Communications and Media 1.61 1.39
Psychology 1.52 1.26
Geography 1.35 0.91
Sociology and Anthropology 1.26not rated
Physics 1.18not rated
Public Safety and Security 1.17not rated
Transportation 1.17not rated
Foreign Language 1.13not rated
Medicine and Dentistry 1.13not rated
Building and Construction 1.09not rated
Fine Arts 1.09not rated
Philosophy and Theology 1.09not rated
History and Archeology 1.05not rated
Mechanical 1.05not rated
Biology 1.00not rated
Chemistry 1.00not rated
Food Production 1.00not rated
Therapy and Counseling 1.00not rated
Abilities
NameImportanceLevel
Information Ordering 3.88 4.00
Written Comprehension 3.88 4.00
Deductive Reasoning 3.75 4.00
Oral Comprehension 3.75 4.00
Inductive Reasoning 3.75 3.88
Near Vision 3.62 3.88
Oral Expression 3.50 4.00
Written Expression 3.50 4.00
Category Flexibility 3.50 3.50
Speech Recognition 3.50 3.25
Problem Sensitivity 3.38 3.50
Speech Clarity 3.38 3.00
Fluency of Ideas 3.12 3.25
Mathematical Reasoning 3.12 3.12
Number Facility 3.00 3.25
Originality 3.00 3.25
Flexibility of Closure 3.00 3.00
Selective Attention 3.00 3.00
Perceptual Speed 2.62 2.88
Visualization 2.62 2.75
Speed of Closure 2.50 2.50
Far Vision 2.38 2.38
Memorization 2.25 2.50
Trunk Strength 2.12 1.75
Visual Color Discrimination 2.12 1.75
Time Sharing 1.88 1.75
Hearing Sensitivity 1.88 1.38
Wrist-Finger Speed 1.88 1.38
Auditory Attention 1.75 1.25
Depth Perception 1.62 0.88
Dynamic Strength 1.62 0.75
Arm-Hand Steadiness 1.25not rated
Finger Dexterity 1.25not rated
Speed of Limb Movement 1.12not rated
Control Precision 1.00not rated
Dynamic Flexibility 1.00not rated
Explosive Strength 1.00not rated
Extent Flexibility 1.00not rated
Glare Sensitivity 1.00not rated
Gross Body Coordination 1.00not rated
Gross Body Equilibrium 1.00not rated
Manual Dexterity 1.00not rated
Multilimb Coordination 1.00not rated
Night Vision 1.00not rated
Peripheral Vision 1.00not rated
Rate Control 1.00not rated
Reaction Time 1.00not rated
Response Orientation 1.00not rated
Sound Localization 1.00not rated
Spatial Orientation 1.00not rated
Stamina 1.00not rated
Static Strength 1.00not rated

Software used

Examples from O*NET data. "Hot" and "in demand" are O*NET flags for technologies often listed in job postings.

All 159
  • Informatica software hot
  • Linux hot
  • Microsoft .NET Framework hot
  • Microsoft Azure software hot
  • Microsoft Project hot
  • Microsoft SQL Server hot
  • Microsoft SQL Server Integration Services SSIS hot
  • Microsoft SQL Server Reporting Services SSRS hot
  • Microsoft SharePoint hot
  • Microsoft Visio hot
  • Microsoft Visual Basic hot
  • Microsoft Visual Studio hot
  • Microsoft Windows hot
  • Microsoft Word hot
  • MongoDB hot
  • MySQL hot
  • NoSQL hot
  • Oracle Database hot
  • Oracle Java hot
  • Oracle PL/SQL hot
  • Oracle PeopleSoft hot
  • Perl hot
  • PostgreSQL hot
  • R hot
  • Red Hat Enterprise Linux hot
  • SAP software hot
  • SAS hot
  • Scala hot
  • Shell script hot
  • Splunk Enterprise hot
  • Teradata Database hot
  • The MathWorks MATLAB hot
  • Transact-SQL hot
  • UNIX hot
  • UNIX Shell hot
  • Adaptive Metadata Manager
  • Adeptia ETL Suite
  • Advanced business application programming ABAP
  • Altova MapForce
  • Amazon Simple Storage Service S3
  • Apache Avro
  • Apache Flume
  • Apache HBase
  • Apache HTTP Server
  • Apache Oozie
  • Apache Pig
  • Apache Solr
  • Apache Sqoop
  • Apatar
  • Aster Data nCluster
  • Blackbaud The Raiser's Edge
  • Cloudera Impala
  • CloverETL
  • CodeFutures dbShards
  • Coglin Mill RODIN
  • Common business oriented language COBOL
  • Customer information control system CICS
  • Embarcadero ER/Studio XE
  • Flat File Checker
  • Greenplum Database
  • Hewlett Packard HP-UX
  • HiT Software Allora
  • Human resource management software HRMS
  • IBM Clarity Systems Clarity
  • IBM Cognos Impromptu
  • IBM Domino
  • IBM InfoSphere DataStage
  • IBM Netezza TwinFin
  • IBM WebSphere
  • Informatica PowerCenter
  • Integrated development environment IDE software
  • InterMine
  • Jitterbit
  • Job control language JCL
  • Kalido Information Engine
  • KornShell
  • McAfee
  • MicroStrategy
  • Microsoft Dynamics
  • Microsoft Publisher
  • Microsoft Visual Basic Scripting Edition VBScript
  • Nagios
  • NetSuite ERP
  • NortonLifeLock cybersecurity software
  • Objective C
  • Oracle Business Intelligence Discoverer
  • Oracle Business Intelligence Enterprise Edition
  • Oracle E-Business Suite Financials
  • Oracle Fusion Applications
  • Oracle Hyperion
  • Oracle JD Edwards EnterpriseOne
  • Oracle SQL Loader
  • Oracle Solaris
  • Oracle Warehouse Builder
  • Oracle WebLogic Server
  • ParAccel Analytic Database
  • Pentaho Kettle
  • Perforce Helix software
  • Qlik Tech QlikView
  • Quest Erwin Data Modeler
  • Rapid-I RapidMiner
  • Relational database management software
  • Ruby on Rails
  • SAND
  • SAP Adaptive Server Enterprise
  • SAP Business Objects
  • SAP Crystal Reports
  • SAP IQ
  • SAP NetWeaver BW
  • SAP PowerDesigner
  • SAS Data Integration Server
  • SMSi Twister Data Integrator
  • Scriptella
  • StataCorp Stata
  • TIBCO Spotfire
  • Talend Big Data Integration
  • Talend Data Fabric
  • Talend Open Studio
  • TalendForge
  • Teradata BTEQ
  • Teradata FastExport
  • Teradata FastLoad
  • Teradata Parallel Transporter
  • Teradata Tpump
  • Ubuntu
  • Unified modeling language UML
  • VMware
  • Veritas NetBackup
  • WisdomForce DatabaseSync System

Where it concentrates

BLS doesn't publish wages for Data Warehousing Specialists separately. These are the figures for Database Architects (15-1243), its parent occupation.

Metro areas ranked by BLS location quotient: the occupation's share of the area's jobs divided by its share of all US jobs. Above 1 means more concentrated than the nation. Metros employing fewer than 100 are left out.

Metro areaEmploymentLocation quotientMedian annual
Cheyenne, WY1105.12$67,630
Olympia-Lacey-Tumwater, WA2103.82$133,500
Durham-Chapel Hill, NC5603.78$141,770
Washington-Arlington-Alexandria, DC-VA-MD-WV4,7403.50$162,870
Seattle-Tacoma-Bellevue, WA2,5002.77$105,430
Charlotte-Concord-Gastonia, NC-SC1,5602.66$138,870
Dallas-Fort Worth-Arlington, TX4,3202.47$154,770
San Jose-Sunnyvale-Santa Clara, CA1,1202.29$197,960
Omaha, NE-IA4902.27$136,620
Raleigh-Cary, NC7102.21$132,740

More metros, other thresholds