Data Modeler

Overview

Role Overvie

Key Responsibiliti

• esErwin Environment Setup and Governan
• ceConfigure and administer the Erwin Data Modeler environmen
• t.Establish and maintain the Erwin Mart repository for version-controlled storage of all Data Domain Model (DDM) artefact
• s.Implement DDA-approved modelling standards, naming conventions, and notation framework
• s.Validate accessibility and operational readiness of the modelling environment for both onshore and offshore delivery team
• s.

Authoritative Data Register Definit

• ionFacilitate stakeholder workshops to identify, scope, and define authoritative data registe
• rs.Document domain boundaries, business definitions, ownership, stewardship responsibilities, and relationships with upstream and downstream syste
• ms.Produce Authoritative Data Register Definition Packs for each regist
• er.

Conceptual, Logical and Physical Data Model

• lingDevelop conceptual data models representing high-level entities, relationships, and business ru
• les.Produce supporting Data Requirements Specifications for each conceptual mo
• del.Develop logical data models defining entities, attributes, relationships, cardinality, and data ty
• pes.Ensure traceability between conceptual and logical models using Erwin traceability featu
• res.Develop physical data models aligned to the client's target architecture, includ
• ing:IBM DB2 Warehouse sche
• mas.Databricks Delta Lake structures supporting Bronze, Silver, and Gold data pipeli
• nes.Reverse engineer existing DB2 database structures where required to support reconciliation between current and target-state desi
• gns.

Data Traceability and Standards Alig

• nmentMaintain complete traceability between approved register definitions and conceptual, logical, and physical mo
• dels.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 opportuni
• ties.

Integration with Enterprise Data Gove

• rnanceCollaborate with Data Catalogue Specialists to ensure data structures are accurately represented in Microsoft Pu
• rview.Support glossary alignment, schema consistency, metadata accuracy, and lineage require
• ments.Ensure authoritative register entities and attributes are consistently represented across modelling and catalogue plat
• forms.

Required Skills and Ex

• perienceExtensive experience with Erwin Data Modeler and Erw
• in Mart.Strong background in conceptual, logical, and physical data mo
• delling.

Experience

• with enterprise data governance and metadata management fra
• meworks.Knowledge of IBM DB2 Warehouse and Databricks Delta Lake archit
• ectures.

Experience

• implementing data modelling standards and traceability c
• ontrols.Strong stakeholder engagement and workshop facilitation
• skills.Understanding of government data standards, information models, and enterprise architecture pr
• actices.