Profession 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.

Personality Type

• Investigative / Conventional

Knowledge

• 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.

• Information structure

  The type of infrastructure which defines the format of data: semi-structured, unstructured and structured.

• 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.

• Database management systems

  The tools for creating, updating and managing databases, such as Oracle, MySQL and Microsoft SQL Server.

• 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.

• Data warehouse

  The data storage system that analyses and reports on data such as a data mart.

• 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.

• Query languages

  The field of standardised computer languages for retrieval of information from a database and of documents containing the needed information.

• Database

  The classification of databases, that includes their purpose, characteristics, terminology, models and use such as XML databases, document-oriented databases and full text databases.

• Business 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.

• 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).

Skills

• Manage standards for data exchange

  Set and maintain standards for transforming data from source schemas into the necessary data structure of a result schema.

• 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.

• 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.

• Assess ICT knowledge

  Evaluate the implicit mastery of skilled experts in an ICT system to make it explicit for further analysis and usage.

• 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.

• 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.

• Apply 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

• 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.

• Manage database

  Apply database design schemes and models, define data dependencies, use query languages and database management systems (DBMS) to develop and manage databases.

• 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 (Oracle Corporation).

• Write database documentation

  Develop documentation containing information about the database that is relevant to end users.

• 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.

• Analyse 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 software design

  Transpose a series of requirements into a clear and organised software design.

• Migrate existing data

  Apply migration and conversion methods for existing data, in order to transfer or convert data between formats, storage or computer systems.

Optional knowledge and skills

Source: Sisyphus ODB