Altenar
Data Warehouse Modelling Engineer (Data Vault 2.0 + dbt)
St Julians, Malta
hirly Pro
Get in front of the people hiring at Altenar
- Reach the hiring manager at Altenar on LinkedIn, from your own account
- hirly applies to this job for you, with unlimited applications
- A resume and cover letter written for this job, unlimited
- The hiring manager and recruiter at Altenar, with contact details
$49 a month · ₹1,999 for 30 days in India · cancel any time
Get past the screening software and onto a recruiter's desk
hirly rewrites your resume for this job — matching the keywords and skills in the posting, moving your most relevant experience to the top, and writing a cover letter to fit. About 30 seconds.
- Keywords matched to this posting
- Fit score before you apply
- Cover letter included
Matched against 2.9M live jobs from 220,000+ employers in 200+ countries.
Tailor my resume for this job →Apply from your AI assistant
Connect hirly to Claude or ChatGPT and ask it to apply to this job. hirly tailors your resume, fills the employer’s form and asks before sending.
Some employer sites stop an application at a CAPTCHA or sign-in and hand it back with a link. Applying needs a paid plan. Works with any assistant that supports MCP.
hirly's read of this role
- Seniority
- Mid level
- Country
- MT
- Work mode
- On-site / unstated
- First seen by hirly
- 1 Sept 2026
Derived automatically from the posting. Upload your resume above to see how the role scores against it.
the 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
Listed on hirly, a job board. hirly is not the employer: Altenar is hiring for this role.
Similar jobs
- AI Modelling Engineer, Digital TwinViavisolutions · Stevenage, GBRFirst seen today
- Quantitative Modelling EngineerPlantingspace · RemoteFirst seen 10d agoremote
- Data Modelling EngineerRimestechnologies · SingaporeFirst seen 21d ago
- Simulation and Modelling EngineerMbda · StevenageFirst seen 25d ago
- Simulation & Modelling Engineer (d/f/m) - Space SystemsAirbus Defence and Space GmbH · Immenstaad am Bodensee, Baden-Württemberg, GermanyFirst seen 28d ago
Browse similar roles
Want this one?
Upload your resume and hirly rewrites it for this job and writes the cover letter — in about thirty seconds, before you sign up.
Tailor my resume for this job