Senior Data Modeler

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 to fill a Senior Data Modeler position for our client.

Location: Dallas, TX
Duration: 5 Months

Duties:

• Design, develop, and maintain conceptual, logical, and physical data models to support 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, model templates, DDL generation, forward/reverse engineering, model versioning, and model comparisons.
• Develop and maintain database structures, including tables, indexes, constraints, sequences, synonyms, and materialized views.
• Evaluate database designs and recommend improvements for 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.

Skills:

• Expert proficiency with Erwin Data Modeler, version 9.x or higher 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, with the ability to explain technical concepts to diverse audiences.
• Self-motivated, adaptable, and able to manage multiple priorities while working effectively in a team environment.

Experience:

• 5 or more 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.

Preferred Qualifications:

• 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.

Education:

• Bachelor's degree in Computer Science, Information Systems, Data Management, or a related field preferred, or equivalent professional experience.

Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.

CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee based recruitment services for this role.

About CTG

CTG, a Cegeka company, delivers IT and business solutions that enhance clients’ digital agility, empowering them to seize new opportunities and overcome any challenge. Backed by more than 60 years’ experience and a commitment to being a reliable, results-driven partner, we work shoulder to shoulder with clients to shape digital together. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. With more than 9,000 team members in over 15 countries, we combine global expertise with local insight to deliver innovative solutions. We operate across the Americas, Europe, and India, working with over 3,000 clients in many of today's highest-growth industries.

Together, we shape what’s next—working shoulder to shoulder to deliver impactful solutions for our clients and society. Our culture is built by the people who work at CTG, the values we hold, and the actions we take. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. At CTG, you’ll find a workplace where you are encouraged to grow, supported in your ambitions, and empowered to shape your own career journey. For more information, visit www.ctg.com.

CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.

CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.