Sr. Data Modeler

Role: Sr. Data Modeler

Location: Newark, NJ (Hybrid – 3 days per week)

Duration: Long Term

JD:

Role Overview 

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.

Key Responsibilities

• 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.

Required Skills

• 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.