Sr Technical Lead Erwin Data Modeler

TechDigital Group; San Antonio (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

An established industry player is seeking an experienced Data Modeler to join their team. In this pivotal role, you will leverage your expertise in data modeling and database design to create logical and physical data models that meet business requirements. Your responsibilities will include implementing 3NF schema designs, analyzing existing data models for improvements, and collaborating with stakeholders to ensure data governance standards are upheld. This position offers an exciting opportunity to contribute to data management practices and make a significant impact on the organization's data strategy. If you are passionate about data and eager to drive efficiency, this role is perfect for you.

Qualifications

• 6+ years of experience in data modeling and database design.
• Proven skills in implementing 3NF schema design and data governance.
• Design logical and physical data models with 3NF considerations.

Responsibilities

• Design and create logical and physical data models using Erwin.
• Analyze existing data models and suggest improvements for efficiency.
• Analyze existing data models and suggest improvements for accuracy and governance.

Skills

Data Modeling

DBA/Erwin Data Modeler

3NF schema design

Data Governance Standards

Database Design

Data Quality Rules

Tools

Erwin

Job description

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

Detailed Job Description:

1. 6 + Years of Work Experience in Data Modeling
2. 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.
3. Implement 3NF schema design.
4. 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.
5. Data Management:
6. 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.
7. Develop and maintain data quality rules: defining rules to ensure data accuracy, consistency, and completeness within the database.
8. Database Design and Implementation:
9. Design and implement database objects: creating tables, views, stored procedures, and triggers within the database management system based on the data model specifications.
10. Develop and maintain database standards and procedures: contribute to establishing data management standards and procedures within the organization to ensure consistent data practices.
11. Communication and Collaboration:
12. 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.
13. 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.