Senior Data Modeler: ERwin Expert & Dimensional Modeling

Computer Task Group; Dallas (TX); On-site; USD 85,000 - 120,000; Full time

Job summary

CTG is seeking a Senior Data Modeler for our client in Dallas, TX to design and maintain enterprise data models supporting analytics and governance. The role requires expertise in 3NF transactional and dimensional modeling, ERwin Data Modeler, and advanced SQL/Oracle.

You’ll collaborate with DBAs, developers, and business stakeholders to ensure scalable, compliant data architecture. Duration is 5 months, with a focus on delivering robust data models, documentation, and data lineage across core

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Management, or related field.
• 5+ years in data modeling, data architecture or database design.
• Experience with Oracle 11g/12c/19c/21c and relational/dimensional modeling.
• Knowledge of data dictionaries, metadata, and data lineage documentation.
• Proficiency with Erwin Data Modeler and SQL/PLSQL; familiarity with Git.

Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models.
• Build 3NF transactional and dimensional models including star/snowflake schemas.
• Use Erwin Data Modeler to manage subject areas, DDL, and versioning.
• Develop and maintain database structures: tables, indexes, constraints, sequences.
• Evaluate designs for performance, scalability, and data integrity.
• Apply normalization, denormalization, surrogate keys, and SCDs.
• Maintain data dictionaries, metadata, and data lineage documentation.
• Collaborate with DBAs, developers, architects, and business stakeholders.

Skills

Erwin Data Modeler

SQL & Oracle

Relational & Dimensional modeling

Database internals

Git

Communication & collaboration

Self-motivation & adaptability

Education

Bachelor's degree in Computer Science or related field

Tools

ER/Studio

PowerDesigner

Collibra

Alation

Oracle Cloud

AWS

Azure

Snowflake

Databricks

Job description

CTG is seeking a Senior Data Modeler for our client in Dallas, TX to design and maintain enterprise data models supporting analytics and governance. The role requires expertise in 3NF transactional and dimensional modeling, ERwin Data Modeler, and advanced SQL/Oracle.

You’ll collaborate with DBAs, developers, and business stakeholders to ensure scalable, compliant data architecture. Duration is 5 months, with a focus on delivering robust data models, documentation, and data lineage across core