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
Managers
Administrative and commercial managers
Business services and administration managers
Policy and planning managers
Other occupations of the professional group
Do you want to know the demand for this occupation in the market?
Contracts and job seekers in the last year in Barcelonès
Policy and planning managers
221
Number of contracts in Barcelonès
65,97%
Percentage of contracts in Catalonia
-20,79% Interannual variation of contracts in Barcelonès
91,40%
Permanent contracts over total contracts in Barcelonès
8,14%
Part-time contracts
1,01% Turnover index
403
Average of job seekers in Barcelonès
48%
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.
Administrative and commercial managers
56%
44%
Data source: Observatori del Treball i Model Productiu, Government of Catalonia
Contracts by age groups.
Administrative and commercial managers
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
Business services and administration managers
| 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?
Policy and planning managers
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.
