From database designer to data warehouse designer
25 of the 28 essential skills of a data warehouse designer are already essential for a database designer — about 89% of the job, before you learn anything new. It is the closest move from database designer in the whole taxonomy.
These numbers compare two occupations, not you and a job. What you personally already cover depends on what you have actually done.
- 25
- skills carry over
- 3
- would be new
- 89%
- of the target job covered
- 28
- essential skills of a data warehouse designer
What a data warehouse designer does
Data warehouse designers are responsible for planning, connecting, designing, scheduling, and deploying data warehouse systems. They develop, monitor and maintain ETL processes, reporting applications and data warehouse design.
What carries over
25 skillsEssential in both jobs. This is the part of the move you have already made.
- analyse business requirements
- apply ICT systems theory
- assess ICT knowledge
- business process modelling
- create data sets
- create database diagrams
- create software design
- database
- database development tools
- database management systems
- define technical requirements
- design database scheme
- develop automated migration methods
- ICT security legislation
- information structure
- manage database
- manage standards for data exchange
- migrate existing data
- operate relational database management system
- query languages
- resource description framework query language
- systems theory
- use markup languages
- web programming
- write database documentation
What would be new
3 skillsEssential for a data warehouse designer and not for a database designer. Note that the taxonomy describes activities rather than tools, so some of these may be things you already do under a different name.
Other moves from database designer
2 roles- knowledge engineer13 skills in common
- ICT system architect11 skills in common
← database designerdata warehouse designer →The other way round
No account needed to start
How far are you from being a data warehouse designer?
MyNodes reads your CV once, maps it to this same taxonomy, and shows you which roles you are already closest to and the few skills that would open the most doors. The file is deleted as soon as it has been read.