Data Modeler

Job Title – Data Modeler

Role Overview

Erwin Environment Setup and Governance

• Configure and administer the Erwin Data Modeler environment for the client.
• 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.
• Databricks Delta Lake structures supporting bronze, silver, and gold data pipelines.
• 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.
• 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.