Expand mobile version menu

Data Warehousing Specialist  What They Do

Just the Facts

Designs, models, or implements corporate data warehousing activities. Programs and configures warehouses of database information and provides support to warehouse users.

This career is part of the Information Technology cluster Network Systems pathway.

A person in this career:

  • Designs, implements, or operates comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
  • Develops data warehouse process models, including sourcing, loading, transformation, and extraction.
  • Creates or implements metadata processes and frameworks.
  • Creates plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
  • Creates supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
  • Designs and implements warehouse database structures.
  • Develops and implements data extraction procedures from other systems, such as administration, billing, or claims.
  • Develops or maintains standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
  • Implements business rules via stored procedures, middleware, or other technologies.
  • Maps data between source systems, data warehouses, and data marts.

Working Conditions and Physical Demands

People who do this job report that:

  • You would sit most of the time. There's some walking and standing. You may have to lift and carry things like books, papers or tools weighing 10 lbs. or less.

Work Hours and Travel

  • Regular working hours and limited travel