Technical Architect

Job Description

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 - $120,000-$130,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.

Qualifications:

BACHELOR OF COMPUTER SCIENCE