AI-Ready Data Modeler for Analytics & BI

Apptad Inc; Jersey City (NJ); On-site; USD 90,000 - 130,000; Full time

Job summary

Apptad Inc. seeks a data modeling specialist to define entities, relationships, and keys for robust data schemas. You will design dimensions and facts, ensure consistent grain, and establish time-based history with valid metadata. The role focuses on OLAP/AI readiness, with emphasis on performance optimization and schema versioning.

Experience with Databricks and Erwin is desirable; you will document domains, validation rules, and data ownership, supporting reliable analytics pipelines.

Qualifications

• Define entities, relationships, and keys; document cardinalities.
• Specify table grain (row-level meaning) for each fact/event.
• Create dimension tables with consistent codes and hierarchies.
• Create fact tables with measures, timestamps, and keys.
• Represent time with standard date/time fields; history windows.
• Standardize naming conventions, data types, and domains.
• Add metadata, documentation, and ownership details.
• Implement basic validation: nullability, RI, ranges.
• Design outputs for OLAP/AI use cases and downstream schemas.
• Maintain versioning/history and downstream impact awareness.
• Optimize models for AI/BI performance; leverage Databricks.

Skills

Define entities and relationships

Document cardinalities

Table grain specification

Dimension table design

Fact/table design with measures

Time-based data modeling

Naming conventions and domains

Metadata and documentation

Validation checks (nullability, RI)

OLAP/AI pipeline design

Databricks concepts

Tools

Erwin

Job description

Apptad Inc. seeks a data modeling specialist to define entities, relationships, and keys for robust data schemas. You will design dimensions and facts, ensure consistent grain, and establish time-based history with valid metadata. The role focuses on OLAP/AI readiness, with emphasis on performance optimization and schema versioning.

Experience with Databricks and Erwin is desirable; you will document domains, validation rules, and data ownership, supporting reliable analytics pipelines.