Data Warehouse Modelling Engineer (Data Vault 2.0 + dbt)

{
  "content_hash": "9acadc555b6882232aa90cbef258ecd50f69ab05b1dcd9197d0145d53d1f380b",
  "source_hash": "a8cdecf48d42458218b51bf1c3d505b5ff9c00f36c886f2102139dab71fc5e89",
  "last_changed_at": "2026-05-30T06:11:48.937Z",
  "active_status": "active"
}

{
  "language": "en",
  "location": {
    "raw": "St Julians, Malta, STJ9023, Malta",
    "city": "St Julians",
    "region": "Malta",
    "country": null,
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-06T09:43:44.917Z",
  "launch_scope": {
    "reason": "bamboohr_production_catalog",
    "included": true,
    "location": {
      "raw": "St Julians, Malta, STJ9023, Malta",
      "city": "St Julians",
      "region": "Malta",
      "country": null,
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": []
  },
  "remote_policy": null,
  "salary_period": null,
  "workplace_type": null,
  "salary_currency": null
}

{}

{
  "list_job": {
    "id": "224",
    "isRemote": null,
    "location": {
      "city": "St Julians",
      "state": "Malta"
    },
    "atsLocation": {
      "city": null,
      "state": null,
      "country": null,
      "province": null
    },
    "departmentId": "18445",
    "locationType": "2",
    "jobOpeningName": "Data Warehouse Modelling Engineer (Data Vault 2.0 + dbt)",
    "departmentLabel": "Technology Operations",
    "employmentStatusLabel": "Full-Time"
  },
  "detail_errors": [],
  "detail_job_opening": {
    "location": {
      "city": "St Julians",
      "state": "Malta",
      "postalCode": "STJ9023",
      "addressCountry": "Malta"
    },
    "datePosted": "2026-04-08",
    "atsLocation": {
      "city": null,
      "state": null,
      "country": null,
      "countryId": null
    },
    "description": "<p><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">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.<br><br></span></p>\n<p><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt; font-weight: bold\">About the Role</span></p>\n<p><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">We are looking for an experienced <span style=\"font-weight: bold\">Data Warehouse Modelling Engineer</span> to design, build, and maintain enterprise-grade data models using <span style=\"font-weight: bold\">Data Vault 2.0</span> methodology within a modern ELT framework powered by <span style=\"font-weight: bold\">dbt</span>.<br><br></span></p>\n<p><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt; font-weight: bold\">Key Responsibilities:</span></p>\n<ul>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Design and implement <span style=\"font-weight: bold\">Data Vault 2.0</span> models (Raw Vault and Business Vault) including <span style=\"font-weight: bold\">Hubs</span>, <span style=\"font-weight: bold\">Links</span>, <span style=\"font-weight: bold\">Satellites</span>, <span style=\"font-weight: bold\">Point-in-Time (PIT)</span> tables, and <span style=\"font-weight: bold\">Bridges</span>.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Develop and maintain robust <span style=\"font-weight: bold\">dbt</span> projects for Data Vault implementation, leveraging macros, packages (e.g., <span style=\"font-weight: bold\">datavault4dbt</span>, <span style=\"font-weight: bold\">AutomateDV</span> / dbtvault), YAML configurations, and Jinja templating.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Build staging layers, raw vault loading patterns, and business vault transformations following Data Vault 2.0 standards and best practices.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Ensure high data quality, auditability, traceability, and historical tracking through proper hash key design, loading patterns, and effective dating.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Collaborate with data architects, data engineers, and business stakeholders to translate business requirements into scalable Data Vault models.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Optimize data models for performance.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Implement <span style=\"font-weight: bold\">dbt</span> best practices: tests (unit + schema), documentation, selectors, CI/CD pipelines, and version control (Git).</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Support incremental loading strategies, handling of late-arriving data, and multi-source integration challenges.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Contribute to the evolution of the data modelling framework and automation standards.<br><br></span></li>\n</ul>\n<p><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt; font-weight: bold\"><span style=\"text-decoration: underline\">Requirements</span><br></span></p>\n<p><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt; font-weight: bold\">Must-Have Experience:</span></p>\n<ul>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\"><span style=\"font-weight: bold\">Strong hands-on experience</span> (5+ years) in <span style=\"font-weight: bold\">Data Vault 2.0</span> modelling on large-scale enterprise projects.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\"><span style=\"font-weight: bold\">Extensive expertise</span> in building and maintaining Data Vault implementations using <span style=\"font-weight: bold\">dbt</span> (dbt Core or dbt Cloud).</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Deep understanding of Data Vault 2.0 components: Hubs, Links, Satellites (effectivity, multi-active, computed), PIT tables, Bridges, and Reference tables.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Solid SQL skills and experience with modern data warehouses (Trino preferred, ClickHouse a plus).</span></li>\n</ul>\n<p><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt; font-weight: bold\"><br>Technical Skills:</span></p>\n<ul>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Advanced proficiency in <span style=\"font-weight: bold\">dbt</span> — models, macros, tests, documentation, exposures, and project structuring.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Experience with Data Vault automation packages (<span style=\"font-weight: bold\">datavault4dbt</span>, <span style=\"font-weight: bold\">AutomateDV</span>, or similar).</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Strong knowledge of ELT/ETL patterns, data integration from multiple sources, and handling of changing business keys.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Git, CI/CD for data (e.g., dbt Cloud jobs, GitHub Actions), and Infrastructure as Code.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Familiarity with dimensional modelling (Kimball Star Schema) as a downstream consumption layer is a plus.</span></li>\n</ul>\n<p><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt; font-weight: bold\"><br>Soft Skills &amp; Qualifications:</span></p>\n<ul>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Excellent analytical and problem-solving skills with a strong focus on scalability and maintainability.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Ability to work in agile environments and deliver incrementally.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Strong communication skills — able to explain complex modelling concepts to both technical and non-technical stakeholders.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field (or equivalent experience).</span></li>\n</ul>\n<p><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt; font-weight: bold\"><br>Nice-to-Have:</span></p>\n<ul>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Certification in Data Vault 2.0 (from Data Vault Alliance or similar).</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Experience with dbt Cloud features (CI, Jobs, Discovery, etc.).</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Knowledge of data mesh, lakehouse architectures, or real-time Data Vault patterns.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Python scripting for custom dbt macros or utilities.<br></span></li>\n</ul>\n<p><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\"><br></span></p>\n<p><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt; font-weight: bold\">What we offer:</span></p>\n<ul>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Stable and flexible working environment</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Career growth opportunity</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Training and professional development events</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Health insurance for employees and close family members</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Teamwork and accountability</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Sense of community and defined company culture</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">International work environment</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Diverse workplace</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 10pt\">Gym reimbursement after successfully passing probationary period</span></li>\n</ul>",
    "compensation": null,
    "departmentId": "18445",
    "locationType": "2",
    "seekPromoted": false,
    "jobCategoryId": null,
    "jobOpeningName": "Data Warehouse Modelling Engineer (Data Vault 2.0 + dbt)",
    "departmentLabel": "Technology Operations",
    "jobOpeningStatus": "Open",
    "minimumExperience": "Experienced",
    "jobOpeningShareUrl": "https://altenar.bamboohr.com/careers/224",
    "employmentStatusLabel": "Full-Time"
  }
}