Technical Architect

Tata Consultancy Services; Columbus (OH); On-site; USD 140,000 - 180,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

Family Support: Leaves

401K Plan

Certification & Training Reimbursement

Vacation & Holidays

Job summary

Tata Consultancy Services Limited in Columbus, OH is seeking a seasoned Data & Analytics Solutions Architect (AWS + Snowflake + Cortex) to lead end-to-end data platform architecture and modernization across AWS and Snowflake ecosystems.

You will design scalable lakehouse architectures, govern data, and guide client-facing architecture discussions, with a focus on AI-enabled analytics and enterprise-grade security.

Qualifications

• 14+ years in Enterprise Data Architecture, AWS Data Platforms, Snowflake, Data Engineering, and Cloud Modernization.
• Proven Enterprise Solution architecture using AWS, Snowflake, Cortex across the data-to-insights chain.
• Hands-on with AWS Data Services, Snowflake, Python, PySpark and SQL.
• Experience in Lakehouse architectures and modern analytics on AWS.
• Knowledge of Snowflake Data Cloud features (Workflows, Snowpipe, Model Registry, etc.).
• Experience with data governance, security controls, and responsible AI practices.
• Experience leading architecture definition, governance, migration planning, and readiness activities.
• Client-facing solutioning, RFP responses, effort estimation, workshops.

Responsibilities

• Engage with stakeholders to understand data, analytics, AI, and cloud transformation requirements.
• Define end-to-end architecture for AWS Snowflake-based data, analytics, and AI platforms.
• Design scalable Lakehouse solutions using AWS, Snowflake, Iceberg catalog, and Horizon Catalog.
• Architect data ingestion, integration, batch, streaming, and data engineering solutions.
• Implement AI-enabled analytics using Snowflake Cortex and governed data access.
• Establish data governance, metadata, lineage, observability, and responsible AI standards.
• Lead modernization, migration, and cloud transformation initiatives on AWS.
• Provide technical leadership across design, implementation, testing, migration, and support.
• Drive platform performance, reliability, and cost optimization across AWS and Snowflake.

Skills

Enterprise Data Architecture

Data Platform Modernization

Solution Architecture

DataOps

Security & Compliance

Governance & Metadata

RFP & Stakeholder Engagement

Migration Planning

Non-Functional Requirements (NFR)

Client Engagement

Education

Bachelor's degree in Computer Science, Engineering, Information Systems, Data Management, or related discipline

AWS Solutions Architect Certification

Snowflake Certification

Tools

AWS

Snowflake

Snowflake Cortex

Snowflake Horizon Catalog

Apache Iceberg

Snowflake Open Catalog

Python

PySpark

SQL

Job description

Skill: Data & Analytics Solutions Architect (AWS + Snowflake + Cortex)

Location

• NJ/NYC
• Columbus OH
• Washington DC area
• Milwaukee
• Boston
• Pittsburg PA
• Troy MI

Must Have Technical/Functional Skills:

• 14+ years of experience in Enterprise Data Architecture, AWS Data Platforms, Snowflake, Data Engineering, and Cloud Modernization.
• Proven experience in Enterprise Solution architecture using AWS, Snowflake, Cortex and related technology components across the Data to Insights end to end value chain.
• Strong hands-on expertise in AWS Data Services, Snowflake, Snowflake Cortex, Snowflake Horizon Catalog, Apache Iceberg / Snowflake Open Catalog, Python, PySpark, and SQL.
• Proven experience designing and implementing Lakehouse Architectures, enterprise data platforms, and modern analytics solutions on AWS.
• Strong understanding of the Snowflake Data Cloud, including Snowflake SQL, Workflows, Snowpipe, Snowflake Model Registry, Snowflake Horizon Catalog, Serverless Compute, and Performance Optimization.
• Experience building AI-enabled analytics solutions using Snowflake Cortex, semantic models, natural language analytics, and governed data access frameworks.
• Expertise in Data Engineering including ETL/ELT, batch and streaming integration, APIs, orchestration, data quality, metadata management, lineage, observability, and DataOps practices.
• Strong knowledge of Enterprise Data Architecture, including data models, data products, lakehouse and warehouse patterns, semantic layers, and master/reference data management.
• Experience implementing Security, Governance, and Compliance controls including IAM/RBAC, encryption, privacy, masking, auditability, retention, and responsible AI practices.
• Proven experience leading architecture definition, HLD/LLD preparation, NFR assessment, migration planning, technical governance, and production readiness activities.
• Experience supporting cloud transformation initiatives, solutioning, RFP responses, effort estimation, and client-facing architecture discussions.
• Good understanding of BFSI regulatory, security, privacy, resilience, and audit requirements.
• Bachelor's degree in Computer Science, Engineering, Information Systems, Data Management, or a related discipline.
• Preferred certifications in AWS Solutions Architecture, Snowflake, Data Engineering, Enterprise Architecture, Security, or AI/ML.

Roles & Responsibilities:

• Engage with business and technology stakeholders to understand data, analytics, AI, and cloud transformation requirements.
• Define end-to-end architecture for AWS Snowflake-based data, analytics, and AI platforms.
• Design scalable, secure, and high-performance Lakehouse solutions using AWS Data Services, Snowflake, Apache Iceberg / Snowflake Open Catalog, and Snowflake Horizon Catalog.
• Architect data ingestion, integration, batch, streaming, and data engineering solutions supporting enterprise analytics and AI use cases.
• Design and implement AI-enabled analytics solutions using Snowflake Cortex, semantic models, and governed data access frameworks.
• Establish data governance, security, metadata, lineage, observability, and responsible AI standards across the platform.
• Lead data platform modernization, migration, and cloud transformation initiatives on AWS.
• Define architecture standards, reusable frameworks, best practices, and DataOps delivery models.
• Provide technical leadership across solution design, implementation, testing, migration, deployment, and production support activities.
• Conduct architecture reviews, identify risks and dependencies, and guide teams on mitigation strategies and best practices.
• Drive platform performance optimization, reliability improvements, and cost optimization across AWS and Snowflake environments.
• Collaborate with data engineers, AI specialists, architects, platform teams, and client stakeholders to deliver enterprise-scale solutions.
• Support solutioning, RFP responses, effort estimation, technical presentations, and client workshops.
• Mentor architects and engineers and contribute to capability development, technical assessments, and knowledge-sharing initiatives.
• Develop reusable accelerators, reference architectures, implementation frameworks, and best practices for AWS Snowflake and AI solutions.

Salary Range - $140,000-$180,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.
• 4.Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• 5.Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• 6.Time Off: Vacation, Time Off, Sick Leave & Holidays.
• 7.Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Location

Columbus, OH

Function

TECHNOLOGY

Role

Technical Architect

ID

435694

Skills

AWS | Data Analytics

Salary Range

$140,000 - $180,000

Desired Candidate Profile

Qualifications

BACHELOR OF COMPUTER SCIENCE