Skip to content

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.

From O*NET 30.3

Tasks

From O*NET 30.3, by importance, as O*NET OnLine lists them

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

Technology Skills

From O*NET 30.3, 159 examples in 42 categories, 64 Hot Technology

Free · O*NET 30.3

Metadata management software

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

Development environment software

  • Adeptia ETL Suite
  • Apache KafkaHot Technology
  • CHot Technology
  • CloverETL
  • Common business oriented language COBOL
  • Eclipse IDEHot Technology
  • Integrated development environment IDE software
  • Microsoft .NET FrameworkHot Technology
  • Microsoft Azure softwareHot Technology
  • Microsoft Visual BasicHot Technology
  • Microsoft Visual Basic Scripting Edition VBScript
  • Microsoft Visual StudioHot Technology

Object or component oriented development software

  • Advanced business application programming ABAP
  • Apache SparkHot Technology
  • C#Hot Technology
  • C++Hot Technology
  • Objective C
  • Oracle JavaHot Technology
  • PerlHot Technology
  • PythonHot TechnologyIn Demand
  • RHot Technology
  • ScalaHot Technology

Data base management system software

  • Amazon DynamoDBHot Technology
  • Apache CassandraHot Technology
  • Apache Flume
  • Apache HadoopHot Technology
  • Apache HBase
  • Apache Oozie
  • Apache Pig
  • Apache Solr
  • Apache Sqoop
  • CodeFutures dbShards
  • Greenplum Database
  • InterMine
  • Kalido Information Engine
  • MongoDBHot Technology
  • NoSQLHot Technology
  • Oracle PL/SQLHot Technology
  • ParAccel Analytic Database
  • Relational database management software
  • SAND
  • SAP Adaptive Server Enterprise
  • SAP IQ
  • Talend Big Data Integration
  • TalendForge
  • Teradata DatabaseHot Technology

Data base user interface and query software

  • Amazon Elastic Compute Cloud EC2Hot Technology
  • Amazon RedshiftHot Technology
  • Amazon Web Services AWS softwareHot Technology
  • Apache HiveHot Technology
  • Cloudera Impala
  • Microsoft AccessHot TechnologyIn Demand
  • Microsoft SQL ServerHot Technology
  • MySQLHot Technology
  • Operational Data Store ODS softwareIn Demand
  • Oracle DatabaseHot Technology
  • Structured query language SQLHot TechnologyIn Demand
  • Teradata BTEQ
  • Transact-SQLHot Technology

Storage networking software

  • Amazon Simple Storage Service S3

Information retrieval or search software

  • Apache Avro

Portal server software

  • Apache HTTP Server

File versioning software

  • Apache Subversion SVNHot Technology

Operating system software

  • Apple macOSHot Technology
  • BashHot Technology
  • Hewlett Packard HP-UX
  • Job control language JCL
  • KornShell
  • LinuxHot Technology
  • Microsoft WindowsHot Technology
  • Oracle Solaris
  • Red Hat Enterprise LinuxHot Technology
  • Shell scriptHot Technology
  • Ubuntu
  • UNIXHot Technology
  • UNIX ShellHot Technology

Clustering software

  • Aster Data nCluster
  • VMware

Content workflow software

  • Atlassian JIRAHot Technology

Customer relationship management CRM software

  • Blackbaud The Raiser's Edge

Transaction server software

  • Customer information control system CICS

Geographic information system

  • ESRI ArcGIS softwareHot Technology

Enterprise application integration software

  • Extensible markup language XMLHot Technology
  • IBM InfoSphere DataStage
  • Microsoft SQL Server Integration Services SSISHot Technology
  • SMSi Twister Data Integrator
  • Talend Open Studio

Human resources software

  • Human resource management software HRMS

Enterprise resource planning ERP software

  • IBM Clarity Systems Clarity
  • Microsoft Dynamics
  • NetSuite ERP
  • Oracle Fusion Applications
  • Oracle Hyperion
  • Oracle JD Edwards EnterpriseOne
  • Oracle PeopleSoftHot Technology
  • SAP Business Objects
  • SAP softwareHot Technology

Business intelligence and data analysis software

  • IBM Cognos Impromptu
  • Microsoft Power BIHot TechnologyIn Demand
  • MicroStrategy
  • Oracle Business Intelligence Enterprise Edition
  • Qlik Tech QlikView
  • TableauHot TechnologyIn Demand
  • TIBCO Spotfire

Communications server software

  • IBM Domino

Data base reporting software

  • IBM Netezza TwinFin
  • Microsoft SQL Server Reporting Services SSRSHot Technology
  • Oracle Business Intelligence Discoverer
  • Oracle SQL Loader
  • SAP Crystal Reports

Analytical or scientific software

  • IBM SPSS StatisticsHot Technology
  • SASHot Technology
  • StataCorp Stata
  • The MathWorks MATLABHot Technology

Cloud-based management software

  • IBM WebSphere
  • Jitterbit
  • Splunk EnterpriseHot Technology

Transaction security and virus protection software

  • McAfee
  • NortonLifeLock cybersecurity software

