Data Warehouse Engineer

Stadler Digital Labs; Lisboa; Presencial; EUR 55 000 - 90 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Fringe benefits

Training and growth opportunities

Resumo da oferta

Stadler Digital Labs, the digital competence center for Stadler Group, seeks an experienced Data Warehouse Engineer in Lisbon, Portugal. You will design, develop, and optimize data warehouses and ETL pipelines using MS SQL Server, SSIS/SSRS/SSAS, and T‑SQL, collaborating with ERP systems and diverse databases.

You will drive data governance, deployment automation, and documentation, sharing knowledge across teams while staying curious about AI-enabled enhancements to data workflows.

Qualificações

• Academic background in Engineering or similar.
• 5+ years of relevant professional experience in data warehouse architecture and automation.

Responsabilidades

• Design, develop, and optimize data warehouse solutions.
• Build and optimize ETL pipelines.
• Ensure data quality, governance, and architecture alignment.
• Collaborate with ERP and database teams (SAP, Abacus, INFOR) for data integration.
• Deploy automation and configuration across development, test and production.
• Produce technical documentation and share knowledge across teams.

Conhecimentos

Data warehouse architecture

ETL design & optimization

Microsoft SQL Server

SSIS/SSRS/SSAS

T‑SQL

Python scripting

PowerShell scripting

Data governance

Automation & deployment

Technical documentation

Formação académica

Engineering or equivalent

Ferramentas

Microsoft SQL Server

SSIS

SSRS

SSAS

Oracle

MariaDB

PostgreSQL

Progress

Descrição da oferta de emprego

The future of rail isn’t just about movement, it’s about intelligence, security, and connection. We unite rail expertise with digital innovation to create smarter, safer, and more sustainable transportation solutions. Technology here speaks with purpose: accelerating digitalization, embedding cybersecurity, and shaping the next era of rail.

Behind every breakthrough are people, their talent, creativity, and drive to push boundaries. Together, we’re building confidence, resilience, and a new standard for connected mobility powered by innovation.

This position is for Stadler Digital Labs, a joint venture between Stadler Rail and Critical Software serving as the digital competence center for the Stadler Group.

Check-out the website: https://stadlerdigitallabs.com

Which brings us to you, the person with:

• 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 (e.g., 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 adapting legacy systems to more recent architectures.
• Experience in deployment automation and environments configuration (across development, test and production).
• Focus on data validation, anomaly detection, and error handling.
• Ability to produce technical documentation and foster knowledge sharing within and across teams.
• Able to collaborate with developers and review technical solutions for quality and consistency.
• Passionate and driven, curious and willing to share your knowledge, but also learn with others - regardless of their background, tenure or seniority.
• Demonstrates awareness of AI trends (including agentic AI), with curiosity and motivation to explore how they can enhance products, processes, or ways of working;
• Shows a learning mindset toward emerging technologies and an openness to experiment, adapt, and continuously upskill in an AI‑enabled environment.

What we provide:

• Work that fits your life, not the other way around
• Offices designed to make you feel like you belong
• A team that knows how to work hard, but also how to have fun
• Pay that makes you feel valued, plus performance-based rewards
• Fringe Benefits especially planned to support you and those who are important to you
• Your growth is our priority: training, support, and opportunities!

Join us and help us to improve the efficiency and sustainability of rail mobility.