Data Modeler

Application Management Services LLC

Newark, NJ, United States

25 days ago

Role details

Contract type

Permanent contract

Employment type

Part-time (≤ 32 hours)

Experience level

Expert

Experience required

10 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Databases Data Dictionary Information Engineering Data Governance Data Integrity Extract Transform Load (ETL) Data Structures Relational Databases Database Design Database Schema Database Storage Structures Dimensional Modeling

+14 more

Microsoft Visio PowerDesigner Cloud Services Lucidchart Software Engineering SQL Databases Enterprise Data Management Enterprise Software Applications Data Ingestion Er-Win Data Lakes Star Schema Physical Data Models Data Pipelines

Job description

Design and maintain conceptual, logical, and physical data models for enterprise systems.
Create and optimize database schemas, tables, relationships, and data structures.
Develop data dictionaries, metadata documentation, and mapping specifications.
Collaborate with data engineering teams to support ETL/ELT pipelines and ensure accurate data ingestion.
Ensure data integrity through normalization, referential integrity, and validation rules.
Work closely with business stakeholders to translate requirements into structured data models.
Support performance tuning and optimization of database designs.
Contribute to data governance standards, naming conventions, and modeling best practices.

Requirements

We are seeking an experienced Data Modeler (10+ years) to design and develop enterprise data models and database structures supporting analytics, reporting, and application development. This hybrid role in New Jersey requires strong hands-on experience in conceptual, logical, and physical data modeling, along with expertise in designing scalable databases and table structures., * 10+ years of hands-on experience in data modeling and database design.

Strong proficiency in SQL and relational database concepts.
Experience with data modelling tools (Erwin, PowerDesigner, Visio, Lucidchart).
Solid understanding of dimensional modeling, star/snowflake schemas, and normalization.
Experience with enterprise data warehouses, data lakes, or cloud data platforms.
Strong analytical and communication skills.