Data Warehouse Engineer

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 a new company that is part of the Critical Software group. Which Brings Us To You, The Person With Academic background in Engineering or similar (Software, Electronics, Physics, Mathematics, etc.). At least 3 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. Fluent in English. Passionate and driven, curious and willing to share your knowledge, but also learn with others - regardless of their background, tenure or seniority. 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 Your growth is our priority: training, support, and opportunities Plus, Perks With Purpose Private Health Insurance Because your health and peace of mind matters. Employee Assistance Programme Confidential support for you and your household from mental health to legal or financial advice, we're here for whatever life throws your way. Home Office Support Get what you need to work comfortably from home, without turning your living room into an ergonomic nightmare. Extra Holidays The longer you're with us, the more you get. Two extra days after your first year, and more as time goes on. Extra Parental Leave Two additional months of fully paid leave for both parents — whether you're welcoming a child by birth or adoption. Flex-time We don't clock-watch. Work when it makes sense for you, as long as it works for your team and goals. Gradual Return to Work Support Returning after a long break? We'll help you ease back in with a plan that fits your pace and needs. Away From Keyboard - Sabbatical programme Long-term employees can take time off to explore new ideas, projects or experiences and come back with fresh eyes and stories to tell.