Skip over navigation
mySkills myFuture Start Page

Occupation information for

Data Warehousing Specialists

Choose a Location

Within

Distance

description

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

Compare Skills 

details

Currently Employed: 740

Projected Annual Job Openings: 50

Typical Hourly Wage: $28.68 - $46.78

Typical Annual Salary: $59,600 - $97,300

See Job Listings (0)
Find Businesses

typical training

Typical education needed for entry: Bachelor's degree

Typical work experience needed for a job in this occupation: None

Typical on-the-job training once you have a job in this occupation: None

Find Training

typical job duties

  • Verify the structure, accuracy, or quality of warehouse data.
  • Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
  • Map data between source systems, data warehouses, and data marts.
  • Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
  • Design and implement warehouse database structures.
  • 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.
  • Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
  • Provide or coordinate troubleshooting support for data warehouses.
  • 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.
  • Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.

tools & technology


Tools:
  • Computer servers
  • Desktop computers
  • High end computer servers
  • Notebook computers
  • Special purpose telephones

Technology:
  • Data base management system software
  • Data base user interface and query software
  • Development environment software
  • Metadata management software
  • Operating system software