Technical Architect

Tata Consultancy Services Limited
Pittsburgh, PA, United States
1 day ago
Apply on jobs.localjobnetwork.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Compensation
$110,000.0 - $120,000.0
Working hours
Regular working hours

Tech stack

Databases Data Architecture Data Governance Data Integration Extract Transform Load (ETL) Relational Databases Dimensional Modeling PostgreSQL Microsoft SQL Server MySQL Oracle (Applications) SQL Databases
+4 more
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

  • 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., BACHELOR OF COMPUTER SCIENCE

Benefits & conditions

Salary Range - $110,000-$120,000 a year TCS Employee Benefits Summary:

  1. Discretionary Annual Incentive.
  2. Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
  3. Family Support: Maternal & Parental Leaves. Insurance Options: Auto & Home Insurance, Identity Theft Protection.

  4. Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
  5. 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

This job is hosted externally. Click below to view the full posting and apply.

Apply on jobs.localjobnetwork.com
Prepare application

Good distractions

Loading talks and stories from around this role…