Occupation Summary

Data Warehousing Specialists

O*NET 15-1243.01

Description:

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

Annual Wages:
$139,570.00
Employment Rate:
Employment is expected to increase by 32.93%.
Education Level:
Bachelor's Degree. According to O*Net, the majority of people employed in this occupation have this level of education.
Endorsement:
Business and Industry, Science Technology Engineering and Math (STEM)

  1. Test software systems or applications for software enhancements or new products.
  2. Review designs, codes, test plans, or documentation to ensure quality.
  3. Provide or coordinate troubleshooting support for data warehouses.
  4. Prepare functional or technical documentation for data warehouses.
  5. Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
  6. Verify the structure, accuracy, or quality of warehouse data.
  7. Select methods, techniques, or criteria for data warehousing evaluative procedures.
  8. Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
  9. Map data between source systems, data warehouses, and data marts.
  10. Implement business rules via stored procedures, middleware, or other technologies.
  11. Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
  12. 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.
  13. Design and implement warehouse database structures.
  14. Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
  15. Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
  16. Create or implement metadata processes and frameworks.
  17. Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
  18. 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.


National Industry Employment Patterns


Industry % of Data Warehousing Specialists employed Annual Growth Rate
Computer systems design and related services 35.6 1.32
Insurance carriers 6.3 0.48
Employment services 4.5 0.00
Management, scientific, and technical consulting services 4.5 0.99
Software publishers 4.1 1.44
Professional and commercial equipment and supplies merchant wholesalers 2.3 0.00


Labor Market Information


2023 Statewide average hourly wage $67.10
2023 National average hourly wage $65.88
2022 National employment 64,000
2022 Texas employment 6,311
Texas projected employment by 2032 8,389
Texas projected annual employment and Turnover openings through 2032 630




TEXAS COUNTY MAP BY WORKFORCE DEVELOPMENT AREA
* Due to confidentiality rules, not all regions may have the data displayed. The sum of all the regions may not be equal to the state total.


Top 10 Relevant Knowledge Areas Relevant Importance Levels
Computers and Electronics
Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
85.20%
Mathematics
Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
64.60%
English Language
Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
63.60%
Design
Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models.
60.80%
Engineering and Technology
Knowledge of the practical application of engineering science and technology. This includes applying principles, techniques, procedures, and equipment to the design and production of various goods and services.
57.40%
Administration and Management
Knowledge of business and management principles involved in strategic planning, resource allocation, human resources modeling, leadership technique, production methods, and coordination of people and resources.
52.20%
Customer and Personal Service
Knowledge of principles and processes for providing customer and personal services. This includes customer needs assessment, meeting quality standards for services, and evaluation of customer satisfaction.
48.60%
Economics and Accounting
Knowledge of economic and accounting principles and practices, the financial markets, banking, and the analysis and reporting of financial data.
44.40%
Education and Training
Knowledge of principles and methods for curriculum and training design, teaching and instruction for individuals and groups, and the measurement of training effects.
44.40%
Production and Processing
Knowledge of raw materials, production processes, quality control, costs, and other techniques for maximizing the effective manufacture and distribution of goods.
42.60%


Top 10 Relevant Skill Areas Relevant Importance Levels
Reading Comprehension
Understanding written sentences and paragraphs in work-related documents.
77.60%
Critical Thinking
Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
77.60%
Programming
Writing computer programs for various purposes.
75.00%
Complex Problem Solving
Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
72.40%
Active Listening
Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
70.00%
Systems Analysis
Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
70.00%
Judgment and Decision Making
Considering the relative costs and benefits of potential actions to choose the most appropriate one.
67.60%
Speaking
Talking to others to convey information effectively.
67.60%
Writing
Communicating effectively in writing as appropriate for the needs of the audience.
65.00%
Systems Evaluation
Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system.
65.00%


