data warehouse designer
ISCO: 2521. Skills: 110. Essential: 28.
Essential skills
- 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
Supporting skills
- 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