Data Modeller

Job Description Data Modeler (Databricks / ERwin)

Location: Columbus, OH or Jersey City, NJ

Duration: 6 Months

Experience Required: 8 10 Years

Primary Skills: Databricks, ERwin, Data Architecture and Modeling

Job Responsibilities

• Design and maintain conceptual, logical, and physical data models.
• Define entities, relationships, primary keys, and foreign keys, and document relationship cardinalities.
• Specify the grain and row-level meaning of fact, event, and feature tables.
• Design dimension tables with consistent codes, descriptions, and hierarchy attributes.
• Create fact and event tables with appropriate measures, timestamps, and join keys to related dimensions and entities.
• Implement standard date and time fields, including effective start and end dates for historical data tracking where required.
• Establish and maintain naming conventions, data types, units of measurement, and allowed values across data models.
• Maintain metadata and documentation, including field definitions, source systems, refresh frequency, and data ownership.
• Implement data validation checks for nullability, uniqueness, referential integrity, and value ranges.
• Design data models to support common access patterns, including joins, filters, and aggregations for OLAP, BI, and AI pipelines.
• Maintain model versioning and change history.
• Assess schema changes and update downstream dependencies accordingly.
• Optimize data models to improve performance for AI and BI use cases.

Required Skills and Qualifications

• 8 10 years of experience in data modeling and data architecture.
• Strong understanding of conceptual, logical, and physical data modeling.
• Hands-on experience with ERwin Data Modeler.
• Good understanding of Databricks concepts and data modeling practices.
• Experience designing fact tables, dimension tables, and data relationships.
• Strong knowledge of primary keys, foreign keys, cardinality, and referential integrity.
• Experience with data standards, metadata management, and data documentation.
• Understanding of data quality validation and model performance optimization.
• Ability to design scalable and reliable data models for analytical and AI/BI workloads.
• Strong analytical, problem-solving, and communication skills.

Thanks & Regards:

John H

Sr Recuiter

Nam Info Inc

+1 732 993 5322 (D)