> Markdown version of [/jobs/ext/4620572-data-modeler-local-to-tx-only](https://www.wearedevelopers.com/jobs/ext/4620572-data-modeler-local-to-tx-only). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Modeler- Local to TX Only

- **Company:** Drunix Solution Inc
- **Location:** Dallas, TX, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Third Normal Form, Databases, Data Architecture, Data Dictionary, Data Integrity, Database Design, Metadata, Oracle Databases, Oracle (Applications), Performance Tuning, Reverse Engineering, PL-SQL, SQL Databases, Sql Optimization, Snowflake, Database Optimization, Git, Data Lineage, Software Version Control
- **Published:** November 7, 2026
- **Apply:** https://www.dice.com/job-detail/da64e785-1b10-469d-bbaa-c30e402fca96

## About the Role

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