Erwin Data Modeler

AppLab Systems, Inc; Dallas (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

AppLab Systems, Inc. in Dallas, TX is seeking a Data Modeler for an onsite W2 role. You will design and optimize relational data models, work with Erwin Data Modeler, and coordinate with DBAs and developers to deliver scalable schemas.

The ideal candidate has 5+ years in data modeling, deep Oracle SQL/PL/SQL knowledge, and experience with 3NF and dimensional modeling. Strong communication and teamwork are essential to explain modeling decisions to technical and non-technical audiences.

Qualifications

• 5+ years in data modeling, data architecture, or database design roles.
• Expert proficiency with Erwin Data Modeler (v9.x+ preferred), including subject areas, model templates, DDL generation, forward/reverse engineering, model versioning, and complete compare functionality.
• Advanced SQL skills and Oracle (11g/12c/19c/21c) knowledge, including SQL, PL/SQL, schema design, and performance tuning basics for data model design.

Skills

Erwin Data Modeler

SQL

PL/SQL

Job description

===================W2 Role==========================

Job Title: Data Modeler

Location: Dallas, Texas (only local)

Work Mode: Onsite

Mandatory Skills

• Erwin Data Modeler
• SQL
• PL/SQL

Job Description

Required Qualifications

• 5+ 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 related to data model design.
• Demonstrated experience building normalized (3NF) transactional models and dimensional models (star/snowflake) for reporting and analytics.
• Strong command of DDL, including creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views.
• Solid understanding of data modeling concepts, including entity-relationship modeling, normalization/denormalization, cardinality, keys, and referential integrity.
• Solid grasp of database internals, including indexing strategies, partitioning, clustering, and query execution plans.
• Experience with data modeling best practices, including surrogate keys and slowly changing dimensions (SCD).
• Experience producing and maintaining data dictionaries, metadata, and data lineage documentation.
• Familiarity with version control tools such as Git and model comparison/diff tools.
• Excellent communication skills, with the ability to explain modeling decisions to technical and non-technical audiences.
• Self-motivated, able to multitask, and comfortable working in a team environment.

Preferred Qualifications

• Experience in regulated industries such as utilities, financial services, insurance, or healthcare, with associated data governance and compliance requirements.
• Familiarity with additional modeling or metadata tools such as ER/Studio, PowerDesigner, Collibra, or Alation.
• Exposure to cloud data platforms such as Oracle Cloud, AWS, Azure, Snowflake, or Databricks, including hybrid on-premises/cloud modeling scenarios.
• Working knowledge of ETL/ELT tools and data integration patterns.
• Experience supporting Master Data Management (MDM) or data governance initiatives.
• Experience with Microsoft SQL Server and PostgreSQL.
• Experience with Hadoop and MongoDB.
• This is a strictly onsite role in Dallas, Texas. Remote work is not available.