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.

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
  • Amazon DynamoDB
  • MongoDB
Presentation software
  • Microsoft PowerPoint
Metadata management software
  • CA Erwin Data Modeler
  • SAS Data Integration Server

Education

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

Job Outlook

Bright Outlook
New job opportunities are very likely in the future.
Salary
$93,750
$51,800
$148,060

Explore More

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
  • Amazon DynamoDB
  • MongoDB
Presentation software
  • Microsoft PowerPoint
Metadata management software
  • CA Erwin Data Modeler
  • SAS Data Integration Server

EDUCATION

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

JOB OUTLOOK

Bright Outlook
New job opportunities are very likely in the future.
Salary
$93,750
$51,800
$148,060

EXPLORE MORE