Application Data Modeler – Transactional Data

Job Title:  Application Data Modeler – Transactional Data

Location: NY

Duration: Longterm

Description:

We are seeking an experienced Application Data Modeler with strong expertise in transactional data and OLTP data modeling. The candidate will be responsible for designing and maintaining conceptual, logical, and physical data models that support enterprise applications and business processes.

The ideal candidate should have strong experience translating business requirements and application workflows into scalable, high-performance data models while ensuring data integrity, consistency, and usability.

Responsibilities:

Design and maintain conceptual, logical, and physical data models for transactional applications.

Develop OLTP data models supporting high-volume transactional workloads.

Analyze business requirements, application workflows, and business rules to define data structures.

Create and maintain ER diagrams, entity relationships, primary/foreign keys, constraints, and data definitions.

Apply data normalization and appropriate modeling techniques to ensure data integrity and minimize redundancy.

Collaborate with application architects, developers, business analysts, data engineers, and database teams.

Design data models supporting APIs, microservices, and enterprise application integrations.

Review existing data models and identify opportunities for performance, scalability, and data-quality improvements.

Support database design, data migration, integration, and application modernization initiatives.

Ensure transactional data models align with enterprise data architecture, governance, security, and standards.

Experience with high-volume transactional systems.

Experience with cloud databases and modernization initiatives.

Knowledge of data governance, master/reference data, and metadata management.

Experience with data migration and application modernization.

Understanding of OLTP vs. OLAP architectures.

Experience working in Agile/Scrum environments.