Data Warehousing Specialists
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 data, detail, and regular routines.
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
- Oracle PL/SQL
Presentation software
- Microsoft PowerPoint
Metadata management software
- Informatica software
- Quest Erwin Data Modeler
Education
Education: (rated 4 of 5)
bachelor's degree
usually needed
usually needed
Job Outlook
Bright
New job opportunities are very likely in the future.
Explore More
- Computer Systems Analysts
- Computer Systems Engineers/Architects
- Database Administrators
- Database Architects
- Software Developers
You might like a career in one of these industries:
See more details at O*NET OnLine about data warehousing specialists.