Senior Data Warehouse Architect (Data Vault 2.0)

🌍 About Keyrus Keyrus is a global consulting and technology company focused on making data matter — truly matter — from a human perspective. Founded in 1996, Keyrus operates in 28+ countries across 5 continents, with more than 3,300 people worldwide. Our strength comes from combining deep expertise in Data & Analytics, AI, Digital, and Management Consulting with a strong understanding of business realities. Data is never the goal in itself. We use data to shape understanding, design meaningful experiences, and enable better, real-life decisions. At Keyrus, we also believe companies have a responsibility beyond performance. Through our Foundation and ESG initiatives, we actively contribute to sustainability, inclusion, and positive societal impact. #OneTeamOneKeyrus 🎯 The Role As a Senior Data Warehouse Architect (Data Vault 2.0), you will play a key role in designing, evolving, and optimising enterprise-scale data platforms for our clients. You will work at the intersection of data architecture, engineering, and business, helping organisations build scalable, reliable, and future-proof data ecosystems. Collaborating with multidisciplinary teams in an international environment, you will drive architectural decisions, establish best practices, and ensure the successful delivery of modern data warehouse solutions. 📍 Job location: Portugal - Remote 🕒 Contract type: Fixed-term Employee Contract or B2B 🗓 Target start date: July 2026 ⏰ Working hours: Full-time (40h/week) 💵 Compensation: B2B €300–€500/day or Employee Contract with a gross salary between €50,000 and €60,000 per year (for candidates based in Portugal) Note: All applications (CVs) must be submitted in English. 💥 Your Impact In this role, you will: 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 Implement and promote best practices related to data governance, lineage, metadata management, and DataOps Define and enhance monitoring, validation, and observability processes across the data platform Evaluate emerging technologies and recommend improvements to the overall data architecture landscape ⚡ What Makes This Role Challenging You will work with complex enterprise data ecosystems that require scalable and maintainable architectural solutions The role demands deep expertise in Data Vault 2.0 and the ability to apply modelling standards consistently across multiple initiatives You will balance long-term architectural vision with immediate business and delivery requirements The position requires close collaboration with both technical and business stakeholders, translating complex requirements into effective data models You will drive governance, quality, and standardisation efforts while enabling innovation and scalability The environment combines modern cloud data platforms, large data volumes, and evolving business needs 👤 What We’re Looking For Must-haves 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 Excellent communication and stakeholder management skills Strong analytical and problem-solving abilities Fluency in English Must be a Portuguese or European citizen, or hold a valid work permit for Portugal Nice-to-haves Data Vault 2.0 certification Experience with event-driven or real-time data architectures Knowledge of Python and/or Scala for automation and data engineering activities Experience mentoring engineers, leading technical initiatives, or guiding architecture communities Exposure to cloud-native data platform architectures Exposure to international or multicultural projects Experience working in consulting or client-facing environments 💰 How Our Salary Ranges Work At Keyrus, salary ranges reflect different levels of mastery and impact within the same role — not different job titles. Bottom of the range You meet the core requirements and will need ramp-up time and support. Middle of the range You are fully autonomous from Day 1 and deliver consistently. Top of the range You are a reference for the role, mentor others, and raise the bar for the team. Final offers are based on experience, autonomy, scope, and market context, and are discussed transparently during the process. 🎁 What We Offer at Keyrus Portugal Competitive salary aligned with your experience and the data market 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 💙 Why Keyrus? Joining Keyrus means joining: A market leader in Data Intelligence A company where people, trust, and diversity are core values An environment that values ownership, flexibility, and innovation A place where different backgrounds and perspectives are not just welcomed = they are essential We believe diversity drives better thinking, stronger teams, and better outcomes. Everyone belongs at Keyrus. ♿ Equal Opportunity Statement We are committed to building an inclusive workplace and encourage applications from all backgrounds, regardless of race, ethnicity, gender identity, sexual orientation, age, disability, or any other protected characteristic. Apply To This Job