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 at the level of the job family, Data and analytics:

  • Task levelPartialOne direct benchmark, near its ceiling. On Spider 2.0-Snow, which asks for multi-step SQL against large business databases, the top agent reaches 96.7% execution accuracy, but the entry names no model. Adjacent spreadsheet tasks agree (83.1% on SpreadsheetBench). No benchmark in our collection tests open-ended analysis, where the right question is itself unclear.
  • Project levelPartialMixed, adjacent evidence. On MLE-bench, 75 offline Kaggle competitions, the best agent wins a medal in 64.4% of competitions. The Remote Labor Index includes data analysis projects; across all its projects, the best agent completed 15.8% to a standard a client would accept.

Benchmarks for this occupation

Benchmarks for the job family

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

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