Data Modeller

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.

Venquis is acting as an Employment Agency in relation to this vacancy.