The Role
Designs and leads enterprise-scale cloud data platforms and analytics solutions using Snowflake, Python, SQL, and Azure technologies. Responsibilities include data architecture, migration, governance, optimization, and technical leadership. The role also architects generative AI, LLM, and RAG solutions, mentors engineering teams, conducts design reviews, develops roadmaps, and translates business requirements into secure, scalable technical solutions.
Summary Generated by Built In
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.
- 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.
- 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 BlockBrand:
MerkleTime Type:
Full timeContract Type:
PermanentSkills Required
- 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
- 5+ years of hands-on experience with Snowflake architecture, implementation, and optimization
- Experience designing enterprise-scale cloud data platforms and analytics solutions
- Experience with data modernization, cloud migration, and digital transformation initiatives
- Experience leading technical teams and collaborating with cross-functional stakeholders
- Strong Snowflake architecture, Snowpark, Snowpipe, Streams & Tasks, Dynamic Tables, Data Sharing, performance tuning, and cost optimization skills
- Proficiency in Python, SQL, PySpark, Pandas, and NumPy
- Experience with ETL/ELT design, data pipelines, data warehousing, data lakehouse architecture, and data modeling
- Experience with generative AI technologies including Azure OpenAI, OpenAI APIs, LLMs, RAG, AI agents, prompt engineering, vector databases, LangChain, and Semantic Kernel
- Experience with Microsoft Azure, Azure Data Factory, Azure Databricks, Azure AI Services, or Microsoft Fabric
- Experience with GitHub, Azure DevOps, CI/CD, Docker, Kubernetes, and Terraform
- Experience with data security, data quality management, metadata management, compliance, and access controls
- Experience with Power BI, Tableau, and advanced analytics
- Excellent communication, presentation, and stakeholder management skills
dentsu Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about dentsu and has not been reviewed or approved by dentsu.
-
Parental & Family Support — Paid parental leave at full pay and caregiver supports (including backup care) are emphasized as standout elements. Feedback suggests family-oriented benefits are a strong part of the package.
-
Leave & Time Off Breadth — Flexible or unlimited PTO, extensive paid holidays, and a year-end office closure are established components. Feedback suggests time-off policies are generous and add meaningful flexibility.
-
Retirement Support — A large, established 401(k) plan with employer matching is clearly documented. Feedback suggests retirement benefits feel competitive and straightforward.
dentsu Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
We are dentsu. We team together to help brands predict and plan for disruptive future opportunities and create new paths to growth in the sustainable economy. We know people better than anyone else and we use those insights to connect brand, content, commerce and experience, underpinned by modern creativity. We are the network designed for what’s next
