Data Warehouse Engineer – ETL & Data Integration (Lisbon, Hybrid)

Decskill; Lisboa; Híbrido; EUR 55 000 - 85 000; Tempo integral

Resumo da oferta

Decskill, an IT consulting company, is seeking a Data Warehouse Engineer for a hybrid role in Lisbon, Portugal. The position involves designing and maintaining enterprise data warehouse solutions, building ETL pipelines, and ensuring data quality.

3 days at the office per week, with strong focus on data governance and AI-enabled improvements. The role requires 5+ years in DW architecture, SQL Server/SSIS/T-SQL expertise, and scripting with Python and PowerShell.

Qualificações

• Academic background in Engineering or similar.
• 5+ years of Data Warehouse architecture and automation experience.
• Proven skills with Microsoft SQL Server, SSIS, T-SQL.
• Experience designing and optimizing DWH using SQL Server, SSIS, SSRS, SSAS.
• Strong ETL design, optimization, and troubleshooting capabilities.
• Experience with multiple ERP systems and diverse databases.
• Proficiency in scripting and automation (Python, PowerShell).
• Awareness of AI trends and continuous learning in an AI-enabled environment.

Responsabilidades

• Design, develop, optimize, and maintain enterprise Data Warehouse solutions.
• Build, optimize, and troubleshoot ETL pipelines for reliable data integration.
• Improve performance, scalability, and maintainability of DWH solutions.
• Integrate heterogeneous data sources and modernize legacy systems.
• Ensure compliance with DWH 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

Data Warehouse

ETL pipelines

SQL Server

SSIS

T-SQL

Performance tuning

Automation

Python

PowerShell

AI awareness

Formação académica

Engineering degree

Ferramentas

SQL Server

SSIS

SSRS

SSAS

Oracle

MariaDB

PostgreSQL

Progress

SAP

Abacus

INFOR

Python

PowerShell

Descrição da oferta de emprego

Decskill, an IT consulting company, is seeking a Data Warehouse Engineer for a hybrid role in Lisbon, Portugal. The position involves designing and maintaining enterprise data warehouse solutions, building ETL pipelines, and ensuring data quality.

3 days at the office per week, with strong focus on data governance and AI-enabled improvements. The role requires 5+ years in DW architecture, SQL Server/SSIS/T-SQL expertise, and scripting with Python and PowerShell.