Technical Architect

dentsu; New Delhi; On-site; INR 3,500,000 - 7,000,000; Full time

Job summary

Merkle in Bengaluru is seeking a Solution Architect (Snowflake, Python & SQL) to design and deliver scalable cloud data platforms. The role requires 10+ years in data engineering/architecture, with deep Snowflake expertise and experience in AI, cloud migrations, and analytics initiatives.

You will lead technical teams, collaborate with cross-functional stakeholders, and drive data governance, security, and performance optimization across enterprise data solutions.

Qualifications

• Bachelor's or Master's degree in CS/IT/Engineering/Data Science or related field.
• 10+ years of experience in Data Engineering, Data Warehousing, Data Architecture, or Solution Architecture.
• Minimum 5+ years of hands-on Snowflake experience and optimization.
• Experience designing enterprise-scale cloud data platforms and analytics solutions.
• Strong data modernization, cloud migration, and digital transformation experience.
• Experience leading technical teams and stakeholder collaboration.
• Excellent communication, presentation, and stakeholder management skills.

Responsibilities

• Design scalable, secure, and high-performing enterprise data solutions using Snowflake and cloud technologies.
• Define end-to-end architecture for ingestion, transformation, storage, governance, and analytics.
• Architect and optimize Snowflake environments to support business workloads.
• Develop Python- and SQL-based data engineering and analytics solutions.
• Design and implement Generative AI solutions including LLM-powered apps and AI copilots.
• Build and govern RAG-based architectures integrating structured and unstructured data.
• Collaborate with stakeholders to translate business requirements into scalable technical solutions.
• Lead migrations from legacy platforms to Snowflake and cloud-native architectures.
• Establish data governance, security, performance optimization, and cost management practices.
• Provide architectural leadership, design reviews, and mentorship to engineering teams.
• Evaluate emerging AI and cloud technologies and recommend adoption strategies.
• Drive automation, innovation, and continuous improvement across data and AI platforms.

Skills

Snowflake Architecture

Python

SQL

PySpark

Pandas

NumPy

Azure Databricks

Azure Data Factory

Power BI

Tableau

LLMs / Generative AI

RAG

Education

Bachelor's or Master's degree in Computer Science, IT, Engineering, Data Science or related field

Tools

Azure DevOps

GitHub

Docker

Kubernetes

Terraform

CI/CD

Job description

Job Description:

Solution Architect (Snowflake, Python & SQL)

Required Qualifications

• Bachelor’s or Master’s degree in Computer Science, Information Technology, Engineering, Data Science, or a related field.
• 10+ years of experience in Data Engineering, Data Warehousing, Data Architecture, or Solution Architecture.
• Minimum 5+ years of hands-on experience with Snowflake architecture, implementation, and optimization.
• Proven experience designing enterprise-scale cloud data platforms and analytics solutions.
• Strong experience with data modernization, cloud migration, and digital transformation initiatives.
• Experience leading technical teams and collaborating with cross-functional stakeholders.
• Excellent communication, presentation, and stakeholder management skills.

Required Skills

• Snowflake: Snowflake Architecture, Snowpark, Snowpipe, Streams & Tasks, Dynamic Tables, Data Sharing, Performance Tuning, Cost Optimization.
• Programming: Python, SQL, PySpark, Pandas, NumPy.
• Data Engineering: ETL/ELT Design, Data Pipelines, Data Warehousing, Data Lakehouse Architecture, Data Modeling.
• Generative AI & AI Technologies: Azure OpenAI, OpenAI APIs, LLMs, RAG (Retrieval-Augmented Generation), AI Agents, Prompt Engineering, Vector Databases, LangChain, Semantic Kernel.
• Cloud Platforms: Microsoft Azure (preferred), Azure Data Factory, Azure Databricks, Azure AI Services, Microsoft Fabric.
• DevOps & Automation: GitHub, Azure DevOps, CI/CD, Docker, Kubernetes, Terraform.
• Data Governance: Data Security, Data Quality Management, Metadata Management, Compliance, Access Controls.
• Visualization & Analytics: Power BI, Tableau, Advanced Analytics.

Key Responsibilities

• Design and implement scalable, secure, and high-performing enterprise data solutions using Snowflake and cloud technologies.
• Define end-to-end architecture for data ingestion, transformation, storage, governance, and analytics.
• Architect and optimize Snowflake environments to support business-critical workloads.
• Develop and review Python- and SQL-based solutions for data engineering and analytics use cases.
• Design and implement Generative AI solutions including LLM-powered applications, AI assistants, intelligent search, and enterprise copilots.
• Build and govern RAG-based architectures integrating structured and unstructured enterprise data.
• Collaborate with business stakeholders to convert business requirements into scalable technical solutions.
• Lead migration initiatives from legacy data platforms to Snowflake and cloud-native architectures.
• Establish best practices for data governance, security, performance optimization, and cost management.
• Provide architectural leadership, conduct design reviews, and mentor engineering teams.
• Evaluate emerging AI, cloud, and data technologies and recommend adoption strategies.
• Drive automation, innovation, and continuous improvement initiatives across data and AI platforms.
• Support solution estimation, technical planning, risk identification, and mitigation strategies.
• Create architecture documentation, technical roadmaps, and governance artifacts.
• Ensure compliance with enterprise standards, security policies, and regulatory requirements.

Location:

DGS India - Bengaluru - Manyata N1 Block

Brand:

Merkle

Time Type:

Full time

Contract Type:

Permanent