Greetings from TCS!

Hiring: Data Architecture & Modeling Engineer

Role: Engineer

Primary Skill: Data Architecture and Modeling

Experience: 5–8 years

Location: Bangalore

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 .
- Solid 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.

📌 Data Architecture & Modeling Engineer (Bengaluru)
🏢 Tata Consultancy Services
📍 Bengaluru