Design and implement data pipelines that integrate Warehouse Management Systems (WMS) into an existing enterprise data platform
Extend and maintain a Data Vault 2.0 architecture (Raw Vault, Business Vault, and Information Mart layers)
Develop data transformations using dbt within a Databricks Lakehouse environment
Build persistent staging and ingestion pipelines to address operational system data retention limitations
Integrate data from multiple operational and reference sources to enable consolidated cross-system reporting
Contribute to the creation of scalable Information Marts that support high-frequency analytical reporting
Follow and enhance existing automation frameworks and development standards used in the platform
Collaborate with data architects, engineers, and business stakeholders to ensure solutions are robust, scalable, and future-ready
Contribute to designing architectures that can evolve from batch ingestion to real-time data processing

Proven experience working with Data Vault 2.0 modelling
Strong experience with modern data platforms such as Databricks or Snowflake
Hands-on experience using dbt (Data Build Tool) for data transformation
Strong SQL and data modelling skills
Experience building data ingestion pipelines and integrating multiple source systems
Strong analytical and problem-solving skills
Ability to communicate clearly with both technical and non-technical stakeholders
A collaborative mindset and sense of ownership
Fluency in English
Must be a Portuguese or European citizen, or hold a valid work permit for Portugal

Data Engineer – BI Consultant, Data Vault Specialist

Key skills