Company:
TechDigital Corporation
Location: San Antonio
Closing Date: 04/12/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
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.
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.
Share this job