Senior Data Warehouse Architect, Data Vault 2.0

Keyrus

Senior Data Warehouse Architect designing enterprise data platforms for a global consulting firm. Implementing Data Vault 2.0 methodologies while collaborating with diverse teams in a remote setting.

Posted 5/30/2026contractRemote • 🇵🇹 PortugalSenior💰 €50,000 - €60,000 per yearWebsite

Tech Stack

Tools & technologies

AirflowCloudETLSQLVault

About the role

Key responsibilities & impact

Design, implement, and maintain enterprise data warehouse solutions following Data Vault 2.0 methodology
Develop and optimise Hubs, Links, Satellites, PIT, and Bridge tables
Lead conceptual, logical, and physical data modelling activities across multiple initiatives
Define and promote data architecture standards, modelling guidelines, naming conventions, and documentation practices
Ensure scalability, performance, reliability, and maintainability of data warehouse architectures
Provide technical leadership and architectural guidance to Data Engineers and development teams
Drive the standardisation and automation of ELT processes, metadata management, and deployment practices
Collaborate closely with Business Analysts, Product Owners, Data Governance teams, and other stakeholders to translate business requirements into robust data solutions
Support reporting and analytics teams by delivering optimised and business-ready data structures

Requirements

What you’ll need

Minimum 7 years of experience in Data Engineering, Data Architecture, Business Intelligence, or Data Warehouse environments
Proven expertise in Data Vault 2.0 modelling and architecture
Strong experience designing and implementing enterprise-scale Data Warehouse solutions
Advanced SQL skills and strong data modelling expertise
Experience with modern cloud data platforms (Snowflake, Databricks, etc.)
Experience with ETL/ELT tools and orchestration frameworks (DBT, Airflow, etc.)
Strong understanding of: Data Governance, Metadata Management, Data Lineage, Master Data Management (MDM), DataOps practices
Experience providing technical leadership and architectural guidance to engineering teams
Fluency in English
Must be a Portuguese or European citizen, or hold a valid work permit for Portugal

Benefits

Comp & perks

Meal allowance: €10.20/day
Flexible benefits plan
Private medical insurance
22 days of annual leave, increasing every 3 years (up to 25 days)
Continuous learning via KLX – Keyrus Learning Experience
A collaborative, international, and human-centred work environment

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

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

Hard Skills & Tools

Data Vault 2.0data modellingSQLdata architecturedata warehouse solutionsELT processesmetadata managementdata lineageMaster Data ManagementDataOps

Soft Skills

technical leadershipcollaborationcommunication