Top 10 Relevant Abilities Relevant Importance Levels
Written Comprehension
The ability to read and understand information and ideas presented in writing.
77.60%
Information Ordering
The ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations).
77.60%
Oral Comprehension
The ability to listen to and understand information and ideas presented through spoken words and sentences.
75.00%
Deductive Reasoning
The ability to apply general rules to specific problems to produce answers that make sense.
75.00%
Inductive Reasoning
The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
75.00%
Near Vision
The ability to see details at close range (within a few feet of the observer).
72.40%
Speech Recognition
The ability to identify and understand the speech of another person.
70.00%
Oral Expression
The ability to communicate information and ideas in speaking so others will understand.
70.00%
Written Expression
The ability to communicate information and ideas in writing so others will understand.
70.00%
Category Flexibility
The ability to generate or use different sets of rules for combining or grouping things in different ways.
70.00%


  • Working with Computers
    -- Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
  • Analyzing Data or Information
    -- Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
  • Processing Information
    -- Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
  • Getting Information
    -- Observing, receiving, and otherwise obtaining information from all relevant sources.
  • Updating and Using Relevant Knowledge
    -- Keeping up-to-date technically and applying new knowledge to your job.
Other Activities


  • Achievement
    - Occupations that satisfy this work value are results oriented and allow employees to use their strongest abilities, giving them a feeling of accomplishment. Corresponding needs are Ability Utilization and Achievement.
  • Working Conditions
    - Occupations that satisfy this work value offer job security and good working conditions. Corresponding needs are Activity, Compensation, Independence, Security, Variety and Working Conditions.



Tools

Computer servers: Storage servers; Computer servers;

Desktop computers: Desktop computers;

High end computer servers: Data warehouse appliances;

Mainframe computers: Mainframe computers;

Notebook computers: Laptop computers;

Personal computers: Personal computers;

Special purpose telephones: Multi-line telephone systems;


Technology

Analytical or scientific software: IBM SPSS Statistics; SAS; StataCorp Stata; The MathWorks MATLAB;

Application server software: Oracle WebLogic Server;

Backup or archival software: Veritas NetBackup;

Business intelligence and data analysis software: TIBCO Spotfire; Qlik Tech QlikView; Tableau; Microsoft Power BI; MicroStrategy; Oracle Business Intelligence Enterprise Edition; IBM Cognos Impromptu;

Cloud-based data access and sharing software: Microsoft SharePoint;

Cloud-based management software: Splunk Enterprise; IBM WebSphere; Jitterbit;

Clustering software: Aster Data nCluster; VMware;

Communications server software: IBM Domino;

Configuration management software: Perforce Helix software;

Content workflow software: Atlassian JIRA;

Customer relationship management CRM software: Blackbaud The Raiser's Edge;

Data base management system software: CodeFutures dbShards; Apache Sqoop; Amazon DynamoDB; Apache Cassandra; Apache Flume; Apache Hadoop; Apache HBase; Apache Oozie; Apache Pig; Apache Solr; Greenplum Database; InterMine; Kalido Information Engine; ParAccel Analytic Database; Relational database management software; SAND; SAP Adaptive Server Enterprise; SAP IQ; Talend Big Data Integration; TalendForge; Teradata Database; MongoDB; NoSQL; Oracle PL/SQL;

Data base reporting software: Oracle SQL Loader; Microsoft SQL Server Reporting Services SSRS; SAP Crystal Reports; Oracle Business Intelligence Discoverer; IBM Netezza TwinFin;

Data base user interface and query software: Microsoft Access; Apache Hive; Amazon Elastic Compute Cloud EC2; Amazon Redshift; Amazon Web Services AWS software; Cloudera Impala; Teradata BTEQ; Structured query language SQL; Oracle Database; MySQL; Microsoft SQL Server; Transact-SQL;

Data mining software: Teradata FastLoad; Teradata Parallel Transporter; Teradata Tpump; SAP NetWeaver BW; Rapid-I RapidMiner;

Desktop publishing software: Microsoft Publisher;