Spreadsheet software

  • Microsoft ExcelHot TechnologyIn Demand

Office suite software

  • Microsoft Office softwareHot TechnologyIn Demand

Electronic mail software

  • Microsoft OutlookHot TechnologyIn Demand

Presentation software

  • Microsoft PowerPointHot TechnologyIn Demand

Project management software

  • Microsoft ProjectHot Technology

Desktop publishing software

  • Microsoft Publisher

Document management software

  • Microsoft SharePointHot Technology
  • Teradata FastExport

Process mapping and design software

  • Microsoft VisioHot Technology

Word processing software

  • Microsoft WordHot Technology

Network monitoring software

  • Nagios

Financial analysis software

  • Oracle E-Business Suite Financials

Application server software

  • Oracle WebLogic Server

Configuration management software

  • Perforce Helix software

Object oriented data base management software

  • PostgreSQLHot Technology

Data mining software

  • Rapid-I RapidMiner
  • SAP NetWeaver BW
  • Teradata FastLoad
  • Teradata Parallel Transporter
  • Teradata Tpump

Web platform development software

  • Ruby on Rails

Requirements analysis and system architecture software

  • Unified modeling language UML

Backup or archival software

  • Veritas NetBackup

Detailed Work Activities

From O*NET 30.3, under their work activities; open one for the AI skills Workforce Automation maps to it

Free · O*NET 30.3

Inspecting Equipment, Structures, or Materials

  • Test software performance.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet

Judging the Qualities of Objects, Services, or People

  • Evaluate project designs to determine adequacy or feasibility.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet

Processing Information

  • Evaluate data quality.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet

Analyzing Data or Information

  • Analyze data to identify trends or relationships among variables.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet

Making Decisions and Solving Problems

  • Apply new technologies to improve work processes.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet

Thinking Creatively

  • Design software applications.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 5 of 29 AI skills mapped to this activity, by automation level

    • Augments 9
    • Supports 13
    • Informs 7
  • Apply information technology to solve business or other applied problems.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet
  • Modify software programs to improve performance.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 5 of 24 AI skills mapped to this activity, by automation level

    • Augments 11
    • Supports 8
    • Informs 5
    • golang-performancesamber/cc-skills-golang42,006 installsAugments
      Gen Agent Trust Hub Pass
      Snyk Pass
      Socket Pass
      ZeroLeaks Pass
    • Wp performanceclaudeskills.infoAugments
    • Performancecognitedata/dune-skills338 installsAugments
      Gen Agent Trust Hub Pass
      Snyk Pass
      Socket Pass
      ZeroLeaks Pass
    • Vtex io application performancevtex/skills1,158 installsAugments
      Gen Agent Trust Hub Pass
      Snyk Pass
      Socket Pass
      ZeroLeaks Pass
    • Agent orchestration improve agentsickn33/antigravity-awesome-skills574 installsAugments
      Gen Agent Trust Hub Pass
      Runlayer Warn
      Snyk Pass
      Socket Pass
      ZeroLeaks Pass
  • Create databases to store electronic data.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet
  • Develop diagrams or flow charts of system operation.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet

Working with Computers

  • Write computer programming code.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet
  • Troubleshoot issues with computer applications or systems.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 5 of 22 AI skills mapped to this activity, by automation level

    • Replaces 1
    • Augments 13
    • Supports 7
    • Informs 1

Drafting, Laying Out, and Specifying Technical Devices, Parts, and Equipment

  • Develop performance metrics or standards related to information technology.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 5 of 11 AI skills mapped to this activity, by automation level

    • Augments 4
    • Supports 4
    • Informs 3
  • Develop models of information or communications systems.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet
  • Develop procedures for data management.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 0 of 0 AI skills mapped to this activity, by automation level

    • No tools yet
    • Not mapped yet
  • Develop testing routines or procedures.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 5 of 33 AI skills mapped to this activity, by automation level

    • Replaces 4
    • Augments 20
    • Supports 9

Documenting/Recording Information

  • Document operational procedures.
    WFA · Part of the paid plan when accounts open

    WFA (Workforce Automation) analysis: 5 of 41 AI skills mapped to this activity, by automation level

    • Replaces 3
    • Augments 24
    • Supports 11
    • Informs 3

Job Zone

From O*NET 30.3

Free · O*NET 30.3

Job Zone Four: Considerable Preparation Needed

Workforce Automation analysis, not part of the source

WFA coverage: AI skills for this job

WFA · Part of the paid plan when accounts open

Pilot mapping: these skill links come from our seed list and haven’t been reviewed yet. Expect them to change as each one is checked.

DWAs covered by an AI skill6 of 17
Distinct tools157
Level mix
  • Replaces 8
  • Augments 79
  • Supports 52
  • Informs 19

Equivalents

NICE work roles, with their DCWF equivalents

Mapped to this job by the ETO-CSET NICE/O*NET crosswalk (2024); roles from NICE Framework Components v2.2.0, DCWF equivalents from DoD DCWF Tool v5.3 (2026-09-25)

Free · NICE Framework Components v2.2.0 and DoD DCWF Tool v5.3 (2026-09-25)

No NICE work role maps to this job.