Remote Data Modeler (Erwin) - Oracle/SQL Server Expert

Ethereum Technologies LLC

Dallas (TX)

Remote

USD 96,000 - 124,000

Full time

2 days 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

Ethereum Technologies is seeking a Data Modeler to design and maintain enterprise data models using erwin Data Modeler, focusing on Oracle and SQL Server environments. You will generate DDL, perform forward/reverse engineering, and collaborate with DBAs and ETL teams to ensure data integrity and scalable structures.

Responsibilities include normalization, SCD concepts, and supporting data governance initiatives, with a strong emphasis on performance tuning and large-scale deployments.

Qualifications

  • 3+ years of hands-on data modeling experience in enterprise environments.
  • Erwin Data Modeler (version 9.x or higher) proficiency including templates and DDL generation.
  • Advanced SQL skills with Oracle (11g/12c/19c/21c) and Microsoft SQL Server (2016+).
  • Strong command of DDL—creating/modifying tables, indexes, constraints, sequences, synonyms, and materialized views.
  • Solid grasp of database internals: indexing, partitioning, clustering, and query plans.
  • Experience with data modeling best practices: normalization, denormalization, surrogate keys, SCD, and data vault (a plus).
  • Familiarity with Git and model diff tools.
  • Capable of presenting to all levels; 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 scripts for database objects (tables, views, indexes, constraints, partitions).
  • Perform forward and reverse engineering of data models from Oracle and SQL Server databases.
  • Collaborate with data architects, DBAs, ETL developers, and stakeholders to refine requirements.
  • Ensure models adhere to normalization, data integrity, and referential integrity.
  • Support dimensional modeling for data warehousing and analytics use cases.
  • Conduct model reviews, impact analysis, and version control using erwin or compatible tools.
  • Participate in data governance initiatives including metadata, naming standards, and lineage.
  • Optimize models for performance and maintainability across large-scale environments.
  • Assist in migrations, schema comparisons, and synchronization across environments (Dev/QA/Prod).
  • Follow Oncor’s Data Governance Policy and Information Classification and Protection Policy.
  • Participate in design reviews and take guidance from Data Architecture team.

Skills

Advanced SQL
Oracle DB knowledge
MS SQL Server knowledge
Data modeling
DDL scripting
Normalization / SCD / Data Vault
Performance tuning
Git / version control

Tools

Erwin Data Modeler 9.x
Git
MongoDB / Hadoop

Job description

Ethereum Technologies is seeking a Data Modeler to design and maintain enterprise data models using erwin Data Modeler, focusing on Oracle and SQL Server environments. You will generate DDL, perform forward/reverse engineering, and collaborate with DBAs and ETL teams to ensure data integrity and scalable structures.

Responsibilities include normalization, SCD concepts, and supporting data governance initiatives, with a strong emphasis on performance tuning and large-scale deployments.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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
Remote Data Modeler - Erwin Expert for Oracle/SQL Server
Remote Data Modeler - Erwin Expert for Oracle/SQL Server

Robotic Process Automation LLC • Dallas (TX)

Remote
USD 96,000 - 124,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
Data Modeler (Erwin) — Oracle/SQL Server Architect
Data Modeler (Erwin) — Oracle/SQL Server Architect

CloudBigD • Dallas (TX)

Remote
USD 63,000 - 105,000
Senior Oracle Data Modeler (Erwin Expert)
Senior Oracle Data Modeler (Erwin Expert)

Peyton Resource Group • Dallas (TX)

On-site
USD 110,000 - 140,000
Senior Data Modeler - Erwin Expert (Oracle/SQL) Hybrid
Senior Data Modeler - Erwin Expert (Oracle/SQL) Hybrid

Amatriot Group • Dallas (TX)

Hybrid
USD 135,000 - 175,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
Senior Data Modeler (ERwin) – Oracle/SQL, On-Site Columbia
Senior Data Modeler (ERwin) – Oracle/SQL, On-Site Columbia

Focused HR Solutions, LLC • West Columbia (SC)

On-site
USD 90,000 - 120,000
Senior Data Modeler (Erwin) — Oracle, Onsite Houston
Senior Data Modeler (Erwin) — Oracle, Onsite Houston

Robotics Technologies • Houston (TX)

On-site
USD 76,000 - 108,000
Senior Data Modeler - Oracle & Erwin Expert (Houston)
Senior Data Modeler - Oracle & Erwin Expert (Houston)

Valiant Technologies LLC • Houston (TX)

On-site
USD 76,000 - 108,000