Application Data Modeler

Location: New York, NY – Onsite
Employment Type: W-2 Only

Job Summary

We are looking for an experienced Application Data Modeler with strong hands-on experience in application data modeling, database design, and SQL. The candidate will work closely with application developers, architects, business teams, and database teams to design and maintain data models supporting business applications.

Required Skills

• Strong experience in Application Data Modeling
• Hands-on experience with Logical and Physical Data Models
• Strong understanding of relational database design
• Experience creating ER diagrams / Entity Relationship Models
• Strong SQL skills
• Experience with tables, relationships, primary keys, foreign keys, and constraints
• Understanding of normalization and denormalization
• Experience translating application/business requirements into data models
• Experience working closely with application development teams
• Knowledge of database technologies such as Oracle, SQL Server, PostgreSQL, or similar
• Experience with data modeling tools such as ERwin, ER/Studio, PowerDesigner, or Visio is preferred

Responsibilities

• Design and maintain logical and physical data models for business applications
• Analyze application requirements and translate them into effective data structures
• Define entities, attributes, relationships, keys, and data constraints
• Create and maintain ER diagrams and data dictionaries
• Work with developers and architects on database/application design
• Review existing application data structures and recommend improvements
• Ensure data models align with application and business requirements
• Support database design, integration, and application development initiatives