Back to jobs

Data Warehouse Modelling Engineer (Data Vault 2.0 + dbt)

Pay
Pay not listed
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-Time
From the employer’s posting

What you’ll work on

Full posting

We are looking for an experienced Data Warehouse Modelling Engineer to design, build, and maintain enterprise-grade data models using Data Vault 2.0 methodology within a modern ELT framework powered by dbt.

  • Build staging layers, raw vault loading patterns and business vault transformations

  • Ensure data quality, auditability and historical tracking through hash keys and effective dating

  • Support incremental loading, late-arriving data and multi-source integration

From the employer’s posting
We are looking for an experienced Data Warehouse Modelling Engineer to design, build, and maintain enterprise-grade data models using Data Vault 2.0 methodology within a modern ELT framework powered by dbt.
Build staging layers, raw vault loading patterns, and business vault transformations following Data Vault 2.0 standards and best practices.
Ensure high data quality, auditability, traceability, and historical tracking through proper hash key design, loading patterns, and effective dating.
Support incremental loading strategies, handling of late-arriving data, and multi-source integration challenges.

What you’ll bring

All qualifications

Core experience

  • Deep understanding of Data Vault 2.0 components: Hubs, Links, Satellites (effectivity, multi-active, computed), PIT tables, Bridges, and Reference tables.
  • Experience with Data Vault automation packages (datavault4dbt, AutomateDV, or similar).
  • Ability to work in agile environments and deliver incrementally.
  • Experience with dbt Cloud features (CI, Jobs, Discovery, etc.).
  • Solid SQL skills and experience with modern data warehouses
  • Strong knowledge of ELT/ETL patterns, data integration from multiple sources, and handling of changing business keys.

Preferred experience

  • Trino preferred, ClickHouse a plus
  • Familiarity with dimensional modelling (Kimball Star Schema) as a downstream consumption layer is a plus.
Qualification wording
Deep understanding of Data Vault 2.0 components: Hubs, Links, Satellites (effectivity, multi-active, computed), PIT tables, Bridges, and Reference tables.
Experience with Data Vault automation packages (datavault4dbt, AutomateDV, or similar).
Ability to work in agile environments and deliver incrementally.
Experience with dbt Cloud features (CI, Jobs, Discovery, etc.).
Solid SQL skills and experience with modern data warehouses (Trino preferred, ClickHouse a plus).
Strong knowledge of ELT/ETL patterns, data integration from multiple sources, and handling of changing business keys.
Familiarity with dimensional modelling (Kimball Star Schema) as a downstream consumption layer is a plus.
Education & alternatives
- Strong communication skills — able to explain complex modelling concepts to both technical and non-technical stakeholders. - Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field (or equivalent experience). Nice-to-Have:

Benefits in the posting

Full benefits wording
  • Stable and flexible working environment
  • Career growth opportunity
  • Training and professional development events
  • Health insurance for employees and close family members
  • Teamwork and accountability
  • Sense of community and defined company culture
  • International work environment
  • Diverse workplace
  • Gym reimbursement after successfully passing probationary period

From the employer’s posting.

Apply at Altenar

Posting record

Report an error

Open 5 monthsWe first saw this posting 170 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Jun 4, 2026170 days ago
Recorded sightings
97
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 170

Up longer than most. Similar jobs usually come down between day 7 and day 52.

From 1,781 similar postings that came down. Coming down is not always a hire.

Altenar is hiring

4 open jobs

  • No new data jobs since July
  • Its jobs tend to stay up a long time
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • ClickHouse
  • dbt
  • Trino
Where the posting names them
- Knowledge of data mesh, lakehouse architectures, or real-time Data Vault patterns. - Python scripting for custom dbt macros or utilities. What we offer:
- Deep understanding of Data Vault 2.0 components: Hubs, Links, Satellites (effectivity, multi-active, computed), PIT tables, Bridges, and Reference tables. - Solid SQL skills and experience with modern data warehouses (Trino preferred, ClickHouse a plus). Technical Skills:
About the Role We are looking for an experienced Data Warehouse Modelling Engineer to design, build, and maintain enterprise-grade data models using Data Vault 2.0 methodology within a modern ELT framework powered by dbt. Key Responsibilities:
- Design and implement Data Vault 2.0 models (Raw Vault and Business Vault) including Hubs, Links, Satellites, Point-in-Time (PIT) tables, and Bridges. - Develop and maintain robust dbt projects for Data Vault implementation, leveraging macros, packages (e.g., datavault4dbt, AutomateDV / dbtvault), YAML configurations, and Jinja templating. - Build staging layers, raw vault loading patterns, and business vault transformations following Data Vault 2.0 standards and best practices.
- Optimize data models for performance. - Implement dbt best practices: tests (unit + schema), documentation, selectors, CI/CD pipelines, and version control (Git). - Support incremental loading strategies, handling of late-arriving data, and multi-source integration challenges.
- Strong hands-on experience (5+ years) in Data Vault 2.0 modelling on large-scale enterprise projects. - Extensive expertise in building and maintaining Data Vault implementations using dbt (dbt Core or dbt Cloud). - Deep understanding of Data Vault 2.0 components: Hubs, Links, Satellites (effectivity, multi-active, computed), PIT tables, Bridges, and Reference tables.
Technical Skills: - Advanced proficiency in dbt — models, macros, tests, documentation, exposures, and project structuring. - Experience with Data Vault automation packages (datavault4dbt, AutomateDV, or similar).
- Strong knowledge of ELT/ETL patterns, data integration from multiple sources, and handling of changing business keys. - Git, CI/CD for data (e.g., dbt Cloud jobs, GitHub Actions), and Infrastructure as Code. - Familiarity with dimensional modelling (Kimball Star Schema) as a downstream consumption layer is a plus.
- Certification in Data Vault 2.0 (from Data Vault Alliance or similar). - Experience with dbt Cloud features (CI, Jobs, Discovery, etc.). - Knowledge of data mesh, lakehouse architectures, or real-time Data Vault patterns.

