Data Warehouse Engineer

Stadler Digital Labs; Coimbra; Presencial; EUR 48 000 - 64 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Fringe Benefits

Performance-based rewards

Training & development

Resumo da oferta

Stadler Digital Labs in Coimbra, Portugal is seeking a seasoned Data Warehouse Architect / Engineer to lead design, development and optimization of enterprise data warehouses using Microsoft SQL Server, SSIS, SSRS, SSAS and T-SQL. You will integrate ERP systems (SAP, Abacus, INFOR) and diverse databases, automate ETL pipelines, ensure governance, and drive scalable, maintainable solutions.

Collaboration with developers, documentation, and staying ahead of AI trends to enhance products is

Qualificações

• Academic background in Engineering or similar.
• 5+ years of data warehouse architecture and automation experience.
• Proven skills in DWH design, development, and optimization using Microsoft SQL Server, SSIS, SSRS, SSAS and T-SQL.

Conhecimentos

Data warehousing design

ETL design

Python scripting

Automation

Documentation

AI awareness

Formação académica

Engineering degree or equivalent

Ferramentas

SQL Server

SSIS

SSRS

SSAS

T-SQL

PowerShell

Python

Oracle

MariaDB

PostgreSQL

SAP

INFOR

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.