Skip navigation

Data Warehousing Specialists

Also called: Data Warehouse Analyst, Data Warehouse Manager, Data Warehouse Solution Architect

What they do:
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
On the job, you would:
  • 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.

Knowledge

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

Skills

Basic Skills
  • reading work related information
  • thinking about the pros and cons of different ways to solve a problem
Problem Solving
  • noticing a problem and figuring out the best way to solve it
People and Technology Systems
  • figuring out how a system should work and how changes in the future will affect it
  • thinking about the pros and cons of different options and picking the best one

Abilities

Verbal
  • read and understand what is written
  • listen and understand what people say
Ideas and Logic
  • order or arrange things
  • make general rules or come up with answers from lots of detailed information
Math
  • choose the right type of math to solve a problem
  • add, subtract, multiply, or divide

Personality

People interested in this work like activities that include ideas, thinking, and figuring things out.
They do well at jobs that need:
  • Analytical Thinking
  • Attention to Detail
  • Initiative
  • Persistence
  • Cooperation
  • Dependability

Technology

You might use software like this on the job:

Data base management system software
  • Apache Hadoop Hot Technology
  • Oracle PL/SQL Hot Technology
Metadata management software
  • CA Erwin Data Modeler Hot Technology
  • Oracle Warehouse Builder
Development environment software
  • C Hot Technology
  • Common business oriented language COBOL Hot Technology

Education

Education: (rated 4 of 5)
bachelor's degree
usually needed

Get started on your career:

Find Training Find Certifications Apprenticeship.gov

Job Outlook

Average Outlook
New job opportunities are likely in the future.
Salary
$88,510
$46,240
$139,390
Check out my state Local Salary Info Find Jobs

Explore More

You might like a career in one of these industries:
See more details at O*NET OnLine about data warehousing specialists.