Snowflake Data Architect - R01573923

Brillio

Pune

Hybrid

INR 4,200,000 - 8,000,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Snowflake Experts in Pune, India is seeking a seasoned Snowflake Data Architect to lead architectural design and implementation of scalable data platforms. The role focuses on Snowflake-based architectures, data integration, performance optimization, and governance within a hybrid work setup.

The candidate will drive ETL development, optimize complex SQL, and leverage Snowflake features like Zero Copy Cloning, Time Travel, and Snowpipe to deliver reliable analytics-ready data.

Qualifications

  • 10+ years of data architecture experience with Snowflake.
  • Design scalable Snowflake data platforms and modern data architectures.
  • Develop and optimize ETL pipelines and data integration.
  • Establish data governance, security, and compliance across Snowflake.

Responsibilities

  • Architect scalable Snowflake solutions with high performance.
  • Develop and maintain ETL pipelines for diverse sources.
  • Configure Snowflake features: Zero Copy Cloning, Time Travel, Fail Safe, Snowpipe.
  • Optimize SQL queries and stored procedures (PL/SQL, T-SQL).
  • Leverage Snowflake Data Exchange and SnowSight for data sharing and analytics.
  • Model complex data structures for BI and analytics.
  • Ensure data governance, security, and compliance across the platform.
  • Diagnose and resolve data architecture challenges and ensure data quality.

Skills

Snowflake architecture
ETL pipelines
SQL optimization
Python
SnowSQL
Zero Copy Cloning
Time Travel
Fail Safe
Snowpipe
Snowflake Data Exchange
SnowSight
Data modeling
Data governance

Education

Bachelor's degree in Computer Science or related field
SnowPro certification
Cloud data analytics or data warehousing certification

Tools

Informatica
Talend
Matillion
Kafka
AWS Kinesis
Snowflake UI

Job description

Snowflake Data Architect

Snowflake Experts, We're Looking for You!

Looking for a seasoned Snowflake Data Architect with the ability to combine deep technical expertise with architectural leadership. The role will focus on designing scalable Snowflake solutions, modern data architectures, migration strategies, performance optimization and data integration frameworks.

Primary Skills
  • ETL Fundamentals, Zero Copy Cloning, SQL, SnowSight, SQL (Basic + Advanced), Python,
  • Data Warehousing, Snowflake Data Exchange, Time Travel and Fail Safe, Snowpipe, SnowSQL,
  • Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
  • Exp- 10+yrs
  • Job Location - All Brillio (Hybrid mode)
  • Notice- 0-45days max
  • 3 technical round includes one in-person interview at Brillio office(mandatory)
Specialization
  • Snowflake Data Architecture: Data Architect
  • Snowflake certification
Job requirements
  • Experience Range: With 10 to 18 years of experience in data architecture, including significant hands-on expertise in designing and implementing Snowflake data platforms.
  • Key Responsibilities:
  • 1. Architect and deliver scalable, high-performance data solutions utilizing Snowflake, ensuring reliability and optimal resource utilization across the organization.
  • 2. Develop, automate, and maintain robust ETL pipelines to enable seamless data integration, transformation, and loading from diverse sources.
  • 3. Configure and administer advanced Snowflake features such as Zero Copy Cloning, Time Travel, Fail Safe, and Snowpipe to maximize data accessibility and recovery capabilities.
  • 4. Optimize complex SQL queries and stored procedures (PLSQL, T-SQL) to enhance data warehousing efficiency and throughput for analytics workloads.
  • 5. Leverage Snowflake Data Exchange and SnowSight to facilitate secure data sharing and deliver actionable analytics to business stakeholders.
  • 6. Design & model intricate data structures to support business intelligence, reporting, and analytics initiatives, ensuring scalability and performance.
  • 7. Establish & enforce data governance, security, and compliance standards across the Snowflake platform in collaboration with cross-functional teams. 8. Diagnose and resolve data architecture challenges, ensuring high standards of data quality, consistency, and availability.
  • Required Skills:
  • 1. Expert-level proficiency in Snowflake data architecture
  • 2. Advanced ETL pipeline development and automation
  • 3. Complex SQL query optimization and stored procedure development (PLSQL, T-SQL)
  • 4. Administration of Snowflake features including Zero Copy Cloning, Time Travel, Fail Safe, and Snowpipe
  • 5. Hands-on experience with SnowSQL and Python for data engineering
  • 6. Deep understanding of data warehousing concepts and data modeling
  • 7. Experience with Snowflake Data Exchange
  • Preferred Skills:
  • 1. Proficiency with SnowSight for advanced analytics and visualization
  • 2. Experience with cloud-based data integration tools such as Informatica, Talend, or Matillion
  • 3. Expertise in optimizing large-scale, distributed data workloads
  • 4. Experience with real-time data streaming solutions such as Kafka or AWS Kinesis
  • 5. Advanced troubleshooting and performance tuning in Snowflake environments
  • Desired Qualifications:
  • 1. Bachelor's degree in Computer Science, Information Technology, data engineering or a closely related field
  • 2. Snowflake SnowPro certification
  • 3. Certification in data warehousing or cloud data platforms, such as AWS Certified Data Analytics or Microsoft Certified: Azure Data Engineer Associate
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Snowflake Data Architect – R01573923
Snowflake Data Architect – R01573923

Brillio • Bengaluru

On-site
INR 4,500,000 - 6,000,000
Snowflake Solution Architect
Snowflake Solution Architect

Marlabs Inc. • Bengaluru

On-site
INR 350,000 - 650,000
Snowflake Architect, Data Warehousing
Snowflake Architect, Data Warehousing

Cvent, Inc. • Gurugram District

On-site
INR 1,800,000 - 3,600,000
Data Architect
Data Architect

Gantec Corporation • Chennai

On-site
INR 3,500,000 - 5,500,000
Snowflake Architect
Snowflake Architect

Ascendion • Bengaluru

Hybrid
INR 3,500,000 - 7,000,000
Snowflake Architect
Snowflake Architect

Experion Technologies • Kochi

On-site
INR 3,000,000 - 4,200,000
Snowflake Data Warehouse Architect
Snowflake Data Warehouse Architect

TechStar Group • Hyderabad

Hybrid
INR 3,500,000 - 7,000,000
Snowflake Data Engineer
Snowflake Data Engineer

Genpact Ltd. • Hyderabad, Bengaluru, Delhi

On-site
INR 3,500,000 - 7,000,000
Snowflake Data Warehouse Lead
Snowflake Data Warehouse Lead

Vrinda International • Pune District

On-site
INR 1,800,000 - 2,200,000
Snowflake Data Architect
Snowflake Data Architect

HCLTech • Bengaluru

On-site
INR 3,500,000 - 5,500,000
Data governance tools exposure
Real-time data streaming exposure
Certifications in Snowflake / Cloud