Role: Data Modeler
Location: Dallas, TX (Local to TX Only)
F2F Interview
Required skills:
5 or more 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 preferred) – including subject areas, model templates, DDL generation, forward/reverse engineering, model versioning, and complete compare functionality.
Advanced SQL skills and deep understanding of Oracle (11g/12c/19c/21c) including SQL, PL/SQL, schema design, and performance tuning fundamentals as they relate to data model design.
Demonstrated experience building both normalized (3NF) transactional models and dimensional models (star/snowflake) for reporting and analytics.
Strong command of DDL – creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views.
-Solid understanding of data modeling theory: entity-relationship modeling, normalization/denormalization, cardinality, keys, and referential integrity.
-Solid grasp of database internals: indexing strategies, partitioning, clustering, and query execution plans.
-Experience with data modeling best practices: normalization, denormalization, surrogate keys, and slowly changing dimensions (SCD)
-Experience producing and maintaining data dictionaries, metadata, and data lineage documentation.
-Familiarity with version control (e.g., Git) and model comparison/diff tools.
-Excellent communication skills with the ability to clearly explain modeling decisions to both technical and non-technical audiences.
-Self-Motivated, with an ability to multi-task
-Works well in a team environment
