Snowflake Architect
- Tata Consultancy
- 5 - 10 years
- Pune
- 4 months ago
- Email to a friend
- Report this job
Job Description
Job Role: Snowflake Architect
Experience: 5-10 years
Location: Pan India
Skills and Experience Required
- 5+ years of overall experience in architecting and building data and analytics solutions including data modeling, ETL/ELT pipelines and performance optimization.
- Deep knowledge of Snowflake features such as virtual warehouses, micro-partitions, data sharing and security best practices.
- Strong SQL skills for complex queries, stored procedures, and optimization; familiarity with Python or other scripting languages for automation.
- Hands-on experience with Azure and/or AWS services (e.g., S3, Azure Data Lake, IAM, networking) for hybrid or multi-cloud architectures.
- Expertise in implementing role-based access control, encryption, compliance standards and auditing within Snowflake and cloud environments.
- Ability to optimize compute/storage costs, manage workloads, and tune queries for high performance.
- SnowPro Core or Advanced Architect certification is a strong plus.
- Ability to lead architecture discussions, mentor teams and collaborate with business and technical stakeholders
- Excellent communication, presentation, and interpersonal skills
- Experienced in working in a customer facing role
Responsibilities
- Conduct workshops with business and IT stakeholders to capture, document and summarize data, integration and analytics requirements for the Snowflake.
- Design optimized data models and schemas
- Integrate Snowflake with multiple data sources and platforms (onprem DBs, files, APIs, Azure/AWS services, Kafka/ETL tools) ensuring secure, reliable data ingestion and curation.
- Establish governance and security standardsRBAC, network policies, SSO/MFA, data classification, masking and secure data sharing across accounts/partners.
- Optimize performance and cost by tuning virtual warehouses, managing micropartitions/clustering, caching, query profiling and workload isolation for concurrency and throughput.
- Guide the technical team on architecture patterns and migration approaches (zerocopy cloning, Time Travel, Failsafe) and oversee implementation to production readiness.
- Conduct proofs of concept and create reusable accelerators and reference architectures.
- Guide technical team of deliverables and get the solution implemented
- Conduct proof of concepts and create differentiating assets
- Conduct training and workshops on new technologies and trends
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database Architect / DesignerEmployement Type: Full timeContact Details:
Company: Tata ConsultancyLocation(s): Pune
Keyskills: Architecture Snowflake Python Microsoft Azure Data Modeling AWS SQL
Similar positions
Tata Consultancy
EY | Building a better working world\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\nEY exi...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in