• Pittsburgh, PA
  • $110,000–$120,000 Per Year
19 days ago

Job Description

Role: Technical Architect

Required Skills: SQL | Data architect

Qualification: BACHELOR OF COMPUTER SCIENCE

Experience: 7 - 14 Years

Function: TECHNOLOGY

Apply By: 2026-11-09

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

  1. Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.

  2. Time Off: Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Numbers & Facts

LocationPittsburgh, PA
Salary$110,000–$120,000 Per Year

Skills

  • Analysis Skillsunmatched
  • Architectural Servicesunmatched
  • Best Practicesunmatched
  • Business Supportunmatched
  • Cloud Architectureunmatched
  • Communication Skillsunmatched
  • Computer Scienceunmatched
  • Data Modelingunmatched
  • Data Qualityunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Dimensional Modelingunmatched
  • Documentationunmatched
  • Legalunmatched
  • Loan Fundingunmatched
  • Mentoringunmatched
  • Model Validationunmatched
  • Performance Modelingunmatched
  • Problem Solving Skillsunmatched
  • Query Optimizationunmatched
  • SQL Databasesunmatched
  • Student Loansunmatched
  • System Integration (SI)unmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder