Senior Data Modeler: Oracle & Erwin Expert in Houston

Artifintech; Houston (TX); In loco; USD 83.000 - 103.000; Tempo pieno

Descrizione del lavoro

Artifintech in Houston, TX seeks a Data Engineer - Data Modeler with 5+ years of hands-on data modeling experience. The role focuses on designing enterprise data models using Oracle and Erwin Data Modeler to support analytics and operational systems.

The position requires strong SQL/PLSQL skills, experience with 3NF and star/snowflake schemas, and expertise in DDL; the incumbent will translate business requirements into robust conceptual, logical, and physical models across Oracle environments.

Competenze

• 5+ years in data modeling/architecture or database design.
• Proficient with Erwin Data Modeler (v9+), incl. templates, DDL, forward/reverse engineering.
• Advanced SQL with Oracle (11g/12c/19c/21c) and basic performance tuning.
• Experience designing both 3NF transactional and star/snowflake dimensional models.
• Strong DDL experience: tables, indexes, constraints, sequences, synonyms, materialized views.

Mansioni

• Design, develop, and maintain enterprise-grade data models.
• Support analytics and operational systems with robust data models.
• Collaborate with stakeholders to translate requirements into models.

Conoscenze

Data modeling

Erwin Data Modeler

SQL & Oracle

Dimensional modeling

DDL mastery

Descrizione del lavoro

Artifintech in Houston, TX seeks a Data Engineer - Data Modeler with 5+ years of hands-on data modeling experience. The role focuses on designing enterprise data models using Oracle and Erwin Data Modeler to support analytics and operational systems.

The position requires strong SQL/PLSQL skills, experience with 3NF and star/snowflake schemas, and expertise in DDL; the incumbent will translate business requirements into robust conceptual, logical, and physical models across Oracle environments.