Critical Software

Data Warehouse Engineer

Critical Software

full-time

Posted on:

Location Type: Hybrid

Location: Coimbra • Portugal

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

Cyber SecurityERPETLMariaDBMS SQL ServerOraclePostgresPythonSQLSSIS

About the role

  • Uniting rail expertise with digital innovation to create smarter, safer, and more sustainable transportation solutions
  • Accelerating digitalization, embedding cybersecurity, and shaping the next era of rail
  • Producing technical documentation and fostering knowledge sharing within and across teams

Requirements

  • 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.
Benefits
  • Private Health Insurance
  • Employee Assistance Programme
  • Home Office Support
  • Extra Holidays
  • Extra Parental Leave
  • Flex-time
  • Gradual Return to Work Support
  • Away From Keyboard - Sabbatical programme

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
data warehouse architectureautomationMicrosoft SQL ServerSSIST-SQLETL pipeline designperformance tuningscriptingPythonPowerShell
Soft skills
collaborationknowledge sharingtechnical documentationproblem solvingcommunication