Your next step

Complete your application on altenar.bamboohr.com. The employer’s form will show what is required.

Applying through BambooHR

  • No account needed. The form takes images too, but an image of a resume has no text for anyone to search: upload a PDF or Word file.

Already applied? Track this application

Job description

View original posting ↗

Altenar is an international IT company founded in 2011, with offices in Malta, Greece, Georgia, the Isle of Man, and Uruguay. We specialize in high-load software development and provide one of the best technology solutions for the iGaming industry worldwide.

About the Role

We are looking for an experienced Data Warehouse Modelling Engineer to design, build, and maintain enterprise-grade data models using Data Vault 2.0 methodology within a modern ELT framework powered by dbt.

Key Responsibilities:

  • Design and implement Data Vault 2.0 models (Raw Vault and Business Vault) including Hubs, Links, Satellites, Point-in-Time (PIT) tables, and Bridges.
  • Develop and maintain robust dbt projects for Data Vault implementation, leveraging macros, packages (e.g., datavault4dbt, AutomateDV / dbtvault), YAML configurations, and Jinja templating.
  • Build staging layers, raw vault loading patterns, and business vault transformations following Data Vault 2.0 standards and best practices.
  • Ensure high data quality, auditability, traceability, and historical tracking through proper hash key design, loading patterns, and effective dating.
  • Collaborate with data architects, data engineers, and business stakeholders to translate business requirements into scalable Data Vault models.
  • Optimize data models for performance.
  • Implement dbt best practices: tests (unit + schema), documentation, selectors, CI/CD pipelines, and version control (Git).
  • Support incremental loading strategies, handling of late-arriving data, and multi-source integration challenges.
  • Contribute to the evolution of the data modelling framework and automation standards.

Requirements

Must-Have Experience:

  • Strong hands-on experience (5+ years) in Data Vault 2.0 modelling on large-scale enterprise projects.
  • Extensive expertise in building and maintaining Data Vault implementations using dbt (dbt Core or dbt Cloud).
  • Deep understanding of Data Vault 2.0 components: Hubs, Links, Satellites (effectivity, multi-active, computed), PIT tables, Bridges, and Reference tables.
  • Solid SQL skills and experience with modern data warehouses (Trino preferred, ClickHouse a plus).


Technical Skills:

  • Advanced proficiency in dbt — models, macros, tests, documentation, exposures, and project structuring.
  • Experience with Data Vault automation packages (datavault4dbt, AutomateDV, or similar).
  • Strong knowledge of ELT/ETL patterns, data integration from multiple sources, and handling of changing business keys.
  • Git, CI/CD for data (e.g., dbt Cloud jobs, GitHub Actions), and Infrastructure as Code.
  • Familiarity with dimensional modelling (Kimball Star Schema) as a downstream consumption layer is a plus.


Soft Skills & Qualifications:

  • Excellent analytical and problem-solving skills with a strong focus on scalability and maintainability.
  • Ability to work in agile environments and deliver incrementally.
  • Strong communication skills — able to explain complex modelling concepts to both technical and non-technical stakeholders.
  • Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field (or equivalent experience).


Nice-to-Have:

  • Certification in Data Vault 2.0 (from Data Vault Alliance or similar).
  • Experience with dbt Cloud features (CI, Jobs, Discovery, etc.).
  • Knowledge of data mesh, lakehouse architectures, or real-time Data Vault patterns.
  • Python scripting for custom dbt macros or utilities.


What we offer:

  • Stable and flexible working environment
  • Career growth opportunity
  • Training and professional development events
  • Health insurance for employees and close family members
  • Teamwork and accountability
  • Sense of community and defined company culture
  • International work environment
  • Diverse workplace
  • Gym reimbursement after successfully passing probationary period

Demand for Analytics Engineer roles

New Analytics Engineer postings at the employers we follow are down 21% over the last 6 weeks compared with the 6 before.

Weekly new Analytics Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 81, the most 168, and the latest week had 91.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analytics Engineer, by the work the posting describes.

Analytics engineers turn raw warehouse data into clean, tested and documented tables that analysts and dashboards can rely on, often with dbt.

Expect strong SQL, data modeling, Git, and a warehouse such as Snowflake, BigQuery or Redshift.

A data engineer gets data into the warehouse; an analytics engineer shapes it once it is there and works closer to the analysts who use it.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for analytics engineers, so these figures are for the closest group, database architects, the same group we use for data engineers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

St Julians, Malta

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.