Principal Architect

Principal ArchitectPrimary SkillsDataStream, ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored ProceduresSpecializationSnowflake Engineering: Principal Data ArchitectJob RequirementsExperience Range: 15 to 18 years of experience in data architecture and engineering, including extensive expertise in Snowflake and modern data platformsKey Responsibilities:Design and architect scalable, secure, and high-performance Snowflake data solutions to drive enterprise data initiativesDevelop and implement robust ETL pipelines using Snowflake Streams, Python, and SQL to enable efficient data ingestion and transformationOptimize Snowflake environments for performance, cost, and reliability by leveraging features such as Time Travel, Fail Safe, and SnowpipeLead the modeling and structuring of complex Snowflake data warehouses, ensuring data integrity, accessibility, and scalabilityConfigure and manage SnowSQL, stored procedures, and advanced SQL scripts to automate data processing and analytics workflowsCollaborate with cross-functional teams to define data platform requirements and deliver modern data solutions aligned with business objectivesTroubleshoot and resolve architectural and operational issues within Snowflake and related data platforms, ensuring minimal downtimeMentor and guide junior architects and engineers on best practices in Snowflake engineering and data platform fundamentalsRequired Skills:Expertise in Snowflake architecture and engineeringAdvanced proficiency in SQLStrong experience with Python for data processing and automationDeep understanding of ETL pipeline developmentHands-on experience with Snowflake Streams for real-time data ingestionProficiency in Time Travel and Fail Safe features within SnowflakeImplementation and management of Snowpipe for automated data loadingSkilled in SnowSQL for scripting and data managementExperience in Snowflake-specific data modeling and warehouse designExpertise in developing and managing Snowflake stored proceduresPreferred Skills:Experience integrating Snowflake with cloud platforms such as AWS or AzureExpertise in advanced data security and governance practicesKnowledge of performance tuning and optimization for large-scale Snowflake workloadsFamiliarity with emerging data engineering technologies and frameworksExperience with orchestration tools for automating data pipelines (e.g., Apache Airflow, dbt)Hands-on experience with real-time analytics and streaming data solutionsDesired Qualifications:Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a closely related disciplineSnowflake SnowPro Advanced Architect certification or equivalentCertification in data warehousing or cloud data platform architecture (e.g., AWS Certified Data Analytics, Microsoft Certified: Azure Data Engineer Associate)Additional Information: Immediate joiner required