Organisation/Company InstitutMetròpoli Research Field Engineering » Computer engineering Computer science Researcher Profile First Stage Researcher (R1) Positions Bachelor Positions Country Spain Application Deadline 8 Sep 2025 - 23:59 (Europe/Andorra) Type of Contract Temporary Job Status Full-time Hours Per Week 35 Offer Starting Date 1 Oct 2025 Is the job funded through the EU Research Framework Programme? NextGenerationEU Is the Job related to staff position within a Research Infrastructure? No
Offer Description
The Institut Metròpoli is seeking to hire a computer engineer to support the design and development of a secure data platform.
This position is linked to the PEOPLE project (Platform for Social Housing for Social Cohesion), funded by the Ministry for Digital Transformation and Public Service, within the framework of digitalization for the transformation of strategic productive sectors. The project involves the creation of demonstrators and use cases for Data Sharing Spaces, as part of the Recovery, Transformation and Resilience Plan – Next Generation EU (Sectoral Data Spaces Programme).
Mission
Design, deploy, and maintain a centralized PostgreSQL database on an Azure environment that integrates and structures the various types, formats, and data sources used by the Institut Metròpoli. The system must ensure data security, integrity, and access traceability, comply with the organization's governance principles, and optimize cloud resources.
Responsibilities
* Design a scalable, secure, and optimized PostgreSQL architecture on Azure to centralize multiple data sources and formats.
* Coordinate data integration and normalization processes using standardized ETL flows.
* Ensure a structure of predefined queries with access logging and traceability.
* Implement and audit security measures (encryption, identity controls, role-based permissions, or digital access contracts).
* Oversee the creation, administration, and maintenance of PostgreSQL databases on Azure, applying cost-efficiency principles (right-sizing, automated shutdowns, monitoring, and alerts).
* Ensure that technical documentation (viewer maintenance manual, architecture, data integrity procedures) is always updated and accessible.
* Report on the project status in terms of deadlines, budget, and quality, in accordance with the criteria of the Head of Service.
Tasks
* Full administration (configuration, scalability, security) of the PostgreSQL structure within the Microsoft Azure ecosystem.
* Develop and maintain a data viewer that enables controlled access to data, ensuring user efficiency and WCAG 2.1 accessibility.
* Configure read/write permissions, roles, and row-level security policies in PostgreSQL.
* Implement automated integrity checks, incremental loads, and data update processes.
* Draft the Viewer Maintenance Manual: backup/restore procedures, updates, penetration testing, and incident response.
* Monitor and optimize Azure resource usage (CPU, IOPS, storage, reserved costs), generating periodic cost tracking reports.
* Migrate or integrate new data sources following ETL best practices and Infrastructure as Code principles (Terraform, Bicep).
* Contribute to a DevSecOps culture: CI/CD, automated testing, code review, and coverage.
* Support the PEOPLE project management in all necessary aspects (data architecture).
Candidate Requirements and Evaluation Criteria
* Bachelor's degree in Computer Engineering, Data Engineering, or equivalent qualification.
* Proven experience in PostgreSQL administration and relational database design.
* Practical experience in IAM (Identity and Access Management), RBAC (Role-Based Access Control), and application security (OWASP, TLS encryption, secrets management).
* Proficiency in Git.
* Ability to write clear and maintainable technical documentation.
* Proficiency in Catalan, both spoken and written, equivalent to a C1 level certificate.
* Advanced technical English skills.
Languages CATALAN Level Excellent
Languages ENGLISH Level Good
Additional Information
Work Location(s)
Number of offers available 1 Company/Institute Institut Metròpoli Country Spain State/Province Catalonia City Bellaterra (Cerdanyola del Vallès) Postal Code 08193 Street Campus de Bellaterra Plaça del Coneixement, edifici MRA, p. 2
#J-18808-Ljbffr