Technical Architect - (SQL, Python, AWS/Azure, Snowflake)

Dentsu Global Services; Bengaluru; On-site; INR 3,500,000 - 7,000,000; Full time

Job summary

Dentsu Global Services in Bengaluru seeks a senior Data Architect capable of leading enterprise data initiatives. You will design secure, scalable data solutions on Snowflake and cloud platforms, while guiding teams on data governance, tooling, and modern analytics.

You will also drive Generative AI integrations, ML-powered copilots, and data modernization projects, ensuring alignment with business goals and regulatory standards in a fast-paced environment.

Qualifications

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

Responsibilities

• Design scalable, secure enterprise data solutions using Snowflake and cloud tech.
• Define end-to-end data ingestion, transformation, storage, governance, and analytics.
• Architect and optimize Snowflake environments for critical workloads.
• Develop Python- and SQL-based data engineering solutions.
• Lead Generative AI initiatives including LLM-powered apps and AI copilots.
• Build RAG architectures integrating structured and unstructured data.
• Collaborate with stakeholders to translate requirements into scalable solutions.
• Drive migration from legacy platforms to Snowflake/cloud-native architectures.
• Establish data governance, security, performance, and cost best practices.
• Provide architectural reviews, mentorship, and technology roadmap planning.
• Evaluate and adopt emerging AI, cloud, and data tech as needed.

Skills

Snowflake architecture

Data engineering

Generative AI

Data governance

Visualization & analytics

Education

Bachelor’s or Master’s degree in CS/IT/Engineering/Data Science

Tools

Python

SQL

Power BI

Tableau

Azure OpenAI

OpenAI APIs

LangChain

Semantic Kernel

Job description

Notice Period : Immediate to 30 Days

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