> Markdown version of [/jobs/ext/3991069-technical-architect](https://www.wearedevelopers.com/jobs/ext/3991069-technical-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Technical Architect

- **Company:** Tata Consultancy Services Limited
- **Location:** Pittsburgh, PA, United States
- **Salary:** $110,000.0 - $120,000.0
- **Contract:** Permanent contract
- **Skills:** Databases, Data Architecture, Data Governance, Data Integration, Extract Transform Load (ETL), Relational Databases, Dimensional Modeling, PostgreSQL, Microsoft SQL Server, MySQL, Oracle (Applications), SQL Databases, Information Technology, Data Lineage, Data Management, Physical Data Models
- **Published:** October 28, 2026
- **Apply:** https://jobs.localjobnetwork.com/apply/add/88725008/1

## About the Role

* 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

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