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

Qualifications

BACHELOR OF COMPUTER SCIENCE