Senior Oracle Data Modeler (Erwin Data Modeler)

Dallas, TX, US • Posted 1 hour ago • Updated 1 hour ago
Contract Independent
Contract W2
12 Months
No Travel Required
On-site
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Oracle (11g/12c/19c/21c) including SQL
  • PL/SQL
  • schema design

Summary

Senior Oracle Data Modeler (Erwin Data Modeler)
Dallas TX

Required skills: 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 Client SQL Server Experience working with PostGres Data vault experience Experience with Hadoop/MongoDB

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 90614965
  • Position Id: 9134302
  • Posted 1 hour ago

Company Info

About Sagarsoft

Exemplary project management distinguishes Sagarsoft as a leading solutions provider. Customized execution methodologies blended with highly advanced engagement models help Sagarsoft spearhead Digital Transformation for its clients through globally interlinked software delivery modules. A thorough understanding of the client’s business processes coupled with a vast international experience comprising innumerable project cycles help achieve the desired results.

Each project of Sagarsoft is unique in its goals, delivery approach, technology impact, and business benefits. The innovative spirit of Team Sagarsoft has inspired the company to explore a broad range of domains and create a host of competencies. Employing best practices that ensure absolute customer delight, the company’s diverse portfolio keeps on increasing as more and more clients repose their trust on this unparalleled expertise. Internal process transformation just sails through with Sagarsoft!

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.