Senior Data Modeler

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: Bachelors 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. To Apply: To be considered please apply directly to this requisition using the link provided. Kindly forward this to any other interested parties. Thank you! 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 9000 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 3000 clients in many of todays highest-growth industries. Together we shape whats nextworking 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. Its a living breathing thing that is renewed every day through the ways we engage with each other our clients and our communities. At CTG youll 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 . 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.