data warehouse
The data storage system that analyses and reports on data such as a data mart.
digital
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.
Competences and skills
110 ESCO relationsEssential knowledge 11 competences
Occupation specific
1 competenceSector-specific
9 competencesbusiness process modelling
The tools, methods and notations such as Business Process Model and Notation (BPMN) and Business Process Execution Language (BPEL), used to describe and analyse the characteristics of a business process and model its further development.
database development tools
The methodologies and tools used for creating logical and physical structure of databases, such as logical data structures, diagrams, modelling methodologies and entity-relationships.
digital
database management systems
The tools for creating, updating and managing databases, such as Oracle, MySQL and Microsoft SQL Server.
digital
ICT security legislation
The set of legislative rules that safeguards information technology, ICT networks and computer systems and legal consequences which result from their misuse. Regulated measures include firewalls, intrusion detection, anti-virus software and encryption.
digital
information structure
The type of infrastructure which defines the format of data: semi-structured, unstructured and structured.
digital
query languages
The field of standardised computer languages for retrieval of information from a database and of documents containing the needed information.
digital
resource description framework query language
The query languages such as SPARQL which are used to retrieve and manipulate data stored in Resource Description Framework format (RDF).
digital
systems theory
The principles that can be applied to all types of systems at all hierarchical levels, which describe the system's internal organisation, its mechanisms of maintaining identity and stability and achieving adaptation and self-regulation and its dependencies and interaction with the environment.
digital
web programming
The programming paradigm that is based on combining markup (which adds context and structure to text) and other web programming code, such as AJAX, javascript and PHP, in order to carry out appropriate actions and visualise the content.
digital
Cross-sector
1 competencedatabase
The classification of databases, that includes their purpose, characteristics, terminology, models and use such as XML databases, document-oriented databases and full text databases.
digital
Essential skills and competences 17 competences
Occupation specific
0 competencesNo competences in this bucket.
Sector-specific
11 competencesapply ICT systems theory
Implement principles of ICT systems theory in order to explain and document system characteristics that can be applied universally to other systems
digital
assess ICT knowledge
Evaluate the implicit mastery of skilled experts in an ICT system to make it explicit for further analysis and usage.
digital
create database diagrams
Develop the database design models and diagrams which establish the structure of a database by using modelling software tools to be implemented in further processes.
digital
create software design
Transpose a series of requirements into a clear and organised software design.
digital
design database scheme
Draft a database scheme by following the Relational Database Management System (RDBMS) rules in order to create a logically arranged group of objects such as tables, columns and processes.
digital
develop automated migration methods
Create automated transfer of ICT information between storage types, formats and systems to save human resources from performing the task manually.
digital
manage standards for data exchange
Set and maintain standards for transforming data from source schemas into the necessary data structure of a result schema.
digital
migrate existing data
Apply migration and conversion methods for existing data, in order to transfer or convert data between formats, storage or computer systems.
digital
operate relational database management system
Extract, store and verify information using database management systems based on the relational database model, which arranges data into tables of rows and columns, such as Oracle Database, Microsoft SQL Server and MySQL.
digital
- Scope note
- This activity excludes programming activities, changing structure of database or designing databases.
use markup languages
Utilise computer languages that are syntactically distinguishable from the text, to add annotations to a document, specify layout and process types of documents such as HTML.
digital
write database documentation
Develop documentation containing information about the database that is relevant to end users.
Cross-sector
6 competencesanalyse business requirements
Study clients' needs and expectations for a product or service in order to identify and resolve inconsistencies and possible disagreements of involved stakeholders.
create data sets
Generate a collection of new or existing related data sets that are made up out of separate elements but can be manipulated as one unit.
digital
define technical requirements
Specify technical properties of goods, materials, methods, processes, services, systems, software and functionalities by identifying and responding to the particular needs that are to be satisfied according to customer requirements.
identify software for warehouse management
Identify relevant software and applications used for warehouse management systems, their characteristics and value added to warehouse management operations.
digital
manage database
Apply database design schemes and models, define data dependencies, use query languages and database management systems (DBMS) to develop and manage databases.
digital
use databases
Use software tools for managing and organising data in a structured environment which consists of attributes, tables and relationships in order to query and modify the stored data.
digital
Optional knowledge 67 competences
Occupation specific
0 competencesNo competences in this bucket.
Sector-specific
63 competencesABAP
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in ABAP.
digital
Agile project management
The agile project management approach is a methodology for planning, managing and overseeing of ICT resources in order to meet specific goals and using project management ICT tools.
digital
AJAX
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in AJAX.
digital
APL
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in APL.
digital
ASP.NET
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in ASP.NET.
digital
Assembly (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Assembly.
digital
C#
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in C#.
digital
C++
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in C++.
digital
CA Datacom/DB
The computer program CA Datacom/DB is a tool for creating, updating and managing databases, currently developed by the software company CA Technologies.
digital
COBOL
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in COBOL.
digital
CoffeeScript
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in CoffeeScript.
digital
Common Lisp
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Common Lisp.
digital
data models
The techniques and existing systems used for structuring data elements and showing relationships between them, as well as methods for interpreting the data structures and relationships.
digital
DB2
The computer program IBM DB2 is a tool for creating, updating and managing databases, developed by the software company IBM.
digital
Erlang
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Erlang.
digital
Filemaker (database management systems)
The computer program FileMaker is a tool for creating, updating and managing databases, developed by the software company FileMaker Inc.
digital
Groovy
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Groovy.
digital
Haskell
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Haskell.
digital
IBM Informix
The computer program IBM Informix is a tool for creating, updating and managing databases, developed by the software company IBM.
digital
ICT project management methodologies
The methodologies or models for planning, managing and overseeing of ICT resources in order to meet specific goals, such methodologies are Waterfall, Incremental, V-Model, Scrum or Agile and using project management ICT tools.
digital
Java (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Java.
digital
JavaScript
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in JavaScript.
digital
LDAP
The computer language LDAP is a query language for retrieval of information from a database and of documents containing the needed information.
digital
lean project management
The lean project management approach is a methodology for planning, managing and overseeing of ICT resources in order to meet specific goals and using project management ICT tools.
digital
LINQ
The computer language LINQ is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the software company Microsoft.
digital
Lisp
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Lisp.
digital
MarkLogic
The NoSQL enterprise non-relational database used for creating, updating and managing large amounts of unstructured data stored in the cloud and which provides features such as semantics, flexible data models and Hadoop integration.
digital
MATLAB
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in MATLAB.
digital
MDX
The computer language MDX is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the software company Microsoft.
digital
Microsoft Access
The computer program Access is a tool for creating, updating and managing databases, developed by the software company Microsoft.
digital
Microsoft Visual C++
The computer program Visual C++ is a suite of software development tools for writing programs, such as compiler, debugger, code editor, code highlights, packaged in a unified user interface. It is developed by the software company Microsoft.
digital
ML (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in ML.
digital
MySQL
The computer program MySQL is a tool for creating, updating and managing databases, currently developed by the software company Oracle.
digital
N1QL
The computer language N1QL is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the software company Couchbase.
digital
Objective-C
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Objective-C.
digital
ObjectStore
The computer program ObjectStore is a tool for creating, updating and managing databases, developed by the software company Object Design, Incorporated.
digital
OpenEdge Advanced Business Language
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in OpenEdge Advanced Business Language.
digital
OpenEdge Database
The computer program OpenEdge Database is a tool for creating, updating and managing databases, developed by the software company Progress Software Corporation.
digital
Oracle Relational Database
The computer program Oracle Rdb is a tool for creating, updating and managing databases, developed by the software company Oracle.
digital
Pascal (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Pascal.
digital
Perl
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Perl.
digital
PHP
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in PHP.
digital
PostgreSQL
The computer program PostgreSQL is a free and open-source software tool for creating, updating and managing databases, developed by the PostgreSQL Global Development Group.
digital
Process-based management
The process-based management approach is a methodology for planning, managing and overseeing of ICT resources in order to meet specific goals and using project management ICT tools.
digital
Prolog (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Prolog.
digital
Python (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Python.
digital
R
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in R.
digital
Ruby (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Ruby.
digital
SAP R3
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in SAP R3.
digital
SAS language
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in SAS language.
digital
Scala
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Scala.
digital
Scratch (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Scratch.
digital
Smalltalk (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Smalltalk.
digital
SPARQL
The computer language SPARQL is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the international standards organisation World Wide Web Consortium.
digital
SQL Server
The computer program SQL Server is a tool for creating, updating and managing databases, developed by the software company Microsoft.
digital
Swift (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Swift.
digital
Teradata Database
The computer program Teradata Database is a tool for creating, updating and managing databases, developed by the software company Teradata Corporation.
digital
TripleStore
The RDF store or TripleStore is a database used for storage and retrieval of Resource Description Framework triples (subject-predicate-object data entities) which can be accessed by semantic queries.
digital
TypeScript
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in TypeScript.
digital
unstructured data
The information that is not arranged in a pre-defined manner or does not have a pre-defined data model and is difficult to understand and find patterns in without using techniques such as data mining.
digital
VBScript
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in VBScript.
digital
Visual Basic
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Visual Basic.
digital
XQuery
The computer language XQuery is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the international standards organisation World Wide Web Consortium.
digital
Cross-sector
4 competencescomputer programming
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms (e.g. object oriented programming, functional programming) and of programming languages.
digCompdigital
data science
The field of study that deals with big amount of data using AI techniques such as machine learning algorithms to predict patterns and obtain useful information to make business decisions
digital
data visualisation software
A computer tool or application that creates a graphical and visual representation of data, allowing a better understanding and interpretation of complex data through visual elements such as maps, charts, infographics or graphs.
digital
product data management
The use of software to track all information concerning a product such as technical specifications, drawings, design specifications, and production costs.
digital
Optional skills and competences 15 competences
Occupation specific
1 competencedevelop reporting software
Create reporting software and applications used for creating reports on data.
digital
Sector-specific
7 competencesdefine database physical structure
Specify the physical configuration of database files on a given media. This consists of in-detail specifications of indexing options, data types and data elements placed in the data dictionary.
digital
design database backup specifications
Specify procedures to be performed on databases which ensure the copying and archiving of data for possible restoration in case of a data loss event.
digital
design database in the cloud
Apply design principles for an adaptive, elastic, automated, loosely coupled databases making use of cloud infrastructure. Aim to remove any single point of failure through distributed database design.
digital
design user interface
Create software or device components which enable interaction between humans and systems or machines, using appropriate techniques, languages and tools so as to streamline interaction while using the system or machine.
digital
manage cloud data and storage
Create and manage cloud data retention. Identify and implement data protection, encryption, and capacity planning needs.
digital
use access control software
Utilise software to define the roles and manage user authentication, privileges and access rights to ICT systems, data and services.
digital
- Scope note
- It includes programs such as Avaya Identity Engines or iLock.
use query languages
Retrieve information from a database or information system using computer languages designed for the retrieval of data.
digital
Cross-sector
7 competencesapply technical communication skills
Explain technical details to non-technical customers, stakeholders, or any other interested parties in a clear and concise manner.
build business relationships
Establish a positive, long-term relationship between organisations and interested third parties such as suppliers, distributors, shareholders and other stakeholders in order to inform them of the organisation and its objectives.
perform data analysis
Collect data and statistics to test and evaluate in order to generate assertions and pattern predictions, with the aim of discovering useful information in a decision-making process.
digital
perform resource planning
Estimate the expected input in terms of time, human and financial resources necessary to achieve the project objectives.
respond to customers' inquiries
Answer customers' questions about itineraries, rates and reservations in person, by mail, by e-mail and on the phone.
store digital data and systems
Use software tools to archive data by copying and backing them up, in order to ensure their integrity and to prevent data loss.
digital
use back-up and recovery tools
Use tools which allow users to copy and archive computer software, configurations and data and recover them in case of loss.
digital