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.

Alternative Labels

data warehouse architect

data warehouse developer

Regulatory Aspect

To see if and how this occupation is regulated in EU Member States, EEA countries or Switzerland please consult the Regulated Professions Database of the Commission. Regulated Professions Database:

http://ec.europa.eu/growth/single-market/services/free-movement-professionals/qualifications-recognition_en

Skills & Competences

Essential Skills and Competences

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

Essential Knowledge

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

Optional Skills and Competences

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

Optional Knowledge

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 computer programming data models product data management unstructured data

Concept URI

Concept Uri

http://data.europa.eu/esco/occupation/1562c7a3-c7d9-419d-b9b6-db26610bcf84

Status

released

Occupations