Data Modeller

Venquis; Abu Dhabi; On-site; AED 240,000 - 360,000; Full time

Job summary

Venquis is seeking a Data Modeler to design scalable data models and semantic layers for a Lakehouse architecture in Abu Dhabi. You will build knowledge graphs, define ontologies, and enable enterprise-wide data discovery.

You will collaborate with Data Architects and Engineers to implement models in Glue and Iceberg, ensuring governance and performance in a fast-paced environment.

Qualifications

• Experience designing data models for Lakehouse or data warehouse environments.
• Familiarity with semantic layers, ontologies and knowledge graphs.
• Knowledge of metadata management and lineage tools.

Responsibilities

• Design conceptual, logical, and physical data models for Lakehouse architectures (Bronze/Silver/Gold).
• Implement dimensional modeling for analytics layers and SCD2 with history tracking.
• Define naming conventions, metadata standards and model documentation.
• Design and implement a semantic layer for business-friendly data access.
• Develop ontologies and taxonomies; ensure semantic consistency across data products.
• Build and maintain knowledge graphs to enable advanced data discovery.
• Integrate graph capabilities with lakehouse metadata and lineage tools (OpenMetadata).
• Collaborate with Data Architects and Data Engineers to ensure correct implementation in Glue and Iceberg tables.
• Embed validation rules with Data Quality teams and support governance.

Skills

Data Modeling

Lakehouse Architecture

Semantic Layer Design

Knowledge Graph Development

Analytical Thinking

Stakeholder Engagement

Agile / Jira

Tools

ERwin

PowerDesigner

OpenMetadata

OWL/RDF Libraries

Neo4j

Job description

Role: Data Modeler

Location

Abu Dhabi
Employment Type: Full-time

Overview

We are seeking a Data Modeler with expertise in designing scalable data models and semantic layers for our Lakehouse architecture. This role will also focus on building knowledge graphs, defining ontologies, and enabling advanced data discovery and interoperability across the enterprise.

Key Responsibilities

• Data Modeling
  • Design conceptual, logical, and physical data models for Medallion architecture (Bronze, Silver, Gold layers).
  • Implement dimensional modeling for analytical layers.
  • Apply Slowly Changing Dimensions (SCD2) and historical tracking techniques.
  • Define and enforce naming conventions, metadata standards, and maintain model documentation.
• Semantic Layer & Ontologies
  • Design and implement a semantic layer to enable business-friendly data access and self-service analytics.
  • Work with advanced AI-tooling for semantic layer deployment and integration.
  • Develop and maintain ontologies and taxonomies to standardize business concepts across domains.
  • Ensure semantic consistency across data products and reporting layers.
• Knowledge Graph Development
  • Build and maintain knowledge graphs to represent relationships between entities and enable advanced data discovery.
  • Integrate knowledge graph capabilities with Lakehouse metadata and lineage tools (e.g., OpenMetadata).
  • Collaborate with architects and platform engineers to ensure graph scalability and performance.
• Collaboration & Governance
  • Work closely with Data Architects to align models with Lakehouse design principles.
  • Partner with Data Engineers to ensure models are correctly implemented in Glue and Iceberg tables.
  • Collaborate with Data Quality teams to embed validation rules and ensure compliance.

• Optimization & Standards
  • Ensure models support schema evolution, partitioning strategies, and performance optimization.
  • Create reusable modeling templates and best practices for Data Factory squads.

Required Skills & Experience

• Technical Expertise
  • Strong experience in data modeling for Lakehouse or data warehouse environments.
  • Proficiency in semantic layer design, ontologies, and knowledge graph development.
  • Familiarity with AWS Glue, Apache Iceberg, and Medallion architecture.
  • Understanding of metadata management and lineage tools (OpenMetadata preferred).
• Tools & Technologies
  • Data modeling tools (ERwin, PowerDesigner, or similar).
  • Semantic layer tools (e.g., Zaimler, AtScale, or equivalent).
  • Knowledge graph frameworks (e.g., RDF, OWL, Neo4j, or similar).
• Soft Skills
  • Strong analytical and conceptual thinking.
  • Excellent communication and stakeholder engagement abilities.
  • Ability to work in a fast-paced environment and deliver aggressive migration targets.
  • Strong collaboration and communication skills.
  • Work with Jira and agile way of working.

Preferred Qualifications

• 7+ years in data modeling or data architecture roles.
• Experience in semantic technologies, knowledge graphs, and financial services domain is a strong plus.