
Data Modeler
Steneral Consulting · Dallas, TX, United States · Hybrid
Weak hiring record · median 125 days open
- First seen
- 13 November 2026
- Reposted
- Once since September 2026
- Last checked
- Today · still on the employer's board
All reasons
- 77% of this employer's openings are over 60 days old
In its favour
- Posted 3 days ago
- Still listed on the employer's own board
- Publishes a salary range
Job Title - Data Modeler
Type - Hybrid
Location - Dallas, TX
Please send only local candidates
No fabricated resume here
Description -
We are seeking an experienced Data Modeler with strong expertise in Oracle databases and Erwin Data Modeler to design, develop, and maintain enterprise-level data models. The ideal candidate will have hands-on experience developing conceptual, logical, and physical data models, building normalized and dimensional data structures, and supporting enterprise data architecture initiatives.
The candidate will work closely with data architects, DBAs, ETL developers, business analysts, and application teams to translate business requirements into scalable, efficient, and well-governed database designs.
Key Responsibilities
- Design, develop, and maintain conceptual, logical, and physical data models using Erwin Data Modeler.
- Build and manage Oracle database schemas, including tables, views, indexes, constraints, sequences, and partitions.
- Perform forward and reverse engineering of database structures using Erwin.
- Develop normalized (3NF) transactional models and dimensional models using Star and Snowflake schemas.
- Generate, review, and optimize DDL scripts for Oracle database implementation.
- Work with DBAs and development teams to ensure data integrity, referential integrity, and database performance.
- Establish and maintain data modeling standards, naming conventions, metadata, and documentation.
- Perform model comparisons, version management, model merges, and impact assessments for schema changes.
- Develop and maintain data dictionaries, ER diagrams, business glossaries, and data lineage documentation.
- Apply data modeling best practices, including normalization, denormalization, surrogate keys, and Slowly Changing Dimensions (SCD).
- Support database migrations, schema synchronization, and deployments across Dev, QA, and Production environments.
- Collaborate with cross-functional teams to gather requirements and ensure alignment with enterprise data architecture and governance standards.
Required Qualifications
- 5+ years of hands-on experience in data modeling, data architecture, or database design.
- Strong hands-on expertise with Erwin Data Modeler (9.x or higher).
- Experience with Erwin subject areas, model templates, forward/reverse engineering, DDL generation, model versioning, and model comparison.
- Advanced SQL skills and strong knowledge of Oracle databases (11g, 12c, 19c, or 21c).
- Experience with Oracle schema design, PL/SQL, and DDL development.
- Strong understanding of relational database design, entity-relationship modeling, normalization (3NF), keys, cardinality, and referential integrity.
- Experience developing both OLTP and OLAP/data warehouse models.
- Hands-on experience with Star and Snowflake schemas, fact tables, dimensions, and Slowly Changing Dimensions (SCD).
- Strong understanding of primary keys, foreign keys, surrogate keys, indexing, and partitioning.
- Experience creating and maintaining data dictionaries, metadata, and data lineage documentation.
- Familiarity with Git or other version control and model comparison tools.
- Excellent communication, analytical, and problem-solving skills.
- Experience in regulated industries such as utilities, financial services, insurance, or healthcare.
Preferred Qualifications
- Experience with Microsoft SQL Server and PostgreSQL.
- Familiarity with data 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.
- Knowledge of ETL/ELT processes and data integration patterns.
- Experience with Master Data Management (MDM) and data governance initiatives.
- Experience with Data Vault modeling.
- Exposure to Hadoop and MongoDB.
Work Location
Dallas, TX – Hybrid schedule requiring 2–3 days onsite per week.
Note
Candidates must be local to the Dallas, TX area and available to work onsite as required.
Skills
- Oracle Database
- ETL
- Snowflake
- SQL
- PL/SQL
- Git
- SQL Server
- PostgreSQL
- Oracle Cloud
- AWS
- Azure
- Databricks
- ELT
- HashiCorp Vault
- Hadoop
- MongoDB
More jobs at Steneral Consulting
All 5,627- Viewpoint Vista ERP AnalystSteneral Consulting · Remote · USD 60–65/hr3d ago
- Maximo Full Stack Developer-2397Steneral Consulting · Remote · USD 80–85/hr3d ago
- Sr. Security Analyst-2402Steneral Consulting · Manhattan, NY, United States · USD 75–80/hr3d ago
- Senior Java DeveloperSteneral Consulting · Plano, TX, United States · USD 70–75/hr3d ago
- Mainframe Systems Programmer -localsSteneral Consulting · Remote · USD 80–85/hr3d ago
Similar roles
- Semantic Data ModelerHomeServe · Norwalk, CT, United States · USD 101,151–134,868/yr2d ago
- Machine Learning & Data Engineer, Vehicle Modeling42dot · Sunnyvale, United States2d ago
- Senior Data Architect (SDA)Genesis10 · Dallas, TX · USD 85–100/hr2d ago
- Senior Snowflake Data Modeler & AI Platform EngineerDiverse Lynx · New york · USD 75–77/hr2d ago
- Data and Analytics EngineerNimble Gravity · LATAM · UStoday
- Data ScientistSPGI · New York, NY · USD 90,000–150,000/yr2d ago