Data Warehousing Specialists
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
- O*NET-SOC code
15-1243.01 - Preparation Job Zone Four: Considerable Preparation Needed
Wages
BLS doesn't publish wages for Data Warehousing Specialists separately. These are the figures for Database Architects (15-1243), its parent occupation.
| 10th | 25th | Median | 75th | 90th |
|---|---|---|---|---|
| $86,240 | $109,370 | $139,500 | $169,290 | $204,000 |
By state (49)
| State | Employment | Median annual | Location quotient |
|---|---|---|---|
| Alabama | 270 | $105,450 | 0.29 |
| Alaska | 70 | $112,500 | 0.53 |
| Arizona | 1,200 | $156,100 | 0.86 |
| Arkansas | 360 | $104,070 | 0.63 |
| California | 6,210 | $170,160 | 0.79 |
| Colorado | 1,950 | $154,560 | 1.57 |
| Connecticut | 1,140 | $144,460 | 1.55 |
| Delaware | $147,800 | ||
| District of Columbia | 790 | $150,010 | 2.61 |
| Florida | 1,810 | $138,320 | 0.42 |
| Georgia | 2,590 | $139,500 | 1.23 |
| Hawaii | 60 | $134,040 | 0.22 |
| Idaho | 260 | $121,380 | 0.69 |
| Illinois | 1,590 | $142,500 | 0.60 |
| Indiana | 500 | $132,830 | 0.36 |
| Iowa | 240 | $124,040 | 0.36 |
| Kansas | 360 | $129,990 | 0.57 |
| Kentucky | 350 | $125,400 | 0.40 |
| Maine | 190 | $133,120 | 0.69 |
| Maryland | 1,370 | $132,940 | 1.14 |
| Massachusetts | 2,690 | $161,650 | 1.71 |
| Michigan | 1,390 | $131,000 | 0.73 |
| Minnesota | 1,240 | $133,050 | 0.98 |
| Mississippi | 100 | $98,420 | 0.20 |
| Missouri | 1,410 | $110,570 | 1.11 |
| Montana | $109,990 | ||
| Nebraska | 610 | $134,320 | 1.39 |
| Nevada | 420 | $140,200 | 0.63 |
| New Hampshire | 120 | $139,990 | 0.40 |
| New Jersey | 3,090 | $120,790 | 1.67 |
| New Mexico | 120 | $117,950 | 0.32 |
| New York | 3,850 | $141,350 | 0.92 |
| North Carolina | 4,070 | $134,630 | 1.91 |
| North Dakota | 60 | $109,430 | 0.30 |
| Ohio | 1,820 | $132,910 | 0.76 |
| Oklahoma | 860 | $110,110 | 1.17 |
| Oregon | 730 | $138,250 | 0.86 |
| Pennsylvania | 2,840 | Not available | 1.09 |
| Rhode Island | 160 | $140,320 | 0.72 |
| South Carolina | 1,160 | $130,000 | 1.16 |
| South Dakota | 40 | $136,540 | 0.20 |
| Tennessee | 650 | $115,170 | 0.46 |
| Texas | 8,270 | $151,370 | 1.36 |
| Utah | 630 | $131,740 | 0.84 |
| Virginia | 5,260 | $160,360 | 2.96 |
| Washington | 2,990 | $128,760 | 1.95 |
| West Virginia | 120 | Not available | 0.40 |
| Wisconsin | 520 | $137,810 | 0.41 |
| Wyoming | 160 | Not available | 1.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.
Circles are the 20 most similar occupations, coloured by Job Zone. Lines join pairs where one is among the other's 10 most similar; darker lines are pairs O*NET also lists as related. Drag a circle to move it out of the way; select one to open it.
| # | Occupation | Job Zone | Similarity |
|---|---|---|---|
| 1 | Database Architects | 4 | 0.975 |
| 2 | Database Administrators | 4 | 0.967 |
| 3 | Blockchain Engineers | 4 | 0.965 |
| 4 | Information Security Engineers | 4 | 0.964 |
| 5 | Business Intelligence Analysts | 4 | 0.963 |
| 6 | Web Developers | 3 | 0.963 |
| 7 | Software Quality Assurance Analysts and Testers | 4 | 0.957 |
| 8 | Computer Systems Analysts | 4 | 0.956 |
| 9 | Computer and Information Research Scientists | 5 | 0.956 |
| 10 | Computer Programmers | 4 | 0.955 |
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.
| Occupation | Skill to build | Level gap | Similarity |
|---|---|---|---|
| Database Architects | Technology Design | 3.00 | 0.975 |
| Business Intelligence Analysts | Active Learning | 0.87 | 0.963 |
| Software Quality Assurance Analysts and Testers | Quality Control Analysis | 3.62 | 0.957 |
| Software Developers | Technology Design | 3.62 | 0.951 |
| Video Game Designers | Technology Design | 3.00 | 0.938 |
| Web Administrators | Quality Control Analysis | 3.38 | 0.935 |
| Bioinformatics Technicians | Science | 3.38 | 0.934 |
| Computer Hardware Engineers | Active Learning | 0.87 | 0.924 |
| Social Science Research Assistants | Science | 3.38 | 0.923 |
| Statistical Assistants | Mathematics | 1.63 | 0.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.
| Software | Similar jobs using it | Lift |
|---|---|---|
| Go | 15 of 20 | 24.7x |
| Amazon Web Services AWS CloudFormation | 13 of 20 | 31.6x |
| GitHub | 15 of 20 | 19.8x |
| Spring Framework | 12 of 20 | 34.6x |
| Node.js | 13 of 20 | 25.0x |
| Elasticsearch | 13 of 20 | 24.0x |
| Git | 15 of 20 | 14.7x |
| PHP | 15 of 20 | 14.7x |
| Microsoft Windows Server | 13 of 20 | 22.2x |
| Red Hat WildFly | 12 of 20 | 27.7x |
Skills
From O*NET data. Importance is rated 1 to 5 and level 0 to 7.
| Skill | Type | Importance | Level |
|---|---|---|---|
| Reading Comprehension | Essential skill | 3.88 | 4.00 |
| Critical Thinking | Essential skill | 3.88 | 3.88 |
| Programming | Transferable skill | 3.75 | 3.75 |
| Complex Problem Solving | Transferable skill | 3.62 | 3.50 |
| Active Listening | Essential skill | 3.50 | 3.62 |
| Systems Analysis | Transferable skill | 3.50 | 3.50 |
| Judgment and Decision Making | Transferable skill | 3.38 | 3.62 |
| Speaking | Essential skill | 3.38 | 3.62 |
| Systems Evaluation | Transferable skill | 3.25 | 3.50 |
| Writing | Essential skill | 3.25 | 3.38 |
| Coordination | Transferable skill | 3.12 | 3.38 |
| Active Learning | Essential skill | 3.00 | 3.25 |
| Mathematics | Essential skill | 3.00 | 3.25 |
| Social Perceptiveness | Transferable skill | 3.00 | 3.00 |
| Monitoring | Essential skill | 2.88 | 3.12 |
| Time Management | Transferable skill | 2.88 | 2.75 |
| Operations Analysis | Transferable skill | 2.75 | 3.38 |
| Persuasion | Transferable skill | 2.75 | 3.12 |
| Technology Design | Transferable skill | 2.62 | not rated |
| Instructing | Transferable skill | 2.62 | 3.38 |
| Learning Strategies | Essential skill | 2.62 | 2.75 |
| Negotiation | Transferable skill | 2.62 | 2.62 |
| Service Orientation | Transferable skill | 2.62 | 2.62 |
| Operations Monitoring | Transferable skill | 2.50 | 2.25 |
| Quality Control Analysis | Transferable skill | 2.38 | not rated |
| Management of Personnel Resources | Transferable skill | 2.12 | 2.00 |
| Operation and Control | Transferable skill | 1.88 | not rated |
| Science | Essential skill | 1.88 | not rated |
| Management of Material Resources | Transferable skill | 1.88 | 1.62 |
| Management of Financial Resources | Transferable skill | 1.75 | 1.38 |
| Troubleshooting | Transferable skill | 1.62 | 1.00 |
| Equipment Selection | Transferable skill | 1.50 | not rated |
| Equipment Maintenance | Transferable skill | 1.12 | not rated |
| Repairing | Transferable skill | 1.12 | not rated |
| Installation | Transferable skill | 1.00 | not rated |
Knowledge (33) and abilities (52)
| Name | Importance | Level |
|---|---|---|
| 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.26 | not rated |
| Physics | 1.18 | not rated |
| Public Safety and Security | 1.17 | not rated |
| Transportation | 1.17 | not rated |
| Foreign Language | 1.13 | not rated |
| Medicine and Dentistry | 1.13 | not rated |
| Building and Construction | 1.09 | not rated |
| Fine Arts | 1.09 | not rated |
| Philosophy and Theology | 1.09 | not rated |
| History and Archeology | 1.05 | not rated |
| Mechanical | 1.05 | not rated |
| Biology | 1.00 | not rated |
| Chemistry | 1.00 | not rated |
| Food Production | 1.00 | not rated |
| Therapy and Counseling | 1.00 | not rated |
| Name | Importance | Level |
|---|---|---|
| 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.25 | not rated |
| Finger Dexterity | 1.25 | not rated |
| Speed of Limb Movement | 1.12 | not rated |
| Control Precision | 1.00 | not rated |
| Dynamic Flexibility | 1.00 | not rated |
| Explosive Strength | 1.00 | not rated |
| Extent Flexibility | 1.00 | not rated |
| Glare Sensitivity | 1.00 | not rated |
| Gross Body Coordination | 1.00 | not rated |
| Gross Body Equilibrium | 1.00 | not rated |
| Manual Dexterity | 1.00 | not rated |
| Multilimb Coordination | 1.00 | not rated |
| Night Vision | 1.00 | not rated |
| Peripheral Vision | 1.00 | not rated |
| Rate Control | 1.00 | not rated |
| Reaction Time | 1.00 | not rated |
| Response Orientation | 1.00 | not rated |
| Sound Localization | 1.00 | not rated |
| Spatial Orientation | 1.00 | not rated |
| Stamina | 1.00 | not rated |
| Static Strength | 1.00 | not rated |
Software used
Examples from O*NET data. "Hot" and "in demand" are O*NET flags for technologies often listed in job postings.
- Microsoft Access in demand
- Microsoft Excel in demand
- Microsoft Office software in demand
- Microsoft Outlook in demand
- Microsoft Power BI in demand
- Microsoft PowerPoint in demand
- Python in demand
- Structured query language SQL in demand
- Tableau in demand
- Operational Data Store ODS software in demand
- Amazon DynamoDB hot
- Amazon Elastic Compute Cloud EC2 hot
- Amazon Redshift hot
- Amazon Web Services AWS software hot
- Apache Cassandra hot
- Apache Hadoop hot
- Apache Hive hot
- Apache Kafka hot
- Apache Spark hot
- Apache Subversion SVN hot
- Apple macOS hot
- Atlassian JIRA hot
- Bash hot
- C hot
- C# hot
- C++ hot
- ESRI ArcGIS software hot
- Eclipse IDE hot
- Extensible markup language XML hot
- IBM SPSS Statistics hot
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 area | Employment | Location quotient | Median annual |
|---|---|---|---|
| Cheyenne, WY | 110 | 5.12 | $67,630 |
| Olympia-Lacey-Tumwater, WA | 210 | 3.82 | $133,500 |
| Durham-Chapel Hill, NC | 560 | 3.78 | $141,770 |
| Washington-Arlington-Alexandria, DC-VA-MD-WV | 4,740 | 3.50 | $162,870 |
| Seattle-Tacoma-Bellevue, WA | 2,500 | 2.77 | $105,430 |
| Charlotte-Concord-Gastonia, NC-SC | 1,560 | 2.66 | $138,870 |
| Dallas-Fort Worth-Arlington, TX | 4,320 | 2.47 | $154,770 |
| San Jose-Sunnyvale-Santa Clara, CA | 1,120 | 2.29 | $197,960 |
| Omaha, NE-IA | 490 | 2.27 | $136,620 |
| Raleigh-Cary, NC | 710 | 2.21 | $132,740 |