Snowflake Data Architect - R01573923

Brillio 2
Bangalore +1 more
Hybrid

Who this role is best for

Strong fit for experienced data architects who design scalable Snowflake solutions and optimize complex data workloads.

Best fit for

  • Candidates with 10+ years of data architecture experience and Snowflake certification
    — “With 10 to 18 years of experience in data architecture, including significant hands-on expertise in designing and implementing Snowflake data platforms.”
  • Individuals who have led ETL pipeline automation and large-scale data integration projects
    — “Develop, automate, and maintain robust ETL pipelines to enable seamless data integration, transformation, and loading from diverse sources.”
  • Professionals with a background in cloud data platforms and advanced SQL optimization
    — “Optimize complex SQL queries and stored procedures (PLSQL, T-SQL) to enhance data warehousing efficiency and throughput for analytics workloads.”

Things to consider

  • Mandatory in-person interview at Brillio office may require travel or relocation
    — “3 technical round includes one in-person interview at Brillio office(mandatory)”
  • Candidates must be available for immediate onboarding with up to 45 days notice period
    — “Notice- 0-45days max”

How to stand out

  • Highlight experience with Snowflake's advanced features like Zero Copy Cloning and Time Travel
    — “Configure and administer advanced Snowflake features such as Zero Copy Cloning, Time Travel, Fail Safe, and Snowpipe”
  • Quantify impact of past ETL pipeline optimizations and data governance implementations
    — “Diagnose and resolve data architecture challenges, ensuring high standards of data quality, consistency, and availability.”
  • Demonstrate hands-on SnowSQL and Python usage in data engineering contexts
    — “Hands-on experience with SnowSQL and Python for data engineering”
  • Showcase data modeling expertise that supports analytics and reporting initiatives
    — “Design and model intricate data structures to support business intelligence, reporting, and analytics initiatives”
Pace · Fast PacedCollaboration · HighAutonomy · MediumDecision Impact · Company

Derived from job-description analysis by Serendipath's career intelligence engine.

What success looks like

  • successful data platform implementation
  • optimized data warehousing efficiency
  • secure data sharing
Typical background
10+ years of data architecture experienceSnowflake certification

Skills & requirements

Required

SnowflakeETLSQLData WarehousingData ModelingStored Procedures

Preferred

SnowsightCloud-based Data Integration ToolsReal-time Data Streaming

Stack & domain

ETLSQLPythonData WarehousingSnowflake Data ExchangeTime TravelFail SafeSnowpipeSnowsqlPlsqlT-sqlStored ProceduresSnowflake Snowpro CertificationData ArchitectureCloud Data Platforms

About the role

Original posting from Brillio 2 via Lever

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 and model intricate data structures to support business intelligence, reporting, and analytics initiatives, ensuring scalability and performance.
  • 7. Establish and 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

Do share your profiles to anupa.dhing@brillio.com

Source: Brillio 2 careers (Lever)

Similar roles

More roles at Brillio 2