Skip to content

← Occupation guides

15-1243.01 · Task explorer

Data Warehousing Specialists: reported tasks and exploration worksheet

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

Use the skill profile to plan your next practice →

Read the task inventory

This source lists 18 tasks, including 18 marked Core and 0 marked Supplemental. Labels and dates are retained below. Employers can combine or divide these responsibilities differently; explore the task itself before assuming it belongs in every version of the role.

Task source dates: 08/2018.

Find a task in this inventory

18 tasks shown

Core · Task 16132 · 08/2018 · Occupational Expert

Develop data warehouse process models, including sourcing, loading, transformation, and extraction.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16121 · 08/2018 · Occupational Expert

Verify the structure, accuracy, or quality of warehouse data.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16124 · 08/2018 · Occupational Expert

Map data between source systems, data warehouses, and data marts.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16126 · 08/2018 · Occupational Expert

Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16128 · 08/2018 · Occupational Expert

Design and implement warehouse database structures.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16127 · 08/2018 · Occupational Expert

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.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16118 · 08/2018 · Occupational Expert

Provide or coordinate troubleshooting support for data warehouses.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16120 · 08/2018 · Occupational Expert

Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16133 · 08/2018 · Occupational Expert

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.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16123 · 08/2018 · Occupational Expert

Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16129 · 08/2018 · Occupational Expert

Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16131 · 08/2018 · Occupational Expert

Create or implement metadata processes and frameworks.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16117 · 08/2018 · Occupational Expert

Review designs, codes, test plans, or documentation to ensure quality.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16130 · 08/2018 · Occupational Expert

Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16122 · 08/2018 · Occupational Expert

Select methods, techniques, or criteria for data warehousing evaluative procedures.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16125 · 08/2018 · Occupational Expert

Implement business rules via stored procedures, middleware, or other technologies.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16119 · 08/2018 · Occupational Expert

Prepare functional or technical documentation for data warehouses.

Add to my exploration shortlist

My example, evidence or question

Core · Task 16116 · 08/2018 · Occupational Expert

Test software systems or applications for software enhancements or new products.

Add to my exploration shortlist

My example, evidence or question

Make the shortlist useful

Choose one to three activities that tell you something different about the work. Avoid selecting several ways of describing the same interest.
For each, write an example you can discuss or a question that would change your understanding of the role.
Keep source task IDs with your notes so you can return to the same description. Do not include private employer or customer information.

The exported worksheet distinguishes the reported task from your own notes. It supports exploration, not a hiring decision or a validated assessment.

Keep your worksheet

Download before leaving this page. Unsaved writing remains only in the page and is cleared on refresh. Notes and learning actions are not sent to a server. This guide describes an occupation and supports study planning; it does not provide clinical, legal or equipment-operating procedures.

Source and practice material

Occupational context uses the O*NET® 31.0 Database from the U.S. Department of Labor, Employment and Training Administration, under CC BY 4.0. View the occupation.

Skill Workbench selected and adapted the occupational information and added its own fictional cases, calculations, guidance and worksheets. USDOL/ETA has not approved, endorsed or tested these additions. O*NET® is a trademark of USDOL/ETA.