Expand mobile version menu

Data Warehousing Specialist

salary graphic

AVG. SALARY

$106,250

education graphic

EDUCATION

Bachelor's degree

job outlook graphic

JOB OUTLOOK

Stable

What They Do

Data Warehousing Specialists Career Video

About This Career

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 Information Support and Services pathway.

A person in this career:

  • Verifies the structure, accuracy, or quality of warehouse data.
  • Develops data warehouse process models, including sourcing, loading, transformation, and extraction.
  • Maps data between source systems, data warehouses, and data marts.
  • Develops and implements data extraction procedures from other systems, such as administration, billing, or claims.
  • Designs and implements warehouse database structures.
  • 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.
  • Writes new programs or modifies existing programs to meet customer requirements, using current programming languages and technologies.
  • Provides or coordinates troubleshooting support for data warehouses.
  • 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.
  • Performs system analysis, data analysis or programming, using a variety of computer languages and procedures.

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 in this occupation requires being inside most of the time
  • Work in this occupation involves sitting more than one-third of the time

Working in this career involves (physical activities):

  • Seeing clearly up close
  • Speaking clearly enough to be able to be understood by others
  • Identifying and understanding the speech of another person

Work Hours and Travel

  • Regular working hours and limited travel

Specialty and Similar Careers

Careers that are more detailed or close to this career:

  • Data Warehouse Analyst
  • Data Warehouse Solution Architect