Data Modeler / Data Intelligence Manager
主要目的：确保公司的 erwin 产品套件 （erwin 数据建模器和数据智能）运行良好，用于数据建模和转型数据管理。这种实践立场将确保这些环境在访问，性能和存储管理方面日常运作。范围包括确保解决方案是健康的，并根据建筑标准和配置规范使用。为了确保系统环境及其存储库的技术和建筑完整性，从各种源数据库中提取数据库方案信息和元数据以及将 DDL 发布到开发环境中，并使企业数据词典使用和维护成为可能。该职位将与数据建模师和建筑师合作以确保他们的知识资产得到适当设计，审查，存储和访问。该职位将向架构实践经理报告，并与数据域体系结构师密切合作。这是一个专业职位，涉及详细的系统知识。职责和责任：· 支持，管理和维护企业模型和元数据管理能力使用 erwin Data Modeler 和 erwin Data Intelligence ·确保公司元数据和模型的可用性和价值 · 在企业层面支持数据架构的能力和数据实践 ·确保系统健康和主动管理系统资源以确保执行，访问和存储 NFR 的遵守 · 进行技术配置，管理和管理 erwin 景观以支持多用户环境。·设置和配置各种 erwin 景色 （erwin DM 和 erwin DI）等。·了解，测试，验证和管理新版本以及从 Beta 测试到模型环境生产的相关建模工具升级 ·执行物体整合，检查模型结构和建模合规等家庭维护活动。·应用 Erwin 套件中必要的治理以确保适当的安全性和建筑控制 ·管理来自各种来源的元数据和模型结构的提取 ·确保数据库方案从各种源系统中提取并使数据库转化为 ERDs ·使用 erwin ODBC 连接器从各种来源提取元数据。·确保适当的程序和治理，并遵循其；
查看英文原文
Key purpose:
To ensure the proper functioning of our company's erwin 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 Intelligence
- Ensure the usability and value of the company metadata and models
- Support the Data Architecture capability and data practice at Enterprise level
- Ensure system health and the pro-active management of system resources to ensure that performance, access and storage NFRs are adhered to
- Perform 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 environment
- Perform 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 control
- Manage the extraction of metadata and model structures from various sources
- Ensure database schemes are extracted from various source systems and enable reverse engineering of databases into ERDs
- Extract metadata from various sources using erwin ODBC connectors
- Ensure proper process and governance is in place and followed
- Maintain the metadata and data model repository
- Ensure 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 repository
- Conduct 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 approach
- Ensure models are published and are accessible to the various stakeholders
- Assist in establishing the required capabilities / resources in the modelling community.
- Ensure user access correct access to the right people
- Able to report on system health and other management information
- Ensure DDLs are generated from physical data models and deployed to various development environments either manually or using Bitbucket
- Enable data sharing between erwin Data Modeler, Data Intelligence and other systems using APIs
- Ensure metadata and data models get published in accordance with the needs of the data management function and architectural principles
- Review integration / consolidation of models for the company
- Monitor compliance of user modelling to modelling standards.
- Develop and provide management reports of the erwin landscape according to management requirements
- Facilitate the setting of data modelling standards and associated metamodel adherence
- Ensure 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 patches
- Recover 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 needs
- Ensure erwin landscape support and maintenance are timeously renewed and that the package vendor invoices are correct.
- Reduce bottlenecks in data model integration, consolidation and releases
- Ensure there are sufficient back-ups and redundancy
Qualifications and experience:
- Diploma or Degree qualification in Information Systems Or Experienced erwin Repository Manager with minimum 5 years experience
- Honours degree with focus in Information Management
- Strong analytical skills with attention to detail
- Excellent team-working and interpersonal skills
- Strong communication and relationship building skills
- Development of engaging presentation materials
- Excellent verbal and written communication skills
- Good facilitation skills
- Administering data modelling and metadata management tools and licensing, user permissions
- Retail industry business processes and systems
- Administering erwin landscape tools and licensing, user permissions
- Experience as a data analyst/information data architect
- Experience 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 methodologies
Job related skills:
- Strong analytical skills with attention to detail
- Excellent team-working and interpersonal skills
- Strong communication and relationship building skills
- Development of engaging presentation materials
- Excellent verbal and written communication skills
- Good facilitation skills
Originally posted on Himalayas