Data Warehousing Specialists

Also Called: Data Warehouse Analyst, Data Warehouse Solution Architect

What Data Warehousing Specialists do

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

  • Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
  • Verify the structure, accuracy, or quality of warehouse data.
  • Map data between source systems, data warehouses, and data marts.
Industry Areas:

Information Technology

Expand For Additional Details

Work Context

  • Electronic Mail
  • Spend Time Sitting
  • Indoors, Environmentally Controlled
  • Face-to-Face Discussions
  • Importance of Being Exact or Accurate

Tools

  • Computer servers
  • High end computer servers
  • Notebook computers
  • Special purpose telephones
  • Mainframe computers

Technology

Data base management system software
Amazon DynamoDB
MongoDB
Presentation software
Microsoft PowerPoint
Metadata management software
CA Erwin Data Modeler
SAS Data Integration Server

The Education & Training You Need

Skills

  • Critical Thinking
  • Reading Comprehension
  • Programming
  • Complex Problem Solving
  • Active Listening

Knowledge

Engineering and Technology
computers and electronics
design
Math and Science
arithmetic, algebra, geometry, calculus, or statistics
Arts and Humanities
English language

Education

  • 78% Bachelor's degree
  • 4% High school diploma or equivalent
  • 4% Post-secondary certificate

Experience

A considerable amount of work-related skill, knowledge, or experience is needed for these occupations. For example, an accountant must complete four years of college and work for several years in accounting to be considered qualified.

What are your training options on the pathway to this occupation?

Are You a Good Fit?

Occupation Traits

  • Conventional (Organizer)
  • Investigative (Thinker)

Work Styles

  • Analytical Thinking
  • Attention to Detail
  • Initiative
  • Persistence
  • Cooperation
  • Dependability

Values

  • Achievement
  • Working Conditions
  • Independence

Abilities

  • Verbal
  • Ideas and Logic
  • Math

This is what Data Warehousing Specialists across the country typically make.

$36.54 / hour
$76,000 /year

Entry Level

$64.76 / hour
$134,700 /year

Median Level

$93.73 / hour
$194,960 /year

Experienced Level

Income information reflects a regional average.
Income information reflects a national average.

This career’s National Job Outlook is

Bright

Please be sure to verify the outlook of this occupation with your instructor.

Search Jobs