Data Modeler
Application Management Services LLC
Newark, United States of America
7 days ago
Role details
Contract type
Permanent contract Employment type
Part-time (≤ 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Newark, United States of America
Tech stack
Databases
Data Dictionary
Information Engineering
Data Governance
Data Integrity
ETL
Data Structures
Relational Databases
Database Design
Database Schema
Database Storage Structures
Dimensional Modeling
Microsoft Visio
PowerDesigner
Cloud Services
Lucidchart
Software Engineering
SQL Databases
Enterprise Data Management
Enterprise Software Applications
Data Ingestion
Er-Win
Data Lake
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.