Data Modelling

Tata Consultancy Services; Columbus (OH); Presencial; USD 120.000 - 130.000; Jornada completa

Descripción de la vacante

Tata Consultancy Services Limited in Columbus, OH is seeking a Senior Engineer to design and implement robust data models for enterprise analytics. The role focuses on defining entities, keys, and dimensional models, and ensuring consistent data governance across BI pipelines.

The candidate should have strong experience in data modeling, Databricks concepts, and data tooling such as Erwin, with a Bachelor of Computer Science and a senior engineer mindset.

Formación

• Define entities, relationships, and keys and document cardinalities.
• Specify table grain (row-level meaning) for each fact/event/feature table.
• Create dimension tables with consistent codes, descriptions, and hierarchy attributes where applicable.
• Create fact/event tables with measures, timestamps, and join keys to relevant dimensions/entities.
• Represent time using standard date/time fields and effective start/end dates for history.
• Standardize naming conventions, data types, units, and allowed values across models.
• Add metadata and documentation (field definitions, source system, refresh cadence, owner).
• Implement basic validation checks (nullability, uniqueness, referential integrity, value ranges).
• Design outputs for common access patterns (joins, filters, aggregations) used by OLAP and AI pipelines.
• Maintain versioning/change history for models and update downstream dependencies when schemas change.
• Optimize the models for performance of AI/BI use cases.
• Good understanding of Databricks concepts
• Good understanding of tools like Erwin

Conocimientos

Data Modeling

Educación

Bachelor of Computer Science

Herramientas

Databricks

Erwin

Descripción del empleo

Job Description

Must Have Technical/Functional Skills

Skills / Requirements:

• Define entities, relationships, and keys (primary/foreign keys) and document cardinalities
• Specify table grain (row-level meaning) for each fact/event/feature table
• Create dimension tables with consistent codes, descriptions, and hierarchy attributes where applicable
• Create fact/event tables with measures, timestamps, and join keys to relevant dimensions/entities
• Represent time using standard date/time fields and, when needed, effective start/end dates for history
• Standardize naming conventions, data types, units, and allowed values (domains) across models
• Add metadata and documentation (field definitions, source system, refresh cadence, owner)
• Implement basic validation checks (nullability, uniqueness, referential integrity, value ranges)
• Design outputs for common access patterns (joins, filters, aggregations) used by OLAP and AI pipelines
• Maintain versioning/change history for models and update downstream dependencies when schemas change
• Optimize the models for performance of AI/BI use cases
• Good understanding of Databricks concepts
• Good understanding of tools like Erwin

TCS Employee Benefits Summary:

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Salary Range $120,000-$130,000 a year

Location

Columbus, OH

Function

TECHNOLOGY

Role

Senior Engineer

ID

434416

Skills

Data Modeling

Salary Range

$120,000 - $130,000

Desired Candidate Profile

Qualifications

BACHELOR OF COMPUTER SCIENCE