Lead Data Modeler – Oracle / Erwin

Cbase Inc; Dallas (TX); Presencial; USD 90 000 - 150 000; Tempo integral

Resumo da oferta

Cbase Inc. is seeking an experienced Lead Data Modeler to design and govern enterprise data models using Erwin Data Modeler and Oracle databases. You will translate business needs into conceptual, logical, and physical models and ensure consistent implementation across Oracle environments.

The role requires hands-on experience with 3NF transactional models and dimensional designs, collaboration with stakeholders, and a focus on data governance and metadata management.

Qualificações

• 5+ years of hands-on experience in Data Modeling, Data Architecture, or Database Design.
• Strong proficiency with Erwin Data Modeler (Version 9.x or higher preferred).
• Strong experience with Oracle Database (11g/12c/19c/21c).
• Advanced SQL and PL/SQL skills.

Responsabilidades

• Design, develop, and maintain enterprise-grade conceptual, logical, and physical data models.
• Translate business and analytical requirements into scalable and efficient database designs.
• Use Erwin Data Modeler for subject areas, model templates, DDL generation, forward/reverse engineering, model versioning, and model comparisons.
• Design normalized (3NF) transactional models and dimensional models (Star/Snowflake schemas).
• Develop and maintain Oracle database objects, including tables, indexes, constraints, sequences, synonyms, and materialized views.
• Collaborate with business stakeholders, architects, developers, and data engineering teams.
• Support data governance, metadata management, and enterprise data architecture initiatives.

Conhecimentos

Data Modeling

Data Architecture

SQL/PLSQL

Requirements translation

Ferramentas

Erwin Data Modeler (v9.x+)

Oracle Database

Descrição da oferta de emprego

Work Mode: Onsite (Local Candidates Preferred)

Face-to-Face (F2F) interview is mandatory.

Only candidates who can attend the F2F interview should be considered.

Position Overview:

We are seeking an experienced Lead Data Modeler with strong expertise in Erwin Data Modeler and Oracle Database platforms to design, develop, govern, and maintain enterprise-level data models supporting mission-critical business applications and analytics.

The ideal candidate should have hands-on experience translating business and analytical requirements into conceptual, logical, and physical data models and ensuring consistent implementation across Oracle database environments.

Key Responsibilities:

• Design, develop, and maintain enterprise-grade conceptual, logical, and physical data models.
• Translate business and analytical requirements into scalable and efficient database designs.
• Use Erwin Data Modeler for subject areas, model templates, DDL generation, forward/reverse engineering, model versioning, and model comparisons.
• Design normalized (3NF) transactional models and dimensional models (Star/Snowflake schemas).
• Develop and maintain Oracle database objects, including tables, indexes, constraints, sequences, synonyms, and materialized views.
• Perform data model reviews, database design optimization, and ensure adherence to data modeling standards.
• Collaborate with business stakeholders, architects, developers, and data engineering teams.
• Support data governance, metadata management, and enterprise data architecture initiatives.

Required Skills & Qualifications:

• 5+ years of hands-on experience in Data Modeling, Data Architecture, or Database Design.
• Expert-level proficiency with Erwin Data Modeler (Version 9.x or higher preferred).
• Strong experience with Oracle Database (11g/12c/19c/21c).
• Advanced SQL and PL/SQL skills.
• Strong understanding of Oracle schema design and performance tuning fundamentals.
• Hands-on experience with DDL, including tables, indexes, constraints, sequences, synonyms, and materialized views.
• Proven experience designing normalized (3NF) and dimensional (Star/Snowflake) data models.

Nice-to-Have Skills:

• Experience in regulated industries such as Utilities, Financial Services, Insurance, or Healthcare.
• Familiarity with ER/Studio, PowerDesigner, Collibra, or Alation.
• Exposure to Oracle Cloud, AWS, Azure, Snowflake, or Databricks.
• Knowledge of ETL/ELT tools and data integration patterns.
• Experience with Master Data Management (MDM) and Data Governance.
• Experience with Microsoft SQL Server and PostgreSQL.