About the job Data Modeler / Data Intelligence ManagerKey purpose:To ensure the proper functioning of our company'serwin suite of products, (erwin Data Modeler and Data Intelligence) for data modeling and metadata management. This hands-on position will ensure the daily functioning of these environments in respect of access, performance and storage management. The scope includes ensuring the solutions are healthy and is used according to architectural standards and configuration specifications. To ensure the technical and architectural integrity of the system environments and its repositories, extract database schema information and metadata from various source databases as well as the publishing of DDLs to development environments and enable the use and maintenance of an enterprise data glossary. This position will work with data modelers and architects to ensure their knowledge assets are properly crafted, reviewed, stored and accessed. The position will report to the Architecture Practice Manager and work closely with the Data Domain Architect This is a specialist position and entails detailed system knowledge.Duties and responsibilities:Support, administrate and maintain the enterprise modeling and metadata management capabilities using erwin Data Modeler and erwin Data IntelligenceEnsure the usability and value of the company metadata and modelsSupport the Data Architecture capability and data practice at Enterprise levelEnsure system health and the pro-active management of system resources to ensure that performance, access and storage NFRs are adhered toPerform technical configuration, administration and management of erwin landscape to support a multi-user environment.Setup and configure the various erwin landscapes (erwin DM and erwin DI) etc.Understand, test, validate and manage new versions and upgrade of all related modelling tools from Beta testing to productionizing of the modelling environmentPerform housekeeping activities such as consolidating objects, checking model structures and modelling compliance.Apply the necessary governance in the erwin suite to ensure adequate security and architectural controlManage the extraction of metadata and model structures from various sourcesEnsure database schemes are extracted from various source systems and enable reverse engineering of databases into ERDsExtract metadata from various sources using erwin ODBC connectorsEnsure proper process and governance is in place and followedMaintain the metadata and data model repositoryEnsure the integrity of all logical and physical models as well as the extraction and enrichment of metadata across the data architectural landscape in the erwin solution sets.Manage and ensure the integrity and quality of the metadata repositoryConduct checks on models to ensure technical compliance.Ensure erwin landscape integrity by identifying and resolving inappropriate objec occurrences, unnecessary or duplicate models, redundancies, and erroneous model development.Ensure modelling system processes are adhered to and technical aspects are performed.Enable and use reference artefacts like standards and templates to ensure a consistent modelling approachEnsure models are published and are accessible to the various stakeholdersAssist in establishing the required capabilities / resources in the modelling community.Ensure user access correct access to the right peopleAble to report on system health and other management informationEnsure DDLs are generated from physical data models and deployed to various development environments either manually or using BitbucketEnable data sharing between erwin Data Modeler, Data Intelligence and other systems using APIsEnsure metadata and data models get published in accordance with the needs of the data management function and architectural principlesReview integration / consolidation of models for the companyMonitor compliance of user modelling to modelling standards.Develop and provide management reports of the erwin landscape according to management requirementsFacilitate the setting of data modelling standards and associated metamodel adherenceEnsure server and system maintenance tasks are successfully executed and monitored (memory, disk space, backups, etc.). Ensure system health and the pro-active management of system resources to ensure performance, access and adequate storage. Manage updates and patchesRecover databases in the event of data corruption, crashes or on request.Budget and plan growth in erwin landscape deployment to support company demand on data modeling and metadata management needsEnsure erwin landscape support and maintenance are timeously renewed and that the package vendor invoices are correct.Reduce bottlenecks in data model integration, consolidation and releasesEnsure there are sufficient back-ups and redundancyQualifications and experience:Diploma or Degree qualification in Information Systems Or Experienced erwin Repository Manager with minimum 5 years experienceHonours degree with focus in Information ManagementStrong analytical skills with attention to detailExcellent team-working and interpersonal skillsStrong communication and relationship building skillsDevelopment of engaging presentation materialsExcellent verbal and written communication skillsAdministering data modelling and metadata management tools and licensing, user permissionsRetail industry business processes and systemsAdministering erwin landscape tools and licensing, user permissionsExperience as a data analyst/information data architectExperience with distributed management and analytics in cloud and hybrid environments. Also, an understanding of a variety of data access and analytics approaches and data system life cycle methodologiesJob related skills:Strong analytical skills with attention to detailExcellent team-working and interpersonal skillsStrong communication and relationship building skillsDevelopment of engaging presentation materialsExcellent verbal and written communication skills
#J-18808-Ljbffr