Senior Data Modeler

Computer Task Group, Inc; Dallas (TX); Presencial; USD 120.000 - 150.000; Jornada completa

Descripción de la vacante

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.

Formación

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

Responsabilidades

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

Conocimientos

Erwin Data Modeler

SQL

Oracle DB

Dimensional modeling

3NF modeling

SCD (Slowly Changing Dimensions)

Data governance

Git/version control

Communication

Educación

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

Herramientas

Erwin Data Modeler (v9.x+)

ER/Studio

PowerDesigner

Collibra

Alation

Descripción del empleo

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