Development environment software: Microsoft .NET Framework; Microsoft Visual Basic; Microsoft Visual Basic Scripting Edition VBScript; Microsoft Visual Studio; CloverETL; C; Adeptia ETL Suite; Microsoft Azure software; Integrated development environment IDE software; Common business oriented language COBOL; Eclipse IDE; Apache Kafka;

Document management software: Teradata FastExport;

Electronic mail software: Microsoft Outlook;

Enterprise application integration software: Microsoft SQL Server Integration Services SSIS; SMSi Twister Data Integrator; Extensible markup language XML; IBM InfoSphere DataStage; Talend Open Studio;

Enterprise resource planning ERP software: IBM Clarity Systems Clarity; Microsoft Dynamics; SAP software; SAP Business Objects; NetSuite ERP; Oracle Fusion Applications; Oracle Hyperion; Oracle JD Edwards EnterpriseOne; Oracle PeopleSoft;

File versioning software: Apache Subversion SVN;

Financial analysis software: Oracle E-Business Suite Financials;

Geographic information system: ESRI ArcGIS software;

Human resources software: Human resource management software HRMS;

Information retrieval or search software: Apache Avro;

Metadata management software: Apatar; Coglin Mill RODIN; Adaptive Metadata Manager; Altova MapForce; HiT Software Allora; Flat File Checker; Embarcadero ER/Studio XE; Informatica PowerCenter; Informatica software; Oracle Warehouse Builder; SAP PowerDesigner; Quest Erwin Data Modeler; Pentaho Kettle; SAS Data Integration Server; Scriptella; Talend Data Fabric; WisdomForce DatabaseSync System;

Network monitoring software: Nagios;

Object or component oriented development software: Oracle Java; Objective C; Scala; Perl; R; Python; Advanced business application programming ABAP; Apache Spark; C#; C++;

Object oriented data base management software: PostgreSQL;

Office suite software: Microsoft Office software;

Operating system software: Microsoft Windows; Oracle Solaris; Red Hat Enterprise Linux; Shell script; Apple macOS; Bash; Job control language JCL; KornShell; Linux; Hewlett Packard HP-UX; UNIX; UNIX Shell; Ubuntu;

Portal server software: Apache HTTP Server;

Presentation software: Microsoft PowerPoint;

Process mapping and design software: Microsoft Visio;

Project management software: Microsoft Project;

Requirements analysis and system architecture software: Unified modeling language UML;

Spreadsheet software: Microsoft Excel;

Storage networking software: Amazon Simple Storage Service S3;

Transaction security and virus protection software: McAfee; NortonLifeLock cybersecurity software;

Transaction server software: Customer information control system CICS;

Web platform development software: Ruby on Rails;

Word processing software: Microsoft Word;


Related O*NET occupational titles for Data Warehousing Specialists include:
  • 15-1299.07 Blockchain Engineers
  • 15-2051.01 Business Intelligence Analysts
  • 15-1251.00 Computer Programmers
  • 15-1211.00 Computer Systems Analysts
  • 15-1299.08 Computer Systems Engineers/Architects
  • 15-2051.00 Data Scientists
  • 15-1242.00 Database Administrators
  • 15-1243.00 Database Architects
  • 15-1252.00 Software Developers
  • 15-1253.00 Software Quality Assurance Analysts and Testers


Sources of Additional Information
  • For more information about database administrators and architects, visit: Association for Computing Machinery
  • Computing Research Association
  • IEEE Computer Society
  • For more information about opportunities for women pursuing information technology careers, visit: National Center for Women & Information Technology
  • For a career video on database administrators and architects, visit: Database Architects
  • Data Warehousing Specialists
  • Database Administrators
  • Database Architects

  • Contact Texas Workforce Commission
    Labor Market and Career Information  |  101 E. 15th Street, Annex Room 0252  |  Austin, Texas 78778
    Official Website  |  1-800-822-PLAN (7526)  |  512.936.3200

    ** The information in this report may be derived from many sources like O*NET, BLS (Bureau of Labor Statistics), OOH (Occupational Outlook Handbook), and Career One Stop.