Data Modeler (Erwin) — Oracle/SQL Server Architect

CloudBigD

Dallas (TX)

Remote

USD 63,000 - 105,000

Full time

33 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

CloudBigD is seeking a Data Modeler in Dallas, TX to design, develop, and maintain enterprise data models supporting analytics and operations. Proficiency with erwin Data Modeler and strong Oracle/SQL Server experience are essential.

You will translate business requirements into normalized data models, contribute to governance, and collaborate with architects, DBAs, ETL teams, and stakeholders to ensure scalable, high‑quality data solutions.

Qualifications

  • 3+ years of hands-on data modeling in enterprise environments.
  • Expert with Erwin Data Modeler (v9.x+), including templates and DDL generation.
  • Advanced SQL; expertise in Oracle (11g/12c/19c/21c) and SQL Server (2016+).
  • Strong knowledge of DDL, creating/modifying tables, indexes, constraints, sequences, synonyms, and materialized views.
  • Solid grasp of database internals: indexing, partitioning, clustering, and query execution plans.
  • Experience with data modeling best practices: normalization, denormalization, surrogate keys, slowly changing dimensions (SCD), and data vault (a plus).
  • Familiarity with version control (e.g., Git) and model comparison/diff tools.
  • Experience with Hadoop/MongoDB a plus.

Responsibilities

  • Design and develop conceptual, logical, and physical data models using erwin Data Modeler (required).
  • Generate, review, and optimize DDL (Data Definition Language) scripts for database objects (tables, views, indexes, constraints, partitions, etc.).
  • Perform forward and reverse engineering of data models from existing Oracle and SQL Server databases.
  • Collaborate with data architects, DBAs, ETL developers, and business stakeholders to gather and refine requirements.
  • Ensure data models adhere to normalization standards (3NF/BCNF), data integrity, and referential integrity.
  • Support dimensional modeling (star/snowflake schemas) for data warehousing and analytics use cases.
  • Conduct model reviews, impact analysis, and version control using erwin or comparable tools.
  • Participate in data governance initiatives, including metadata management, naming standards, and lineage documentation.
  • Optimize models for performance, scalability, and maintainability across large‑scale environments.
  • Assist in database migrations, schema comparisons, and synchronization between environments (Dev/QA/Prod).
  • Assist in optimizing existing Data Solutions
  • Follow Oncor’s Data Governance Policy and Information Classification and Protection Policy.
  • Participate in design reviews and take guidance from the Data Architecture team members.

Skills

Data modeling
SQL
Normalization
Governance awareness
Hadoop/MongoDB (plus)

Tools

Erwin Data Modeler
Git
Model comparison/diff tools
Hadoop
MongoDB

Job description

CloudBigD is seeking a Data Modeler in Dallas, TX to design, develop, and maintain enterprise data models supporting analytics and operations. Proficiency with erwin Data Modeler and strong Oracle/SQL Server experience are essential.

You will translate business requirements into normalized data models, contribute to governance, and collaborate with architects, DBAs, ETL teams, and stakeholders to ensure scalable, high‑quality data solutions.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Modeler: Erwin–Driven Data Architect
Senior Data Modeler: Erwin–Driven Data Architect

Computer Task Group • Dallas (TX)

On-site
USD 120,000 - 150,000
Erwin Data Modeler — Remote DW/Analytics Expert
Erwin Data Modeler — Remote DW/Analytics Expert

Quantum Technologies LLC • Dallas (TX)

Remote
USD 90,000 - 120,000
Erwin Data Modeler
Erwin Data Modeler

AppLab Systems, Inc • Dallas (TX)

On-site
USD 90,000 - 130,000
Data Modeler (Oracle & Erwin) - 10 Month Engagement
Data Modeler (Oracle & Erwin) - 10 Month Engagement

Ethereum Technologies • Houston (TX)

On-site
USD 76,000 - 108,000
Remote Data Modeler (Erwin) - Oracle/SQL Server Expert
Remote Data Modeler (Erwin) - Oracle/SQL Server Expert

Ethereum Technologies LLC • Dallas (TX)

Remote
USD 96,000 - 124,000
Remote Data Modeler: Erwin Expert for Oracle/SQL
Remote Data Modeler: Erwin Expert for Oracle/SQL

Valiant Technologies LLC • Dallas (TX)

Remote
USD 90,000 - 120,000
Erwin Data Modeler — Onsite Dallas
Erwin Data Modeler — Onsite Dallas

AppLab Systems, Inc • Dallas (TX)

On-site
USD 90,000 - 130,000
Data Modeler
Data Modeler

CloudBigD • Dallas (TX)

Remote
USD 63,000 - 105,000
Data Modeler
Data Modeler

Valiant Technologies LLC • Dallas (TX)

Remote
USD 90,000 - 120,000
Data Modeler
Data Modeler

Quantum Technologies LLC • Dallas (TX)

Remote
USD 90,000 - 120,000