More information from O*NET OnLine:

Data Warehousing Specialists - 15-1243.01

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 Solution Architect

SOC Occupation Groups

15-0000	Computer and Mathematical Occupations
15-1200	Computer Occupations
15-1240	Database and Network Administrators and Architects
15-1243.00	Database Architects
15-1243.01	Data Warehousing Specialists

Related Occupations

15-1211.00	Computer Systems Analysts Bright Outlook
15-1242.00	Database Administrators
15-1243.00	Database Architects
15-1251.00	Computer Programmers
15-1252.00	Software Developers
15-1253.00	Software Quality Assurance Analysts and Testers
15-1299.07	Blockchain Engineers
15-1299.08	Computer Systems Engineers/Architects
15-2051.00	Data Scientists
15-2051.01	Business Intelligence Analysts

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.
Apply information technology to solve business or other applied problems.
Apply new technologies to improve work processes.
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

Applications Developer (Marine Corps - Enlisted)
Cyber Defense Operations (Air Force - Enlisted)
Cyber Defense Operations Apprentice (Air Force - Enlisted)
Cyber Defense Operations Apprentice, Client Systems Operations (Air Force - Enlisted)
Cyber Defense Operations Apprentice, Data Operations (Air Force - Enlisted)
Cyber Defense Operations Apprentice, Enterprise Operations (Air Force - Enlisted)
Cyber Defense Operations Apprentice, Expeditionary Communications (Air Force - Enlisted)
Cyber Defense Operations Apprentice, Knowledge Operations (Air Force - Enlisted)
Cyber Defense Operations Apprentice, Mission Defense Activities (Air Force - Enlisted)
Cyber Defense Operations Apprentice, Networks Operations (Air Force - Enlisted)
Cyber Defense Operations Apprentice, RF Operations (Air Force - Enlisted)
Cyber Defense Operations Apprentice, Security Operations (Air Force - Enlisted)
Cyber Defense Operations Apprentice, Software Development Operations (Air Force - Enlisted)
Cyber Defense Operations Apprentice, Systems Operations (Air Force - Enlisted)
Cyber Defense Operations Craftsman (Air Force - Enlisted)
Cyber Defense Operations Craftsman, Data Operations (Air Force - Enlisted)
Cyber Defense Operations Craftsman, Enterprise Operations (Air Force - Enlisted)
Cyber Defense Operations Craftsman, Expeditionary Communications (Air Force - Enlisted)
Cyber Defense Operations Craftsman, Mission Defense Activities (Air Force - Enlisted)

Cyber Defense Operations Helper (Air Force - Enlisted)
Cyber Defense Operations Helper, Data Operations (Air Force - Enlisted)
Cyber Defense Operations Helper, Enterprise Operations (Air Force - Enlisted)
Cyber Defense Operations Helper, Expeditionary Communications (Air Force - Enlisted)
Cyber Defense Operations Helper, Mission Defense Activities (Air Force - Enlisted)
Cyber Defense Operations Journeyman (Air Force - Enlisted)
Cyber Defense Operations Journeyman, Data Operations (Air Force - Enlisted)
Cyber Defense Operations Journeyman, Enterprise Operations (Air Force - Enlisted)
Cyber Defense Operations Journeyman, Expeditionary Communications (Air Force - Enlisted)
Cyber Defense Operations Journeyman, Mission Defense Activities (Air Force - Enlisted)
Cyber Defense Operations Manager (Air Force - Enlisted)
Cyber Defense Operations Superintendent (Air Force - Enlisted)
Cyber RandD Specialist (Navy - Enlisted)
Data Base Management Officer (Navy - Commissioned or Warrant Officer)
Data Systems Chief (Marine Corps - Enlisted)
Health Services Systems Management (Army - Commissioned Officer only)
Intelligence Technology and Data Chief (Marine Corps - Enlisted)
Technical Information Operations Officer (Marine Corps - Commissioned Officer only)

Apprenticeship Crosswalk Titles

No information available.

DOT Crosswalk Titles

No information available.