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.
- Robust 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 up-to-date 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