Principal Architect - R01571497

Principal Architect

Primary Skills: DataStream, 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 Procedures

Specialization: Snowflake Engineering: Principal Data Architect

Job requirements: 15 to 18 years of experience in data architecture and engineering, including extensive expertise in Snowflake and modern data platforms

Key Responsibilities:

• Design and architect scalable, secure, and high-performance Snowflake data solutions to drive enterprise data initiatives.
• Develop and implement robust ETL pipelines using Snowflake Streams, Python, and SQL to enable efficient data ingestion and transformation.
• Optimize Snowflake environments for performance, cost, and reliability by leveraging features such as Time Travel, Fail Safe, and Snowpipe.
• Lead the modeling and structuring of complex Snowflake data warehouses, ensuring data integrity, accessibility, and scalability.
• Configure and manage SnowSQL, stored procedures, and advanced SQL scripts to automate data processing and analytics workflows.
• Collaborate with cross-functional teams to define data platform requirements and deliver modern data solutions aligned with business objectives.
• Troubleshoot and resolve architectural and operational issues within Snowflake and related data platforms, ensuring minimal downtime.
• Mentor and guide junior architects and engineers on best practices in Snowflake engineering and data platform fundamentals.
• Required Skills: Expertise in Snowflake architecture and engineering
• Advanced proficiency in SQL
• Strong experience with Python for data processing and automation
• Deep understanding of ETL pipeline development
• Hands-on experience with Snowflake Streams for real-time data ingestion
• Proficiency in Time Travel and Fail Safe features within Snowflake
• Implementation and management of Snowpipe for automated data loading
• Skilled in SnowSQL for scripting and data management
• Experience in Snowflake-specific data modeling and warehouse design
• Expertise in developing and managing Snowflake stored procedures
• Preferred Skills: Experience integrating Snowflake with cloud platforms such as AWS or Azure
• Expertise in advanced data security and governance practices
• Knowledge of performance tuning and optimization for large-scale Snowflake workloads
• Familiarity with emerging data engineering technologies and frameworks
• Experience with orchestration tools for automating data pipelines (e.g., Apache Airflow, dbt)
• Hands-on experience with real-time analytics and streaming data solutions
• Desired Qualifications: Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a closely related discipline
• Snowflake SnowPro Advanced Architect certification or equivalent
• Certification in data warehousing or cloud data platform architecture (e.g., AWS Certified Data Analytics, Microsoft Certified: Azure Data Engineer Associate)