Senior Data Modeler

Cynet Systems • Dallas, TX

3d

About The Position

The Senior Data Modeler will use hands-on experience in data modeling, data architecture, or database design to create and maintain transactional and analytical data models. The role requires advanced use of Erwin Data Modeler and Oracle, along with expertise in SQL, DDL, database design principles, and database performance fundamentals. The modeler will also maintain data dictionaries, metadata, and lineage documentation, and explain modeling decisions to technical and non-technical audiences.

Requirements

• At least 5 years of hands-on experience in data modeling, data architecture, or database design roles.
• Expert proficiency with Erwin Data Modeler; version 9.x or higher is preferred.
• Advanced SQL skills and deep understanding of Oracle 11g, 12c, 19c, or 21c, including SQL, PL/SQL, and schema design.
• Strong command of DDL for creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views.
• Understanding of entity-relationship modeling, normalization and denormalization, cardinality, keys, and referential integrity.
• Understanding of indexing strategies, partitioning, clustering, and query execution plans.
• Knowledge of modeling best practices, including surrogate keys and slowly changing dimensions.
• Familiarity with version control such as Git and model comparison or diff tools.
• Excellent communication skills for explaining modeling decisions to technical and non-technical audiences.
• Self-motivation, ability to multitask, and ability to work effectively in a team environment.

Nice To Haves

• Experience in a regulated industry such as utilities, financial services, insurance, or healthcare, including associated data governance and compliance requirements.
• Familiarity with other modeling or metadata tools such as ER/Studio, PowerDesigner, Collibra, or Alation.
• Exposure to cloud data platforms such as Oracle Cloud, AWS, Azure, Snowflake, or Databricks, and hybrid on-premises/cloud modeling scenarios.
• Working knowledge of ETL/ELT tools and data integration patterns.
• Experience supporting master data management (MDM) or data governance initiatives.
• Experience with Microsoft SQL Server.
• Experience with PostgreSQL.
• Data vault experience.
• Experience with Hadoop or MongoDB.

Responsibilities

• Build normalized (3NF) transactional models and dimensional models (star/snowflake) for reporting and analytics.
• Use Erwin Data Modeler for subject areas, model templates, DDL generation, forward and reverse engineering, model versioning, and compare functionality.
• Use SQL and Oracle capabilities, including SQL, PL/SQL, schema design, and performance-tuning fundamentals as they relate to data model design.
• Create and modify database objects using DDL, including tables, indexes, constraints, sequences, synonyms, and materialized views.
• Apply data modeling theory and practices, including entity-relationship modeling, normalization and denormalization, cardinality, keys, referential integrity, surrogate keys, and slowly changing dimensions.
• Apply knowledge of database internals, including indexing strategies, partitioning, clustering, and query execution plans.
• Produce and maintain data dictionaries, metadata, and data lineage documentation.
• Explain modeling decisions clearly to technical and non-technical audiences.
• Multitask, work independently, and contribute effectively in a team environment.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed