Lead Data Modeler for AI, Analytics & Data Warehousing

Saransh Inc; Columbus (OH); On-site; USD 110,000 - 150,000; Full time

Job summary

Saransh Inc in Columbus, OH is seeking a senior Data Modeler to design scalable data models and support AI/BI pipelines. You will define entities, relationships, keys, and documentation for warehouse solutions and metadata.

The ideal candidate has 7–10 years of experience in data modeling and data warehousing, with Databricks concepts and ERWin proficiency, collaborating closely with data engineers and business stakeholders.

Qualifications

• 7–10 years of relevant experience in data modeling and data warehousing.
• Strong knowledge of Databricks concepts and architecture.
• Experience creating dimension and fact tables and metadata documentation.
• Ability to work with data engineers, data architects, and business stakeholders.

Responsibilities

• Define entities, relationships, primary keys, and foreign keys; document cardinalities.
• Create dimension and fact tables with measures, timestamps, and join keys.
• Standardize naming conventions, data types, units, and allowed values across models.
• Collaborate with data engineers and business stakeholders to support data integration and BI pipelines.

Skills

Databricks

Data modeling

Data warehousing

Stakeholder collaboration

Erwin

Tools

Erwin

Job description

Saransh Inc in Columbus, OH is seeking a senior Data Modeler to design scalable data models and support AI/BI pipelines. You will define entities, relationships, keys, and documentation for warehouse solutions and metadata.

The ideal candidate has 7–10 years of experience in data modeling and data warehousing, with Databricks concepts and ERWin proficiency, collaborating closely with data engineers and business stakeholders.