Technical Architect

Tata Consultancy Services Ltd

Pittsburgh, PA

JOB DETAILS
SALARY
$100,000–$120,000 Per Year
SKILLS
Analysis Skills, Architectural Services, Business Support, Cloud Architecture, Communication Skills, Data Modeling, Data Quality, Database Extract Transform and Load (ETL), Dimensional Modeling, Documentation, Legal, Loan Funding, Mentoring, Microsoft SQL Server, Model Validation, MySQL, Oracle Database, Performance Modeling, PostgreSQL, Problem Solving Skills, Query Optimization, Relational Databases (RDBMS), SQL Databases, Student Loans, System Architecture, System Integration (SI)
LOCATION
Pittsburgh, PA
POSTED
18 days ago

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.

About the Company

T

Tata Consultancy Services Ltd