As a Data Warehouse Designer, you will need to master following:

• ICT security legislation
• apply ICT systems theory
• assess ICT knowledge
• business process modelling
• create database diagrams
• create software design
• data warehouse
• database development tools
• database management systems
• design database scheme
• develop automated migration methods
• information structure
• 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

More generally, a data warehouse designer is also versed in:

• analyse business requirements
• create data sets
• database
• define technical requirements
• identify software for warehouse management
• manage database
• use databases

It also helps to know the following:

• ABAP
• AJAX
• APL
• ASP.NET
• Agile project management
• Assembly (computer programming)
• C#
• C++
• CA Datacom/DB
• COBOL
• CoffeeScript
• Common Lisp
• DB2
• Erlang
• Filemaker (database management systems)
• Groovy
• Haskell
• IBM Informix
• ICT project management methodologies
• Java (computer programming)
• JavaScript
• LDAP
• LINQ
• Lean project management
• Lisp
• MATLAB
• MDX
• ML (computer programming)
• Microsoft Access
• Microsoft Visual C++
• MySQL
• N1QL
• ObjectStore
• Objective-C
• OpenEdge Advanced Business Language
• OpenEdge Database
• Oracle Relational Database
• PHP
• Pascal (computer programming)
• Perl
• PostgreSQL
• Process-based management
• Prolog (computer programming)
• Python (computer programming)
• R
• Ruby (computer programming)
• SAP R3
• SAS language
• SPARQL
• SQL Server
• Scala
• Scratch (computer programming)
• Smalltalk (computer programming)
• Swift (computer programming)
• Teradata Database
• TypeScript
• VBScript
• Visual Studio .NET
• XQuery
• data models
• define database physical structure
• design database backup specifications
• design database in the cloud
• design user interface
• develop reporting software
• manage cloud data and storage
• unstructured data
• use access control software
• use query languages
• apply technical communication skills
• build business relationships
• computer programming
• perform data analysis
• perform resource planning
• product data management
• respond to customers' inquiries
• store digital data and systems
• use back-up and recovery tools