Data Warehouse Engineer

Decskill; Coimbra; Hybride; EUR 55 000 - 75 000; Plein temps

Résumé du poste

Decskill is seeking a Data Warehouse Engineer for a hybrid role based in Coimbra, Portugal. You will design, develop, and optimize enterprise data warehouse solutions, building robust ETL pipelines and ensuring data quality across heterogeneous sources.

You will work with SQL Server, SSIS/SSRS/SSAS, Python, and PowerShell, collaborating with ERP integrations (SAP, Abacus, INFOR) and exploring AI opportunities to enhance products and processes in an AI-enabled environment.

Qualifications

• 5+ years of experience in Data Warehouse architecture and automation.
• Expertise with Microsoft SQL Server, SSIS, T-SQL.
• Design, development, optimization of DWH using MS SQL Server, SSIS, SSRS, SSAS, and T-SQL.
• ETL pipeline design, optimization, and troubleshooting.
• Performance tuning, scalability, and maintainability of DWH.
• Experience with ERP systems (SAP, Abacus, INFOR) and databases (SQL Server, Oracle, MariaDB, PostgreSQL, Progress).
• Python for data workflows and PowerShell for deployment/monitoring.
• Data governance and DWH standards compliance.
• AI trends awareness including Agentic AI to enhance products, processes, and ways of working.
• Continuous learning mindset toward emerging technologies in AI-enabled environment.

Responsabilités

• 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 for data quality.
• Explore AI technologies to enhance products, processes, and ways of working.

Connaissances

DWH architecture

SQL Server

SSIS

T-SQL

ETL design

Python

PowerShell

Data governance

AI awareness

Data validation

Formation

Engineering degree

Outils

Microsoft SQL Server

SSIS

SSRS

SSAS

SAP

Abacus

INFOR

Oracle

MariaDB

PostgreSQL

Progress

Description du poste

We are growing. And we are looking for talented people.

At Decskill, we believe that technological excellence is driven by human talent.

We are an IT consulting company with more than 10 years of consolidated experience in the market, focused on building long-term relationships with both our clients and our people. Today, we are a community of over 800 professionals, working from Lisbon, Porto, and Madrid, contributing to impactful technology initiatives.

As part of the Astek Group, we combine a strong local culture with a global presence, being active in around 23 countries across 4 continents. This allows us to offer an international context, diverse challenges, and long-term career opportunities, while staying close to our teams.

We would like to meet a Data Warehouse Engineer for a project with a hybrid working model in Coimbra, Portugal (3x/week at the office). All candidates must be in Portugal.

Responsabilities:

• 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.

Requirements:

• Academic background in Engineering or similar (Software, Electronics, Physics, Mathematics, etc.).
• At least 5+ years of relevant professional experience in Data Warehouse architecture and automation (Microsoft SQL Server, SSIS, T-SQL).
• Proven skills in Data Warehouse (DWH) design, development, and optimization using Microsoft 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 multiple ERP systems (SAP, Abacus, INFOR) and diverse databases (SQL Server, Oracle, MariaDB, PostgreSQL, Progress).
• Strong skills in scripting and automation (Python for data workflows, PowerShell for deployment and monitoring).
• Validate compliance with DWH standards, data governance, and architectural best practices.
• Expertise in integration of heterogeneous data sources and legacy system modernization.
• Experience in deployment automation and environment configuration (development, test, and production).
• Focus on data validation, anomaly detection, and error handling.
• Demonstrates awareness of AI trends (including Agentic AI) and explores opportunities to enhance products, processes, and ways of working.
• Shows a continuous learning mindset toward emerging technologies and an openness to experiment, adapt, and continuously upskill in an AI-enabled environment

Are you looking for an environment that values curiosity and commitment? Here, your contribution has real impact and individual growth is taken seriously.

Find with us the right opportunity to grow!

What you can expect from us:

• Long-term projects with national and international context
• Opportunities to grow technically and professionally
• A people-first culture, focused on transparency and trust
• Teams that value ownership, collaboration and stability

Your next challenge might start here.

At Decskill, we are committed to equal opportunities and non-discrimination. We promote a culture of diversity and inclusion, where recruitment and career progression are based solely on talent, regardless of age, gender, ethnicity, race, nationality, or any other form of discrimination incompatible with human dignity.