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.
St Julians, Malta
Open 5 months, first seen by us 170 days agoEmployment type in the employer’s posting: Full-TimeFrom 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
Ensure data quality, auditability and historical tracking through hash keys and effective dating
Support incremental loading, late-arriving data and multi-source integration
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.
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.
- 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:
From the employer’s posting.
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.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
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.
4 open jobs
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.
- 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.
Complete your application on altenar.bamboohr.com. The employer’s form will show what is required.
Already applied? Track this application
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:
Requirements
Must-Have Experience:
Technical Skills:
Soft Skills & Qualifications:
Nice-to-Have:
What we offer:
New Analytics Engineer postings at the employers we follow are down 21% over the last 6 weeks compared with the 6 before.
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.
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.
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.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
No pay amount identified in the saved description.
St Julians, Malta
Working pattern and location restrictions need checking in the full posting.
No clear work-authorization passage found. Eligibility is unconfirmed.