Data Modeler

Dallas, TX, US • Posted 2 hours ago • Updated 2 hours ago
Full Time
On-site
Fitment

Dice Job Match Score™

🤯 Applying directly to the forehead...

Job Details

Skills

  • Business Analytics
  • Scripting
  • Reverse Engineering
  • Collaboration
  • Extract
  • Transform
  • Load
  • Dimensional Modeling
  • Data Warehouse
  • Analytics
  • Impact Analysis
  • Version Control
  • Meta-data Management
  • Scalability
  • Migration
  • ERwin
  • SQL
  • Oracle
  • Microsoft SQL Server
  • DDL
  • Database
  • Data Modeling
  • Normalization
  • Communication
  • Documentation
  • Presentations
  • Management
  • Snow Flake Schema
  • SCD
  • Git
  • Apache Hadoop
  • MongoDB
  • Data Governance
  • Art

Summary

Job Description

Role: Data Modeler
Location: Dallas TX - Hybrid 2-3 days onsite
Employment Type: 6 Months +

Overview
We're seeking an experienced Data Modeler to design and maintain enterprise data models supporting critical business, analytics, and operational systems. The ideal candidate will have strong erwin Data Modeler, Oracle, and SQL Server experience.

Key Responsibilities
  • Design conceptual, logical, and physical data models using erwin Data Modeler.
  • Create, review, and optimize DDL scripts for database objects.
  • Perform forward and reverse engineering of Oracle and SQL Server databases.
  • Translate business requirements into scalable, normalized data models.
  • Collaborate with Data Architects, DBAs, ETL Developers, and business stakeholders.
  • Support dimensional modeling for data warehousing and analytics.
  • Conduct model reviews, impact analysis, and version control.
  • Support data governance, metadata, naming standards, and lineage documentation.
  • Optimize data models for performance, scalability, and maintainability.
  • Support database migrations, schema comparisons, and environment synchronization.

Required Qualifications:
  • 10+ years of enterprise data modeling experience.
  • Must have hands-on expertise with erwin Data Modeler (required).
  • Must have advanced SQL skills with strong Oracle and Microsoft SQL Server experience.
  • Must have strong knowledge of DDL, tables, indexes, constraints, sequences, synonyms, and views.
  • Must have understanding of database performance, indexing, partitioning, and query execution plans.
  • Must have experience with data modeling best practices, including normalization and denormalization.
  • Strong communication, documentation, and presentation skills.
  • Ability to manage multiple priorities and work effectively with technical and business teams.

Preferred Qualifications:
  • Experience with Star/Snowflake schemas, SCD, or Data Vault.
  • Experience with Git or model comparison/diff tools.
  • Hadoop or MongoDB experience.
  • Experience supporting data governance and architecture initiatives.

Meet Your Recruiter

Khalid Vaani

About Dallas, TX

Unlock your potential in the vibrant job market of the Dallas-Fort Worth metroplex! This bustling region in the great state of Texas boasts a perfect blend of southern charm and big-city opportunities. Dive into a dynamic career scene with access to renowned landmarks like the Dallas Arboretum and Botanical Garden, exquisite cuisine from Tex-Mex to BBQ, and cultural hotspots such as the Dallas Museum of Art and the AT&T Performing Arts Center. Cheer for the Dallas Cowboys at the AT&T Stadium or enjoy the outdoors at White Rock Lake. Discover why Dallas is the ultimate destination for growth, opportunity, and a fulfilling career journey. Explore our job listings today and embark on a new chapter in this captivating city!
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: bravo
  • Position Id: 76b533734717512ba093b939720c0482
  • Posted 2 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Dallas, Texas

4d ago

Contract

Depends on Experience

Hybrid in Dallas, Texas

7d ago

Easy Apply

Full-time

80 - 85

Dallas, Texas

8d ago

Easy Apply

Contract

50 - 60

Plano, Texas

Today

Full-time

Search all similar jobs