Technical Architect
Tata Consultancy Services Limited
Pittsburgh, PA, United States
1 day ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on jobs.localjobnetwork.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Compensation
$110,000.0 - $120,000.0
Working hours
Regular working hours
Job source
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:
- 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
This job is hosted externally. Click below to view the full posting and apply.
Apply on jobs.localjobnetwork.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