Hybrid Data Warehouse Modelling Engineer, Data Vault 2.0, dbt

Posted 5 minutes ago

Apply now

About the role

  • Data Warehouse Modelling Engineer designing and maintaining data models using Data Vault 2.0 for iGaming industry. Collaborating with stakeholders and optimizing data models in a hybrid work environment.

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

  • 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).
  • 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.
  • 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).

Benefits

  • Health insurance for employees and close family members
  • Career growth opportunity
  • Training and professional development events
  • Teamwork and accountability
  • Sense of community and defined company culture
  • Gym reimbursement after successfully passing probationary period

Job title

Data Warehouse Modelling Engineer, Data Vault 2.0, dbt

Job type

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

Bachelor's Degree

Tech skills

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job