Erwin Data Modeler for Enterprise Oracle/SQL Server

Colaberry; Dallas (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Colaberry is seeking a Data Modeler to design and implement enterprise data models using Erwin Data Modeler. You will translate business requirements into scalable models, ensure normalization and data integrity, and collaborate with DBAs and ETL teams.

You will also optimize DDL, perform forward/reverse engineering on Oracle and SQL Server, and contribute to data governance and metadata initiatives. Strong SQL and communication skills required.

Qualifications

• 3+ years of hands-on data modeling experience in enterprise environments.
• Expert proficiency with Erwin Data Modeler (version 9.x or higher).
• Advanced SQL skills with Oracle and SQL Server.
• Strong DDL knowledge and database internals (indexing, partitioning).
• Experience with normalization, SCD, and data vault is a plus.
• Familiarity with version control and model comparison tools (Git).
• Excellent communication, ability to document models clearly.

Responsibilities

• Design and develop conceptual, logical, and physical data models using erwin Data Modeler (required).
• Generate, review, and optimize DDL scripts for database objects (tables, views, indexes, constraints, etc.).
• Perform forward and reverse engineering of data models from existing Oracle and SQL Server databases.
• Collaborate with data architects, DBAs, ETL developers, and business stakeholders to gather requirements.
• Ensure data models adhere to normalization standards (3NF/BCNF) and data integrity.
• Support dimensional modeling for data warehousing and analytics use cases.
• Conduct model reviews, impact analysis, and version control using erwin or comparable tools.
• Participate in data governance initiatives, including metadata management and lineage documentation.
• Optimize models for performance, scalability, and maintainability across large-scale environments.
• Assist in migrations, schema comparisons, and synchronization between Dev/QA/Prod environments.
• Assist in optimizing existing Data Solutions.
• Follow Oncor's Data Governance Policy and Information Classification and Protection Policy.
• Participate in design reviews with Data Architecture team.

Skills

Erwin Data Modeler

Oracle

SQL Server

3+ years data modeling

Normalization 3NF/BCNF

Data governance

SCD & Data Vault

Git

Communication

Tools

Erwin Data Modeler

Git

Job description

Colaberry is seeking a Data Modeler to design and implement enterprise data models using Erwin Data Modeler. You will translate business requirements into scalable models, ensure normalization and data integrity, and collaborate with DBAs and ETL teams.

You will also optimize DDL, perform forward/reverse engineering on Oracle and SQL Server, and contribute to data governance and metadata initiatives. Strong SQL and communication skills required.