Data Modeler for AI/BI Platforms (Databricks/Erwin)

SFE; Columbus (OH); On-site; USD 90,000 - 130,000; Full time

Job summary

SFE is seeking a data modeling expert to define entities, relationships, and keys, document grain, and create robust dimension and fact structures for analytics. The role emphasizes metadata, standard naming, data types, and domain constraints to support OLAP and AI workloads.

Responsibilities include history handling with effective dates, validation checks, versioning, and updating downstream dependencies.

Qualifications

• Define entities, relationships, and keys with documented cardinalities.
• Document grain (row-level meaning) for each fact/event table.
• Create dimension and fact tables with measures and keys.
• Standardize naming conventions, data types, domains, and units across models.
• Add metadata including source, refresh cadence, and owners.
• Implement basic validation checks (nullability, uniqueness, referential integrity, value ranges).

Skills

Data modeling

SQL

OLAP

Dimensional modeling

Metadata management

Tools

Erwin

Databricks

Job description

SFE is seeking a data modeling expert to define entities, relationships, and keys, document grain, and create robust dimension and fact structures for analytics. The role emphasizes metadata, standard naming, data types, and domain constraints to support OLAP and AI workloads.

Responsibilities include history handling with effective dates, validation checks, versioning, and updating downstream dependencies.