Skip navigation

Data Warehousing Specialists - 15-1199.07

O*NET-SOC Description

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

Sample of Reported Job Titles

  • Data Warehouse Analyst
  • Data Warehouse Manager
  • Data Warehouse Solution Architect

SOC Occupation Groups

Related Occupations

No information available.

Tasks

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

Detailed Work Activities

  • Analyze data to identify trends or relationships among variables.
  • Create databases to store electronic data.
  • Design software applications.
  • Develop diagrams or flow charts of system operation.
  • Develop models of information or communications systems.
  • Develop performance metrics or standards related to information technology.
  • Develop procedures for data management.
  • Develop testing routines or procedures.
  • Document operational procedures.
  • Evaluate data quality.
  • Evaluate project designs to determine adequacy or feasibility.
  • Modify software programs to improve performance.
  • Test software performance.
  • Troubleshoot issues with computer applications or systems.
  • Write computer programming code.

Military Crosswalk Titles

  • Computer Systems Programming (Air Force - Enlisted)
  • Computer Systems Programming Apprentice (Air Force - Enlisted)
  • Computer Systems Programming Craftsman (Air Force - Enlisted)
  • Computer Systems Programming Helper (Air Force - Enlisted)
  • Computer Systems Programming Journeyman (Air Force - Enlisted)

Apprenticeship Crosswalk Titles

No information available.

DOT Crosswalk Titles

No information available.