Data Architecture & Modeling Engineer

Tata Consultancy Services Limited; Bengaluru; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Tata Consultancy Services Limited is seeking an experienced Data Architecture & Modeling Engineer in Bengaluru. You will design scalable data models and architectures for enterprise data platforms, translating business needs into robust logical and physical models.

The role requires hands-on expertise in data modeling, dimensional modeling, data warehousing, database design, and modern data architecture, with a strong focus on data quality, governance, and metadata management.

Qualifications

• Strong hands-on experience in Data Architecture and Data Modeling.
• Expertise in conceptual, logical, and physical data modeling.
• Strong understanding of relational and dimensional data modeling.
• Hands-on experience designing fact tables, dimension tables, Star Schema, and Snowflake Schema.
• Strong understanding of EDW concepts and architecture.
• Good knowledge of SQL and relational databases.
• Experience with data normalization and denormalization techniques.
• Strong understanding of ETL/ELT architecture and data integration patterns.
• Experience defining data entities, relationships, keys, constraints, and metadata.
• Knowledge of data quality, data governance, lineage, and metadata management.
• Experience working with large-scale enterprise data platforms.

Responsibilities

• Design and maintain conceptual, logical, and physical data models.
• Develop scalable data architectures supporting analytics, reporting, and enterprise data requirements.
• Design dimensional models, including facts, dimensions, hierarchies, and relationships.
• Translate functional and business requirements into appropriate data models.
• Define data structures, entities, relationships, naming standards, and modeling conventions.
• Support the design and implementation of EDW, data lake, and modern data platform architectures.
• Collaborate with data engineers, architects, analysts, and business teams.
• Review existing data models and recommend improvements for scalability and performance.
• Support data quality, governance, metadata, and lineage initiatives.
• Ensure data models meet performance, integrity, security, and scalability requirements.
• Maintain architecture diagrams, data dictionaries, and technical documentation.

Skills

Data Architecture

Data Modeling

SQL

Dimensional Modeling

Relational Modeling

EDW Concepts

Data Warehousing

Data Governance

Metadata Management

ETL/ELT

Data Quality

Education

Bachelor’s degree or above

Tools

Erwin Data Modeler

ER/Studio

Snowflake

Databricks

Azure

AWS

GCP

Job description

Hiring: Data Architecture & Modeling Engineer

Primary Skill: Data Architecture and Modeling

Experience: 5–8 years

Educational Qualification: Bachelor’s degree or above

Role Overview

We are looking for an experienced Data Architecture & Modeling Engineer to design scalable data models and architectures for enterprise data platforms.

The ideal candidate should have strong hands‑on experience in data modeling, dimensional modeling, data warehousing, database design, and modern data architecture, with the ability to translate business requirements into robust logical and physical data models.

Mandatory Skills

• Strong hands‑on experience in Data Architecture and Data Modeling.
• Expertise in conceptual, logical, and physical data modeling.
• Strong understanding of relational and dimensional data modeling.
• Hands‑on experience designing fact tables, dimension tables, Star Schema, and Snowflake Schema.
• Strong understanding of Enterprise Data Warehouse (EDW) concepts and architecture.
• Good knowledge of SQL and relational databases.
• Experience with data normalization and denormalization techniques.
• Strong understanding of ETL/ELT architecture and data integration patterns.
• Experience defining data entities, relationships, keys, constraints, and metadata.
• Knowledge of data quality, data governance, lineage, and metadata management.
• Experience working with large‑scale enterprise data platforms.

Key Responsibilities

• Design and maintain conceptual, logical, and physical data models.
• Develop scalable data architectures supporting analytics, reporting, and enterprise data requirements.
• Design dimensional models, including facts, dimensions, hierarchies, and relationships.
• Translate functional and business requirements into appropriate data models.
• Define data structures, entities, relationships, naming standards, and modeling conventions.
• Support the design and implementation of EDW, data lake, and modern data platform architectures.
• Collaborate with data engineers, architects, analysts, and business teams.
• Review existing data models and recommend improvements for scalability and performance.
• Support data quality, governance, metadata, and lineage initiatives.
• Ensure data models meet performance, integrity, security, and scalability requirements.
• Maintain architecture diagrams, data dictionaries, and technical documentation.

Good to Have

• Experience with modeling tools such as erwin Data Modeler, ER/Studio, or similar platforms.
• Exposure to modern cloud data platforms such as Snowflake, Databricks, Azure, AWS, or GCP.
• Understanding of Data Lake, Lakehouse, and Medallion Architecture.
• Knowledge of Master Data Management (MDM).
• Exposure to data catalog and governance platforms such as Collibra or Microsoft Purview.
• Experience with Agile/Scrum delivery environments.