Career Details for Data Warehousing Specialists

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.

lightbulb KNOWLEDGE

Engineering and Technology

  • computers and electronics
  • design

Math and Science

  • arithmetic, algebra, geometry, calculus, or statistics

Arts and Humanities

  • English language

pencil 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

trophy 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

user PERSONALITY

People interested in this work like activities that include ideas, thinking, and figuring things out.

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

computer TECHNOLOGY

You might use software like this on the job:

Data base management system software

  • Apache Hadoop
  • Oracle PL/SQL

Metadata management software

  • CA Erwin Data Modeler
  • Oracle Warehouse Builder

Operating system software

  • Hewlett Packard HP-UX
  • Linux

book EDUCATION

1 cap out of 52 cap out of 53 cap out of 54 cap out of 5 blank cap


bachelor's degree usually needed

suitcase JOB OUTLOOK

outlook
AVERAGE

New job opportunities are likely in the future.

SALARY
$88,510


per year, on average

world EXPLORE MORE


You might like a career in one of these industries:

See more details at O*NET OnLine about Data Warehousing Specialists
O*NET in-it