Hybrid Data Warehouse Engineer – Lisbon

Decskill; Lisboa; Híbrido; EUR 45 000 - 70 000; Tempo integral

Resumo da oferta

Decskill seeks a Data Warehouse Engineer for a hybrid role based in Lisbon, Portugal (3 days/week in the office). You will design, build and optimize enterprise Data Warehouse solutions, implement ETL pipelines, and ensure data quality and governance across diverse data sources.

Ideal candidates have 5+ years in DWH architecture, strong SQL Server/SSIS/SSRS/SSAS skills, and experience with ERP systems and multiple databases.

Qualificações

• Academic background in Engineering or related field.
• 5+ years in Data Warehouse architecture and automation with MS SQL Server, SSIS, T-SQL.
• Proven skills in DWH design, development, and optimization using MS SQL Server, SSIS, SSRS, SSAS, and T-SQL.
• Deep knowledge of ETL pipeline design, optimization, and troubleshooting.
• Proven skills in performance tuning, scalability, and maintainability of DWH systems.
• Experience with ERP systems (SAP, Abacus, INFOR) and databases (SQL Server, Oracle, MariaDB, PostgreSQL, Progress).
• Strong scripting and automation skills (Python and PowerShell).
• Validate compliance with DWH standards, data governance, and best practices.
• Expertise in integrating heterogeneous data sources and legacy modernization.
• Experience with deployment automation and environment configuration.
• Focus on data validation, anomaly detection, and error handling; aware of AI trends including Agentic AI.

Responsabilidades

• Design, develop, optimize, and maintain enterprise Data Warehouse solutions.
• Build, optimize, and troubleshoot ETL pipelines to ensure reliable data integration.
• Improve performance, scalability, and maintainability of Data Warehouse solutions.
• Integrate heterogeneous data sources and modernize legacy systems.
• Ensure compliance with Data Warehouse standards, data governance, and architectural best practices.
• Automate deployments and manage environment configurations.
• Perform data validation, anomaly detection, and error handling to ensure data quality.
• Explore AI technologies to enhance products, processes, and ways of working.

Conhecimentos

DWH architecture

Data integration

ETL design

T-SQL

ETL troubleshooting

Performance tuning

Legacy modernization

Data governance

Python scripting

PowerShell

AI trends

ERP systems

SQL databases

Formação académica

Engineering or related field

Ferramentas

Microsoft SQL Server

SSIS

SSRS

SSAS

Oracle

MariaDB

PostgreSQL

Progress

Python

PowerShell

Descrição da oferta de emprego

Decskill seeks a Data Warehouse Engineer for a hybrid role based in Lisbon, Portugal (3 days/week in the office). You will design, build and optimize enterprise Data Warehouse solutions, implement ETL pipelines, and ensure data quality and governance across diverse data sources.

Ideal candidates have 5+ years in DWH architecture, strong SQL Server/SSIS/SSRS/SSAS skills, and experience with ERP systems and multiple databases.