Omni Inclusive
Data Modeler
Omni Inclusive, San Antonio, Texas, United States, 78208
Job Title/Role : Data Modeler roleMandatory required : DBA/Erwin Data Modeler, Implement 3NF schema design,
JD and responsibilities of DBA/Erwin Data Modeler:
8+ Years of Work Experience in Data ModelingDesign 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 completenessDatabase 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.
JD and responsibilities of DBA/Erwin Data Modeler:
8+ Years of Work Experience in Data ModelingDesign 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 completenessDatabase 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.