Haystack
← Back to Jobs
Other
4A

Erwin Data Modeler

4i AmericasJersey City, NJ🇺🇸United StatesPosted Oct 6, 2026

Quick Overview

Seniority
Mid Senior
Work mode
Hybrid
Location
Jersey City, NJ, United States
Posted
3 days ago
SQLETLBenefits Administration

Job Description

Design, document, and maintain logical, conceptual, and physical data models that support scalable, secure, and reliable business and technology solutions. 

 

Key responsibilities: 

Translate business requirements into data structures, entities, relationships, and definitions. Develop and maintain conceptual, logical, and physical data models. Establish data standards, naming conventions, metadata, and ownership. Partner with business stakeholders, data engineers, architects, analysts, and governance teams. Assess data quality, integration impacts, performance, security, and regulatory requirements. Support database design, ETL/ELT development, reporting, analytics, and modernization initiatives. Maintain model documentation and communicate design decisions to technical and nontechnical audiences. Experience with relational, dimensional, and potentially NoSQL data modeling with experience in benefits administration preferred Proficiency with SQL and data-modeling tools such as ER/Studio, ERwin, or Lucidchart. Understanding of data warehouses, data lakes, APIs, master data, metadata, and data governance. Strong analytical, communication, documentation, and stakeholder-management skills.

 

Mandatory Skills

Allfusion Erwin Data Modeler: Advanced

Data Modeling: Advanced

Embarcadero ER/Studio 2016: Intermediate

Lucidworks: Advanced

NoSQL: Advanced

 

Preferred Skills

Benefits Administration Consultancy: Intermediate

Data Governance: Intermediate

Data lake design and development: Intermediate

Enterprise Data Warehouses: Intermediate

 

Similar jobs