Cloud Architect - Snowflake
- InfoCepts
- 9 - 11 years
- Pune
- 16 days ago
- Email to a friend
- Report this job
Job Description
Position: Cloud Architect - Snowflake
Location: Pune/Nagpur
Type of Employment: Full-time
Purpose of the Position:
The Snowflake Architect will be responsible for leading the design, implementation, and optimization of enterprise-scale data solutions on Snowflake. This role is responsible for building a scalable, secure, and high-performance data architecture that aligns with organizational data and analytics objectives.
The architect will collaborate closely with business stakeholders, analytics teams, and engineering functions to enable high-quality, trusted data for reporting, advanced analytics, and AI-driven use cases. Additionally, the role will drive best practices in data modelling, performance tuning, cost optimization, and data governance, while providing architectural guidance and ensuring adherence to enterprise standards.
Key Result Areas (KRAs):
Data Architecture Design
- Design and evolve scalable, secure, and high-performance data architectures on Snowflake aligned with enterprise data strategy and business objectives.
- Establish best practices for data modelling (dimensional, data vault, etc.), ingestion frameworks, and storage optimization.
Data Quality & Governance
- Define and enforce data quality frameworks, governance policies, and standards across data platforms.
- Ensure data integrity, consistency, and compliance through robust validation, lineage, and monitoring mechanisms.
- Implement security best practices including RBAC, data masking, encryption, and row-level access controls aligned with regulatory standards (GDPR, HIPAA, SOC2).
Performance & Cost Optimization
- Drive performance tuning of Snowflake workloads including query optimization, warehouse sizing, clustering, and caching strategies.
- Optimize ETL/ELT pipelines for efficiency, scalability, and cost management.
- Establish proactive monitoring and continuous improvement mechanisms for platform performance.
AI/ML & Advanced Analytics Enablement
- Leverage Snowflake Cortex capabilities to enable AI-driven use cases within the data ecosystem.
- Design and implement Conversational BI solutions (e.g., Cortex Analyst) to enable natural language access to structured data.
- Build and operationalize Retrieval-Augmented Generation (RAG) pipelines to securely integrate enterprise data with LLMs.
- Ensure AI solutions are governed, explainable, and aligned with enterprise data security principles.
Collaboration & Technical Leadership
- Partner with cross-functional stakeholders including data engineering, analytics, and business teams to translate requirements into scalable solutions.
- Provide architectural guidance, conduct design reviews, and mentor engineering teams on best practices.
Innovation & Continuous Improvement
- Stay current with emerging trends in cloud data platforms, AI/ML, and Snowflake advancements.
- Identify and implement innovative approaches to improve data processing, analytics capabilities, and time-to-insight.
- Drive adoption of modern data practices including automation, data observability, and AI-enabled analytics.
Roles and Responsibilities
Essential Skills:
-
- Snowflake Architecture Expertise:
Deep expertise in Snowflake architecture, including storage, compute, and services layers. Proven ability to design scalable data models, optimize workloads, and implement best practices for performance, cost, and security. - Advanced SQL & Query Optimization:
Strong proficiency in SQL for complex transformations, performance tuning, and workload optimization, including query profiling and efficient data access strategies. - Data Warehousing & Modelling:
Solid understanding of modern data warehousing principles and modelling techniques (Dimensional, Data Vault, etc.), with the ability to design enterprise-grade data models supporting analytics and reporting. - ETL/ELT & Data Pipeline Design:
Hands-on experience in designing and optimizing ETL/ELT pipelines using modern data stack tools, with a strong focus on scalability, reliability, and orchestration. - Cloud Data Ecosystem:
Experience with cloud platforms such as AWS, Azure, or GCP, including integration with cloud-native data services, storage, and compute frameworks. - Data Governance & Security:
Strong understanding of data governance frameworks and Snowflake security capabilities, including RBAC, data masking, encryption, row-level security, and compliance with standards such as GDPR, HIPAA, and SOC2. - Performance & Cost Optimization:
Ability to optimize Snowflake environments through warehouse sizing, clustering, partitioning strategies, caching, and workload management to balance performance and cost efficiency. - AI/ML & Snowflake Cortex Capabilities:
Working knowledge of Snowflake Cortex and AI-driven analytics use cases, including:
- Snowflake Architecture Expertise:
Enabling Conversational BI using natural language querying
Designing RAG-based architectures to integrate enterprise data with LLMs
Understanding of AI governance, data grounding, and secure model usage
-
- Technical Leadership & Stakeholder Management:
Ability to translate business requirements into technical solutions, lead architectural discussions, mentor teams, and drive alignment across engineering, analytics, and business stakeholders.
- Technical Leadership & Stakeholder Management:
Desirable Skills:
-
- Python or R: Knowledge of Python or R for data manipulation and analysis.
- Data Visualization: Experience with data visualization tools (e.g., Tableau, Power BI).
- Big Data Technologies: Familiarity with big data technologies (e.g., Hadoop, Spark).
- Data Governance: Understanding of data governance and compliance standards.
- Agile Methodologies: Experience working in Agile development environments.
Qualifications:
- Bachelor's or masters degree in computer science, Information Technology, Data Science, or a related field.
- 8+ years of experience
- Proven track record of designing and implementing data solutions using Snowflake.
Qualities:
- Analytical Mindset: Strong analytical and problem-solving skills.
- Collaboration: Excellent communication and teamwork abilities.
- Detail-Oriented: High attention to detail and commitment to data quality.
- Adaptability: Ability to adapt to changing business needs and technologies.
- Leadership: Demonstrated leadership skills and the ability to mentor junior team members.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: Software DevelopmentRole: Solution ArchitectEmployement Type: Full timeContact Details:
Company: InfoCeptsLocation(s): Pune
Keyskills: analytical data warehousing data pipeline sql security optimization spark gcp leadership hadoop big data communication skills architecture snowflake development python performance tuning microsoft azure power bi elt tableau r framework teamwork data governance agile aws
InfoCepts
About Accenture\\\\r\\\\n\\\\r\\\\n \\\\r\\\\n\\\\r\\\\nAccenture is a global professional services company with leading capabilities in digital, cloud and security. Combining unmatched experience and specialized skills across more than 40 industries, we offer Strategy and Consulting, Interactive, T...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in