data warehouse designer
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.
Also called: data warehouse architect, data warehouse developer
- 28
- essential skills
- 82
- optional skills
- 8
- related roles
- 2521
- ISCO-08 group
Where you can go from here
8 rolesOccupations sharing the most essential skills with this one. The number is a count, not an opinion.
- database designerWhat changes?25 skills in common
- knowledge engineerWhat changes?13 skills in common
- ICT system architectWhat changes?10 skills in common
- database administrator9 skills in common
- artificial intelligence engineer7 skills in common
- big data archive librarian7 skills in common
- data quality specialist7 skills in common
- database developer6 skills in common
Essential skills
28- analyse business requirements
- apply ICT systems theory
- assess ICT knowledge
- business process modelling
- create data sets
- create database diagrams
- create software design
- data warehouse
- database
- database development tools
- database management systems
- define technical requirements
- design database scheme
- develop automated migration methods
- ICT security legislation
- identify software for warehouse management
- 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 databases
- use markup languages
- web programming
- write database documentation
Optional skills
82- ABAP
- Agile project management
- AJAX
- APL
- apply technical communication skills
- ASP.NET
- Assembly (computer programming)
- build business relationships
- C#
- C++
- CA Datacom/DB
- COBOL
- CoffeeScript
- Common Lisp
- computer programming
- data models
- data science
- data visualisation software
- DB2
- define database physical structure
- design database backup specifications
- design database in the cloud
- design user interface
- develop reporting software
- Erlang
- Filemaker (database management systems)
- Groovy
- Haskell
- IBM Informix
- ICT project management methodologies
- Java (computer programming)
- JavaScript
- LDAP
- lean project management
- LINQ
- Lisp
- manage cloud data and storage
- MarkLogic
- MATLAB
- MDX
- Microsoft Access
- Microsoft Visual C++
- ML (computer programming)
- MySQL
- N1QL
- Objective-C
- ObjectStore
- OpenEdge Advanced Business Language
- OpenEdge Database
- Oracle Relational Database
- Pascal (computer programming)
- perform data analysis
- perform resource planning
- Perl
- PHP
- PostgreSQL
- Process-based management
- product data management
- Prolog (computer programming)
- Python (computer programming)
- R
- respond to customers' inquiries
- Ruby (computer programming)
- SAP R3
- SAS language
- Scala
- Scratch (computer programming)
- Smalltalk (computer programming)
- SPARQL
- SQL Server
- store digital data and systems
- Swift (computer programming)
- Teradata Database
- TripleStore
- TypeScript
- unstructured data
- use access control software
- use back-up and recovery tools
- use query languages
- VBScript
- Visual Basic
- XQuery
Definition and skills from ESCO, published by the European Commission. Source concept
No account needed to start
How close are you to 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.