Data Modeller (Erwin Data Modeler)
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
RibbitZ LLC is seeking a Data Modeller to establish and manage enterprise data modelling capability for ADC using Erwin Data Modeler. The role involves leading the design of conceptual, logical, and physical data models, ensuring alignment with government data standards.
Key Skills for This Role
Responsibilities
- Configure and administer the Erwin Data Modeler environment for ADC
- Establish and maintain the Erwin Mart repository for version controlled storage of all Data Domain Model (DDM) artefacts
- Implement DDA approved modelling standards, naming conventions, and notation frameworks
- Facilitate stakeholder workshops to identify, scope, and define authoritative data registers
- Develop conceptual data models representing high level entities, relationships, and business rules
- Develop logical data models defining entities, attributes, relationships, cardinality, and data types
- Develop physical data models aligned to ADC’s target architecture, including IBM DB2 Warehouse and Databricks Delta Lake
- Maintain complete traceability between approved register definitions and conceptual, logical, and physical models
- Collaborate with Data Catalogue Specialists to ensure data structures are accurately represented in Microsoft Purview
- Prepare modelling artefacts for formal DDA review and approval
Requirements
- Extensive experience with Erwin Data Modeler and Erwin Mart
- Strong background in conceptual, logical, and physical data modelling
- Experience with enterprise data governance and metadata management frameworks
- Knowledge of IBM DB2 Warehouse and Databricks Delta Lake architectures
- Experience implementing data modelling standards and traceability controls
- Strong stakeholder engagement and workshop facilitation skills
- Understanding of government data standards, information models, and enterprise architecture practices
Full Job Posting
Role Overview
- The Data Modeller will be responsible for establishing and managing the enterprise data modelling capability for ADC using Erwin Data Modeler.
- The role will lead the design and delivery of authoritative data register models across conceptual, logical, and physical layers while ensuring alignment with government data standards, enterprise architecture requirements, and target platform implementations.
Erwin Environment Setup and Governance
- Configure and administer the Erwin Data Modeler environment for ADC.
- Establish and maintain the Erwin Mart repository for version controlled storage of all Data Domain Model (DDM) artefacts.
- Implement DDA approved modelling standards, naming conventions, and notation frameworks.
- Validate accessibility and operational readiness of the modelling environment for both onshore and offshore delivery teams.
Authoritative Data Register Definition
- Facilitate stakeholder workshops to identify, scope, and define authoritative data registers.
- Document domain boundaries, business definitions, ownership, stewardship responsibilities, and relationships with upstream and downstream systems.
- Produce Authoritative Data Register Definition Packs for each register.
Conceptual, Logical and Physical Data Modelling
- Develop conceptual data models representing high level entities, relationships, and business rules.
- Produce supporting Data Requirements Specifications for each conceptual model.
- Develop logical data models defining entities, attributes, relationships, cardinality, and data types.
- Ensure traceability between conceptual and logical models using Erwin traceability features.
- Develop physical data models aligned to ADC’s target architecture, including IBM DB2 Warehouse schemas and Databricks Delta Lake structures.
- Reverse engineer existing DB2 database structures where required to support reconciliation between current and target state designs.
Data Traceability and Standards Alignment
- Maintain complete traceability between approved register definitions and conceptual, logical, and physical models.
- Manage DDM ID Mapping Tables and Erwin Mart version logs.
- Align data models with the Unified Data Model (UDM) and Government Information Model (GIM).
- Maintain the GIM/UDM Alignment Register and identify gaps, conflicts, or enhancement opportunities.
Integration with Enterprise Data Governance
- Collaborate with Data Catalogue Specialists to ensure data structures are accurately represented in Microsoft Purview.
- Support glossary alignment, schema consistency, metadata accuracy, and lineage requirements.
- Ensure authoritative register entities and attributes are consistently represented across modelling and catalogue platforms.
Review, Approval and Compliance
- Prepare modelling artefacts for formal DDA review and approval.
- Produce Modelling Approval Packages including Erwin exports, DDM ID Mapping Tables, Data Requirements Specifications, and GIM/UDM Alignment Register.
- Manage review cycles, incorporate feedback, and maintain version control until formal sign off is achieved.
Physical Model Controls
- Ensure all physical models include audit columns, logging requirements, and error handling specifications.
- Validate physical model structures against Databricks pipeline implementation requirements and enterprise data governance standards.
Required Skills and Experience
- Extensive experience with Erwin Data Modeler and Erwin Mart.
- Strong background in conceptual, logical, and physical data modelling.
- Experience with enterprise data governance and metadata management frameworks.
- Knowledge of IBM DB2 Warehouse and Databricks Delta Lake architectures.
- Experience implementing data modelling standards and traceability controls.
- Strong stakeholder engagement and workshop facilitation skills.
- Understanding of government data standards, information models, and enterprise architecture practices.
Deliverables
- Erwin Mart repository and modelling standards configuration.
- Authoritative Data Register Definition Packs.
- Conceptual, logical, and physical data models.
- Data Requirements Specifications.
- DDM ID Mapping Tables.
- GIM/UDM Alignment Register.
- Modelling Approval Packages and DDA sign off artefacts.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at RibbitZ LLC
Data Quality Engineer (Databricks)
Abu Dhabi, UAE
RibbitZ LLC is seeking a Data Quality Engineer to design and implement an enterprise data quality framework on Databricks. The role involves automated profiling, quality rule execution, cleansing, monitoring, and reporti
Data Engineer (Microsoft Fabric | Azure | Databricks)
Dubai, UAE
Role Summary We are seeking a Data Engineer with hands-on experience in Azure-based data platforms and Microsoft Fabric to build scalable data pipelines and analytics solutions. The ideal candidate will have strong ski
Informatica Technical Lead (DG/DQ)
Dubai, UAE
📄 Employment Type: Contract (6 Months – Extendable up to 1 Year) 🔹 Role Overview: We are seeking an experienced Informatica Technical Lead to drive Data Governance (DG) and Data Quality (DQ) initiatives using Informati
SAP MM Lead Solution Architect (Procurement)
Dubai, UAE
We are looking for an experienced SAP MM Lead Solution Architect specializing in Procurement and Supply Chain within the Metals & Cables industry . The candidate will drive procurement transformation and optimize sourcin
Java/Joget Developer
Abu Dhabi, UAE
POSITION PURPOSE: • Full Stack Developer, will work closely with senior developers and cross-functional teams to design, develop, test, and deploy innovative software solutions. Role Description • Design and develop soft
Data Quality Engineer (Databricks)
Abu Dhabi, UAE
Data Engineer (Microsoft Fabric | Azure | Databricks)
Dubai, UAE
Informatica Technical Lead (DG/DQ)
Dubai, UAE
SAP MM Lead Solution Architect (Procurement)
Dubai, UAE
Java/Joget Developer
Abu Dhabi, UAE