Quick overview
SeniorityMid Senior
Work modeHybrid
LocationDallas, TX, United States
MongoDBOraclePL/SQLSQLAWSETLSnowflakeDatabricksHadoopVaultAzureSQL Server
Job description
Position - Data Engineer - Data Modeling
Location - Dallas, TX
Experience - 5+ Years
Type - W2 Contract
Job Description -
- 5 or more years of hands-on experience in data modeling, data architecture, or database design roles.
- Expert proficiency with Erwin Data Modeler (version 9.x or higher preferred) - including subject areas, model templates, DDL generation, forward/reverse engineering, model versioning, and complete compare functionality.
- Advanced SQL skills and deep understanding of Oracle (11g/12c/19c/21c) including SQL, PL/SQL, schema design, and performance tuning fundamentals as they relate to data model design.
- Demonstrated experience building both normalized (3NF) transactional models and dimensional models (star/snowflake) for reporting and analytics.
- Strong command of DDL - creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views.
- We are seeking a Data Modeler with deep expertise in Oracle database platforms and Erwin data modeling to design, govern, and evolve enterprise data models that support mission-critical business processes. This role is responsible for translating business and analytical requirements into robust conceptual, logical, and physical data models, and for ensuring those models are implemented consistently across our Oracle environments.
Key Responsibilities
- Primary responsibilities of the Data Modeler include designing, developing, and maintaining enterprise grade data models that support critical business initiatives, analytics, and operational systems.
Nice to have skills:
- Experience in a regulated industry (utilities, financial services, insurance, healthcare) with associated data governance and compliance requirements.
- Familiarity with additional modeling or metadata tools (e.g., ER/Studio, PowerDesigner, Collibra, Alation).
- Exposure to cloud data platforms (e.g., Oracle Cloud, AWS, Azure, Snowflake, Databricks) and hybrid on-prem/cloud modeling scenarios.
- Working knowledge of ETL/ELT tools and data integration patterns.
- Experience supporting master data management (MDM) or data governance initiatives.
- Experience working with Microsoft SQL Server
- Experience working with PostGres
- Data vault experience
- Experience with Hadoop/MongoDB
Similar jobs
- RC
Data Engineering Intern - Summer 2027Recently posted Auto Apply
Raft Company Website · McLean · Hybrid 🇺🇸
OnboardingSQLGit+4$20 - $24/hr - MA

Staff Data Engineer, Core MigrationsRecently posted Auto Apply
Machinify · Remote - US · Remote 🇺🇸
SQLT-SQLApache Spark+7Technology$230k - $260k/yr - AL
Senior Data EngineerRecently posted Auto Apply
Absentia Labs · San Francisco · Hybrid 🇺🇸
DockerGCPGit+8TechnologySalary not listed - AL
Senior Data EngineerRecently posted Auto Apply
ALO · Beverly Hills LAND · Hybrid 🇺🇸
GCPSQLAWS+8Technology$140k - $180k/yr - AL
Lead Data EngineerRecently posted Auto Apply
ALO · Beverly Hills LAND · Hybrid 🇺🇸
GCPSQLAWS+10Technology$180k - $220k/yr - RE

Data Engineer
Redhorse Corporation · Arlington, VA · Hybrid 🇺🇸
Apache SparkAWSETL+4TechnologySalary not listed - EC
AI/ML Data Engineer II with Security ClearanceRecently posted
ECS · maxwell airforce base, AL · Hybrid 🇺🇸
MLOpsNLPPythonTechnology$108k - $120k/yr - RH

Data EngineerRecently posted
Robert Half · Campbell, CA · Hybrid 🇺🇸
GitETLSnowflake+2TechnologySalary not listed - SC

Operations Data Engineering AnalystRecently posted Auto Apply
Southern Company · Birmingham · Hybrid 🇺🇸
OnboardingSQLMicrosoft Excel+11Salary not listed - CG
Data Engineer with Security ClearanceRecently posted
Contact Government Services, LLC · New York, NY · Hybrid 🇺🇸
SQLShellGit+10Technology$112.6k - $152.8k/yr - CG
Sr. Data Engineer with Security ClearanceRecently posted
Contact Government Services, LLC · Albany, NY · Hybrid 🇺🇸
SQLShellGit+10Technology$144.8k - $209.1k/yr - TH

Data Engineer Intern – Summer 2027 – Onsite in Dallas, TXRecently posted Auto Apply
Tenet Healthcare Corporation · Dallas · On-site 🇺🇸
SQLGoogle CloudHive+1TechnologySalary not listed
