Remote Data Modeler: Erwin Expert for Oracle/SQL

Valiant Technologies LLC

Dallas (TX)

Remote

USD 90,000 - 120,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Valiant Technologies LLC is seeking a Data Modeler to design, develop, and maintain enterprise data models supporting analytics and operational systems.

The ideal candidate will master erwin Data Modeler and have deep experience with Oracle and SQL Server, translating complex business requirements into scalable data models while aligning with governance, performance, and integration standards. The role emphasizes collaboration with data architects, DBAs, ETL developers, and business stakeholders.

Qualifications

  • 3+ years of hands-on data modeling experience in enterprise environments.
  • Expert proficiency with Erwin Data Modeler (version 9.x or higher) – 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

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, 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 proficiency
Data governance

Tools

Erwin Data Modeler
Git

Job description

Valiant Technologies LLC is seeking a Data Modeler to design, develop, and maintain enterprise data models supporting analytics and operational systems.

The ideal candidate will master erwin Data Modeler and have deep experience with Oracle and SQL Server, translating complex business requirements into scalable data models while aligning with governance, performance, and integration standards. The role emphasizes collaboration with data architects, DBAs, ETL developers, and business stakeholders.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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

Robotic Process Automation LLC • Dallas (TX)

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

CloudBigD • Dallas (TX)

Remote
USD 63,000 - 105,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
Senior Data Modeler: Oracle & ERwin Expert
Senior Data Modeler: Oracle & ERwin Expert

Quantum Technologies. LLC • Houston (TX)

On-site
USD 76,000 - 108,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
Data Modeler
Data Modeler

Peyton Resource Group • Dallas (TX)

On-site
USD 110,000 - 140,000