Peyton Resource Group
Data Modeler
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Modeler in Dallas, Texas, with a 6-month contract. Pay rate is competitive. Requires 3+ years of enterprise data modeling experience, expert proficiency with Erwin Data Modeler, and advanced SQL skills with Oracle and SQL Server.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
920
-
🗓️ - Date
December 3, 2025
🕒 - Duration
More than 6 months
-
🏝️ - Location
Hybrid
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Dallas, TX
-
🧠 - Skills detailed
#SQL Server #Vault #"ETL (Extract #Transform #Load)" #Clustering #Microsoft SQL #Data Integrity #Microsoft SQL Server #ERWin #Data Architecture #Hadoop #Migration #Documentation #Metadata #Data Vault #MongoDB #Scala #Indexing #Data Management #MS SQL (Microsoft SQL Server) #Data Modeling #Database Migration #Normalization #Physical Data Model #SQL (Structured Query Language) #Version Control #GIT #Oracle #Slowly Changing Dimensions #Data Governance #Databases #Snowflake
Role description
GREAT hybrid role in Dallas, Texas!!
6 month SOW!
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
• 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.
• Excellent communication skills – ability to document models clearly and present to technical and non-technical audiences.
• Self-Motivated, with an ability to multi-task
• Capable of presenting to all levels of audiences
• Works well in a team environment
• Experience with Hadoop/MongoDB a plus
GREAT hybrid role in Dallas, Texas!!
6 month SOW!
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
• 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.
• Excellent communication skills – ability to document models clearly and present to technical and non-technical audiences.
• Self-Motivated, with an ability to multi-task
• Capable of presenting to all levels of audiences
• Works well in a team environment
• Experience with Hadoop/MongoDB a plus
