Senior Data Modeler: Erwin–Driven Data Architect

Computer Task Group; Dallas (TX); In loco; USD 120.000 - 150.000; Tempo pieno

Descrizione del lavoro

CTG seeks a Senior Data Modeler in Dallas, TX to design and optimize enterprise data models and support analytics initiatives. The role focuses on conceptual, logical, and physical modeling, including 3NF and dimensional designs, using Erwin Data Modeler.

You will collaborate with DBAs, developers, and business stakeholders to ensure data models meet governance and performance standards. A strong Oracle background and excellent communication are required.

Competenze

• 5+ years of hands-on data modeling, architecture, or DB design.
• Experience with relational and dimensional data models and DDL development.
• Proficiency in Oracle versions (11g/12c/19c/21c).

Mansioni

• Design, develop, and maintain conceptual, logical, and physical data models.
• Build 3NF transactional and dimensional models (star/snowflake) for analytics.
• Use Erwin to manage subject areas, templates, DDL, and model comparisons.
• Collaborate with DBAs, developers, and stakeholders to translate requirements into data models.
• Ensure models align with governance, standards, and compliance.

Conoscenze

Erwin Data Modeler

SQL

Oracle DB

Dimensional modeling

3NF modeling

SCD (Slowly Changing Dimensions)

Data governance

Git/version control

Communication

Formazione

Bachelor's degree in CS/IS/Data Management or related

Strumenti

Erwin Data Modeler (v9.x+)

ER/Studio

PowerDesigner

Collibra

Alation

Descrizione del lavoro

CTG seeks a Senior Data Modeler in Dallas, TX to design and optimize enterprise data models and support analytics initiatives. The role focuses on conceptual, logical, and physical modeling, including 3NF and dimensional designs, using Erwin Data Modeler.

You will collaborate with DBAs, developers, and business stakeholders to ensure data models meet governance and performance standards. A strong Oracle background and excellent communication are required.