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.
Engineering and Technology
Math and Science
Arts and Humanities
|
Basic Skills
Problem Solving
People and Technology Systems
|
Verbal
Ideas and Logic
Math
|
People interested in this work like activities that include ideas, thinking, and figuring things out.
They do well at jobs that need:
|
You might use software like this on the job: Data base management system software
Presentation software
Metadata management software
|
![]()
|
![]() New job opportunities are very likely in the future.
![]() $93,750
![]() $51,800
$148,060
|
|
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

- bachelor's degree
JOB OUTLOOK

New job opportunities are very likely in the future.

$93,750

$51,800
$148,060