Data Modeler

Ethereum Technologies LLC

Dallas (TX)

Remote

USD 96,000 - 124,000

Full time

23 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

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

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

  • Job Title: Data Modeler
  • Location: Dallas, TX(Remote)
  • Duration: 24 Months + Extension
  • Bill Rate: $76/hour (C2C)
  • Job Type: W-2, 1099, C2C
  • Client: To Be Discussed Later
  • Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other
Job Description

Primary responsibilities of the Data Modeler include designing, developing, and maintaining enterprise-grade data models that support critical business initiatives, analytics, and operational systems. The ideal candidate is proficient in industry-standard data modeling tools (with hands‑on expertise in erwin Data Modeler) and has deep experience with Oracle and SQL Server databases. The candidate will also translate complex business requirements into robust, scalable, and normalized data models while ensuring alignment with data governance, performance, and integration standards.

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.
Qualifications
  • 3+ years of hands‑on data modeling experience in enterprise environments.
  • Expert proficiency with Erwin Data Modeler (version 9.x or higher preferred) – including subject areas, model templates, and DDL generation.
  • Advanced SQL skills and deep understanding of Oracle (11g/12c/19c/21c) and Microsoft SQL Server (2016+).
  • Strong command of DDL – creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views.
  • Solid grasp of database internals: indexing strategies, 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.
  • Capable of presenting to all levels of audiences Experience with Hadoop/MongoDB a plus

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Modeler
Data Modeler

Robotic Process Automation LLC • Dallas (TX)

Remote
USD 96,000 - 124,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
Data Engineer - Data Modeler
Data Engineer - Data Modeler

Valiant Technologies LLC • Houston (TX)

On-site
USD 76,000 - 108,000
Data Engineer - Data Modeler
Data Engineer - Data Modeler

Ethereum Technologies LLC • Houston (TX)

On-site
USD 76,000 - 108,000
Data Engineer - Data Modeler
Data Engineer - Data Modeler

Quantum Technologies LLC • Houston (TX)

On-site
USD 76,000 - 108,000
Erwin Data Modeler
Erwin Data Modeler

AppLab Systems, Inc • Dallas (TX)

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

Quantum Technologies LLC • New York (NY)

On-site
USD 110,000 - 150,000
Data Modeler
Data Modeler

Robotics Technologies LLC • New York (NY)

On-site
USD 120,000 - 170,000
Data Modeler
Data Modeler

Robotic Process Automation LLC • New York (NY)

On-site
USD 120,000 - 190,000