Source description
About the role
Skill: Data Architect
-
Must Have Technical/Functional Skills:
-
12–15 years of experience in data architecture, data modeling, or related roles.
-
Strong expertise in data modeling techniques (conceptual, logical, physical).
-
Proven experience creating logical data flow diagrams and data lineage documentation.
-
Hands-on proficiency with SQL and relational databases (e.g., Oracle, SQL Server, PostgreSQL, MySQL).
-
Solid understanding of dimensional modeling, normalization, and denormalization.
-
Experience working closely with business, analytics, and engineering teams.
-
Strong analytical, problem-solving, and communication skills
-
Roles & Responsibilities:
-
Design and maintain conceptual, logical, and physical data models to support business and analytical needs.
-
Develop logical data flow diagrams representing data movement across source systems, integrations, and consumption layers.
-
Partner with business stakeholders, data engineers, and application teams to translate requirements into scalable data architectures.
-
Define and enforce data standards, naming conventions, and modeling best practices.
-
Perform hands-on work with SQL and database platforms to validate models, optimize queries, and ensure data accuracy.
-
Review and optimize existing data models for performance, scalability, and maintainability.
-
Support data integration, ETL/ELT, and reporting initiatives with clear architectural guidance.
-
Ensure data quality, consistency, and integrity across systems.
-
Provide architectural input for cloud, on prem, or hybrid data platforms.
-
Mentor junior architects and data modelers as needed.
Salary Range - $100,000-$120,000 a year
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.
Role: Technical Architect
Desired skills: Data architect | Data Modeling
Qualifications: BACHELOR OF COMPUTER SCIENCE
-
Experience: 7 - 14 Years
-
Job function: TECHNOLOGY
-
Location: Pittsburgh, PA
Salary range: $100,000–$120,000
Apply by: 2026-08-08 00:00:00
More at Tata Consultancy Services