Data Modeler

Job Title / Role : Data Modeler role

Mandatory required : DBA / Erwin Data Modeler, Implement 3NF schema design,

JD and responsibilities of DBA / Erwin Data Modeler :

• 8+ Years of Work Experience in Data Modeling
• Design and create logical and physical data models : used Erwin to visually represent the entities, attributes, relationships, and constraints within a database system. Both logical models (focusing on business concepts) and physical models (considering the specific database platform) might be required.
• Implement 3NF schema design.
• Analyze existing data models and suggest improvements : evaluate existing data models for accuracy, efficiency, and adherence to data governance standards. suggest improvements to optimize the model's structure and functionality.
• Data Management :
• Develop and maintain data dictionaries : The data modeler will ensure the data dictionary is accurate and up-to-date, reflecting the current state of the data model.
• Develop and maintain data quality rules : defining rules to ensure data accuracy, consistency, and completeness
• Database Design and Implementation :
• Design and implement database objects : creating tables, views, stored procedures, and triggers within the dbms based on the data model specifications.
• Develop and maintain database standards and procedures : contribute to establishing data management standards and procedures within the organization to ensure consistent data practices.
• Communication and Collaboration :
• Work with business stakeholders to understand data requirements : maintain clear communication with business users to understand their information needs and translate them into the technical data model.
• Collaborate with IT teams to implement the data model : work with database administrators and developers to ensure the model is successfully implemented within the chosen database platform.
• Additional Skills :
• Proficiency in SQL (Structured Query Language) for interacting with databases.
• Proficiency in Nosql DynamoDB .
• Understanding of data governance principles and best practices.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.