Senior Data Modeler

Computer Task Group, Inc • Dallas, TX

3d

About The Position

CTG is seeking a Senior Data Modeler for a client assignment in Dallas, Texas, with a stated duration of five months. The role designs, develops, and maintains conceptual, logical, and physical data models that support enterprise data architecture and business requirements. It covers normalized transactional models and dimensional models for reporting and analytics, as well as the development and maintenance of database structures and documentation.

The position uses Erwin Data Modeler for model administration, DDL generation, engineering, versioning, and comparisons. It evaluates database designs and recommends improvements, applies modeling best practices, and collaborates with technical teams and business stakeholders to translate requirements into models aligned with enterprise standards, governance, and compliance practices.

A bachelor’s degree in a related field or equivalent professional experience is preferred. The role also requires excellent verbal and written English communication skills and professional interaction with diverse groups.

Requirements

• At least 5 years of hands-on experience in data modeling, data architecture, or database design.
• Demonstrated experience developing and maintaining relational and dimensional data models and database objects using DDL.
• Experience with Oracle 11g, 12c, 19c, and/or 21c.
• Experience maintaining data dictionaries, metadata, and data lineage documentation.
• Expert proficiency with Erwin Data Modeler; version 9.x or higher is preferred, including model administration, comparison, and DDL generation.
• Advanced SQL and Oracle database knowledge, including SQL, PL/SQL, schema design, and performance-tuning fundamentals.
• Strong understanding of relational and dimensional data modeling, including entity-relationship concepts, normalization, cardinality, keys, referential integrity, and database design principles.
• Knowledge of database internals, including indexing, partitioning, clustering, and query execution plans.
• Familiarity with version control tools such as Git and model comparison/diff tools.
• Excellent communication, analytical, and organizational skills, including the ability to explain technical concepts to diverse audiences.
• Self-motivated and adaptable, able to manage multiple priorities and work effectively in a team environment.
• Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group.

Nice To Haves

• Experience in a regulated industry such as utilities, financial services, insurance, or healthcare, with an understanding of data governance and compliance requirements.
• Familiarity with additional modeling and metadata tools such as ER/Studio, PowerDesigner, Collibra, or Alation.
• Exposure to cloud data platforms such as Oracle Cloud, AWS, Azure, Snowflake, or Databricks, including hybrid on-premises and cloud environments.
• Working knowledge of ETL/ELT tools and data integration patterns.
• Experience supporting Master Data Management (MDM) or enterprise data governance initiatives.
• Experience with Microsoft SQL Server, PostgreSQL, Hadoop, and/or MongoDB.
• Knowledge of Data Vault modeling methodologies.
• Bachelor’s degree in Computer Science, Information Systems, Data Management, or a related field, or equivalent professional experience.

Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models supporting enterprise data architecture and business requirements.
• Build normalized (3NF) transactional models and dimensional models, including star and snowflake schemas, for reporting and analytics.
• Use Erwin Data Modeler to manage subject areas and model templates; generate DDL; perform forward and reverse engineering; and manage model versions and comparisons.
• Develop and maintain database structures, including tables, indexes, constraints, sequences, synonyms, and materialized views.
• Evaluate database designs and recommend improvements to performance, scalability, data integrity, and maintainability.
• Apply data modeling best practices, including normalization, denormalization, surrogate keys, and slowly changing dimensions (SCD).
• Maintain data dictionaries, metadata, and data lineage documentation.
• Collaborate with database administrators, developers, architects, and business stakeholders to translate requirements into effective data models.
• Ensure data models align with enterprise standards, governance practices, and compliance requirements.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior