§ OCCUPATION · GLOBAL STANDARDS

data warehouse designer

Data warehouse designers are responsible for planning, connecting, designing, scheduling, and deploying data warehouse systems.

View on Official Portal ↗

Description

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.

Theoretical Knowledge

ESSENTIALTheoretical knowledge required

query languages information structure business process modelling ICT security legislation data warehouse web programming database development tools database database management systems resource description framework query language systems theory

OPTIONALAdjacent knowledge that strengthens fit

Practical Skills

ESSENTIALApplied skills & competences

manage standards for data exchange assess ICT knowledge identify software for warehouse management manage database develop automated migration methods create data sets operate relational database management system use databases create database diagrams migrate existing data write database documentation analyse business requirements define technical requirements apply ICT systems theory use markup languages create software design design database scheme

OPTIONALOptional competences

use access control software store digital data and systems design database backup specifications design database in the cloud use back-up and recovery tools apply technical communication skills define database physical structure perform resource planning design user interface manage cloud data and storage perform data analysis use query languages respond to customers' inquiries build business relationships develop reporting software

Data Source: Unified Global Standards (ISCED, ISCO, O*NET, ESCO)