Senior Data Warehouse Architect (Data Vault 2.0)

Remote, USA
Posted Jun 13, 2026
Full-time

🌍 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.

More Remote Jobs