Job catalog - Employment
Cataleg D ocupacions capçalera
Breadcrumb
Catalogue of occupations
Ocupacions
Data warehouse designer
Data warehouse architect Data warehouse designer Data warehouse developer
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.
Tasks
Tasks include -
(a) Designing and developing database architecture, data structures, tables, dictionaries and naming conventions for information systems projects;
(b) Designing, constructing, modifying, integrating, implementing and testing database management systems;
(c) Conducting research and providing advice on the selection, application and implementation of database management tools;
(d) Developing and implementing data administration policy, documentation, standards and models;
(e) Developing policies and procedures for database access and usage and for the backup and recovery of data;
(f) Performing the operational establishment and preventive maintenance of backups, recovery procedures, and enforcing security and integrity controls.
Knowledge
- Software and applications development and analysis
- Database and network design and administration
- Management and administration
- Computer use
- Law
Digital competencies
- Managing information
- Developing operational policies and procedures
- Developing professional relationships or networks
- Analysing business operations
- Presenting research or technical information
Digital competencies
- Managing, gathering and storing digital data
- Designing ict systems or applications
- Programming computer systems
- Using digital tools for collaboration and productivity
- Setting up computer systems
Personal competencies
- Processing information, ideas and concepts
Professional groups of the occupation
Professionals
Information and communications technology professionals
Database and network professionals
Database designers and administrators
Other occupations of the professional group
Do you want to know what the hiring rate for this occupation is in the market?
Contracts and job seekers in the last year in Barcelonès
Database designers and administrators
232
Number of contracts in Barcelonès
65,72%
Percentage of contracts in Catalonia
-3,73% Interannual variation of contracts in Barcelonès
90,52%
Permanent contracts over total contracts in Barcelonès
8,19%
Part-time contracts
1,02% Turnover index
425
Average of job seekers in Barcelonès
41%
Interannual variation of job seekers in Barcelonès
Data source: Observatori del Treball i Model Productiu, Government of Catalonia
The market for this profile is hiring
Contracts in u00e8 over the past year by sex and age
Contracts by gender in Barcelonès.
Information and communications technology professionals
70%
30%
Data source: Observatori del Treball i Model Productiu, Government of Catalonia
Contracts by age groups.
Information and communications technology professionals
Data source: Observatori del Treball i Model Productiu, Government of Catalonia
What vacancies are published in the professional family?
Vacancies published by professional family and type of contract in Barcelonès over the past year
Database and network professionals
| Occupation | Vacancies | Permanent contracts |
|---|
Data source: Data generated from the analysis of Lightcast data and the Observatory of Work and Productive Model of the Government of Catalonia.
What experience is required for the vacancies? Which sectors are looking for this occupation?
Database designers and administrators
Data source: Own elaboration based on the data of vacancies extracted by Lightcast.
The vacancies published are for working in:
Job vacancies posted by county
Data source: Own elaboration based on the data of vacancies extracted by Lightcast.
Occupations that share knowledge and skills
This service uses the ESCO classification of the European Commission.
