Can Agents Work?

Jobs / Data and analytics / 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.

US jobs
67,140 (SOC 15-1243 group, "Database Architects")
Median wage
$139,500 a year
Job family
Data and analytics

Can agents do the work of data warehousing specialists?

We read the evidence for the whole job family, Data and analytics: Some tasks (no change in 12 months)

Agents complete 20% or more of the tasks (or projects) on a direct benchmark.

Evidence: Spider 2.0, 96.7% of tasks completed.

7% of this occupation's work, by O*NET work activities, is measured by a direct benchmark (figures for the SOC 15-1243 group).

  • 19%Develop operational or technical procedures or standardsNot measured
  • 14%Design databasesNot measured
  • 9%Develop models of systems, processes, or productsNot measured
  • 6%Design computer or information systems or applicationsNot measured
  • 5%Resolve computer problemsNot measured
  • 5%Create visual designs or displaysNot measured
  • 4%Evaluate the characteristics, usefulness, or performance of products or technologiesNot measured
  • 4%Maintain operational recordsNot measured

Benchmarks for this occupation

These benchmarks name this occupation in their job mapping.

Direct evidence

Work benchmarks mapped primary to this family. They set the step when they report how many tasks agents complete.

Benchmarks for the job family

These cover work in data and analytics, not always this occupation's tasks.

Also relevant

These benchmarks cover part of this family's work, or have no result yet. They do not set its step.

Context only

These benchmarks span many occupations, or they test how agents behave. They give context but do not set the step.

Typical tasks

From O*NET 31.0. Core tasks first. Few of these tasks have a benchmark today.

  • 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.
  • 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.
  • Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
  • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
  • Create or implement metadata processes and frameworks.
Other job titles for this occupation (27)

Data Warehouse Analyst · Data Warehouse Solution Architect · Analytics Manager · Big Data Engineer · Data Integrity Specialist · Data Management Engineer · Data Management Manager · Data Management Specialist · Data Migration Specialist · Data Quality Analyst · Data Specialist · Data Storage Specialist · Data Warehouse Developer · Data Warehouse Engineer · Data Warehouse ETL Developer (Data Warehouse Extract, Transform, and Load Developer) · Data Warehouse Programmer · Data Warehouse Specialist · Data Warehousing Engineer · Data Warehousing Specialist · Database Specialist · ETL Developer (Extract-Transform-Load Developer) · ETL Tester (Extract-Transform-Load Tester) · IT Data Specialist (Information Technology Data Specialist) · Product Data Specialist · Provider Data Specialist · Research Data Specialist · Storage Engineer