Senior Enterprise Data Modeler for BI & AI

Tata Consultancy Services Limited; Columbus (OH); On-site; USD 90,000 - 120,000; Full time

Job summary

Tata Consultancy Services Limited in Columbus, OH, seeks an Enterprise Data Modeler to design and maintain enterprise analytic data models for BI, OLAP and AI use cases, with clear grain, facts, dimensions, history, metadata and change control.

You will define entities, relationships, keys, grain; design dimensions and hierarchies; and implement time-based history, data governance and quality controls. Proficiency in Databricks, Delta Lake and Erwin is preferred.

Qualifications

• Strong enterprise and dimensional data-modeling experience.
• Hands-on fact and dimension design with history modeling.
• ER modeling, keys, relationships and cardinalities.
• Data governance, metadata and data-quality concepts.
• Familiarity with Databricks concepts.
• Experience with Erwin or equivalent data-modeling tool.

Responsibilities

• Design and maintain enterprise analytical data models for BI, OLAP and AI use cases.
• Define entities, relationships, keys and grain for fact and dimension tables.
• Design dimension tables, hierarchies, codes and descriptions.
• Represent time with effective start/end dates and history tracking.
• Maintain metadata including definitions, sources and ownership; ensure validation and change control.
• Optimize models for AI and BI performance and update downstream dependencies.

Skills

Enterprise data modeling

Dimensional modeling

ER modeling

Data governance

Metadata management

SQL

Databricks concepts

Erwin

Data quality

Tools

Erwin

Databricks

Delta Lake

Job description

Tata Consultancy Services Limited in Columbus, OH, seeks an Enterprise Data Modeler to design and maintain enterprise analytic data models for BI, OLAP and AI use cases, with clear grain, facts, dimensions, history, metadata and change control.

You will define entities, relationships, keys, grain; design dimensions and hierarchies; and implement time-based history, data governance and quality controls. Proficiency in Databricks, Delta Lake and Erwin is preferred.