Technical Architect

Tata Consultancy Services Limited
Pittsburgh, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 120K

Job location

Pittsburgh, United States of America

Tech stack

Databases
Data Architecture
Data Governance
Data Integration
ETL
Relational Databases
Dimensional Modeling
PostgreSQL
Microsoft SQL Server
MySQL
Oracle Applications
SQL Databases
Information Technology
Data Lineage
Data Management
Physical Data Models

Job description

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

Requirements

Do you have experience in Technical documentation?, Do you have a Bachelor's degree?, * 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, Qualifications : BACHELOR OF COMPUTER SCIENCE

Benefits & conditions

(part of Tata group) 3.93.9 out of 5 stars Pittsburgh, PA $100,000 - $120,000 a year, Pulled from the full job description

  • Pet insurance

  • Health insurance

  • Vision insurance

  • Dental insurance

  • Commuter assistance, 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.

Apply for this position