ISCO Occupation Group 2521.5 Data Warehouse Designer
From Open Risk Manual
Definition
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.
Essential Skills
- Manage Database
- Database Management Systems
- Web Programming
- Define Technical Requirements
- Business Process Modelling
- Create Software Design
- Assess Ict Knowledge
- Database Development Tools
- Migrate Existing Data
- Use Markup Languages
- Resource Description Framework Query Language
- Ict Security Legislation
- Apply Ict Systems Theory
- Data Warehouse
- Write Database Documentation
- Query Languages
- Develop Automated Migration Methods
- Manage Standards For Data Exchange
- Create Database Diagrams
- Database
- Analyse Business Requirements
- Operate Relational Database Management System
- Systems Theory
- Create Data Sets
- Information Structure
- Design Database Scheme
Optional Skills
- Sparql
- Coffeescript
- Javascript
- Cobol
- Java (Computer Programming)
- Haskell
- Sql Server
- Lean Project Management
- Perl
- Respond To Customers' Inquiries
- Assembly (Computer Programming)
- R
- Objective-C
- Perform Data Analysis
- Apply Technical Communication Skills
- Prolog (Computer Programming)
- Xquery
- Use Access Control Software
- Linq
- Asp.Net
- Abap
- Smalltalk (Computer Programming)
- Scratch (Computer Programming)
- Process-Based Management
- Common Lisp
- Groovy
- Mysql
- N1Ql
- Php
- Ml (Computer Programming)
- Computer Programming
- C#
- Product Data Management
- Lisp
- Ca Datacom/Db
- Db2
- Postgresql
- Microsoft Visual C++
- Filemaker (Database Management Systems)
- Oracle Relational Database
- Develop Reporting Software
- Data Models
- Mdx
- Define Database Physical Structure
- Ibm Informix
- Openedge Advanced Business Language
- Scala
- Vbscript
- Openedge Database
- Agile Project Management
- Apl
- Ruby (Computer Programming)
- Erlang
- Build Business Relationships
- Microsoft Access
- Ajax
- Sas Language
- Perform Resource Planning
- Typescript
- Teradata Database
- Sap R3
- Python (Computer Programming)
- C++
- Pascal (Computer Programming)
- Ict Project Management Methodologies
- Matlab
- Objectstore
- Design User Interface
- Design Database Backup Specifications
- Unstructured Data
- Swift (Computer Programming)
- Visual Studio .Net
- Ldap
Alternative Names
- Data Warehouse Architect
- Data Warehouse Developer