JobHabor
Menu

Data Modeler

Steneral Consulting · Dallas, TX, United States · Hybrid

Weak hiring record · median 125 days open

100100

Hiring signal

Actively hiring

Open 3 days · Reposted once · Checked today · How we score

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

Did you apply?

Data Modeler at Steneral Consulting. We’ll keep it in your applied jobs, so you can see it later and be warned before applying to the same employer twice.

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.

More jobs at Steneral Consulting

All 5,627

Similar roles