Skip to main content

252105 - Data warehouse designer

Responsible for planning, connecting, designing and planning data warehouse systems. Develops, monitors, and maintains ETL processes, reporting, and data warehouse architecture.


Main activities

• retrieves, stores and checks information, uses database management systems based on the relational database model, according to which data is divided into tables of rows and columns, as in Oracle, Microsoft SQL Server and MySQL databases; 
• creates new or existing sets of related data that consist of separate elements but can be managed as a single unit; 
• prepares database project models and diagrams that make up the structure of the database, uses modeling software tools, and implements them in subsequent processes; 
• creates a logically organized group of objects, tables, columns and processes, prepares a database scheme project according to the rules of the relational database management system; 
• applies migration and conversion techniques to existing data so that the data can be transferred, changed in format, stored or in computer systems.

Characteristic competences

• manage the relational database management system;
• prepare data sets;
• create database diagrams;
• design database schemas;
• transfer existing data.

Versija: 2023
Pagrindinės grupės kodas: 2
Sub-major groups code: 25
Minor group code: 252
Unit group code: 2521