Data Modeler- Local to TX Only

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