Searching

Career Exploration

Data Warehousing Specialists

Also called: Data Warehouse Analyst, 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.
On the job, you'll need:

Engineering and Technology

  • computers and electronics
  • design

Math and Science

  • arithmetic, algebra, geometry, calculus, or statistics

Arts and Humanities

  • English language

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

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

Conventional

People interested in this work like activities that include data, detail, and regular routines.

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

Data base management system software

  • Amazon DynamoDB
  • Oracle PL/SQL

Presentation software

  • Microsoft PowerPoint

Metadata management software

  • Informatica software
  • Quest Erwin Data Modeler

Video courtesy of CareerOneStop.

Job Outlook

The job outlook for this position is Bright.

New job opportunities are very likely in the future. This career will grow rapidly in the next few years.

Median Annual Salary: $134,870

Education

Bachelor's degree is usually needed.