Snowflake Architect

Skills

Experience required designing relational database schemas stored procedures and views for performance with large data sets Familiar in: NoSQL\NewSQL databases SDLC methodologies; defect tracking (JIRA DevOps ServiceNow etc). Experience/Familiarity with Master Data Management & related tools Proven track record of full project lifecycle and development as well as post-implementation support activities Experience Design development modification and testing of databases designed to support Data Warehousing and BI business teams Strong documentation capability and consistency to testing and release management standards

Description

Lead Developer Snowflake Architect - As a Lead Developer Snowflake Architect, you will play a crucial role in designing and implementing data solutions using the Snowflake cloud data platform. Your primary responsibility will be to lead a team of developers and data engineers to build scalable and high-performance data solutions, ensuring data integrity, security, and efficiency.

Responsibilities

• Snowflake Architecture and Design: Collaborate with stakeholders, data engineers, and business analysts to design and architect data solutions based on the Snowflake cloud data platform. Create detailed data models and schema designs to support various business requirements.
• Harness Snowpark's multi-language capabilities to create efficient and modular code.
• Develop custom user-defined functions (UDFs) to extend Snowflake's native capabilities and optimize query performance.
• Technical Leadership: Lead a team of developers and data engineers, providing technical guidance, mentoring, and support throughout the development lifecycle. Drive best practices, code reviews, and ensure the team follows industry standards and conventions.
• Data Integration: Develop and maintain data integration workflows to ingest, process, and transform data from various sources into Snowflake. Implement ETL/ELT processes to ensure data accuracy and consistency.
• Performance Optimization: Optimize Snowflake database performance by tuning queries, optimizing data structures, and improving data loading and extraction processes. Monitor system performance and troubleshoot issues when they arise.
• Security and Governance: Implement and enforce data security measures, access controls, and data governance policies within Snowflake. Ensure compliance with data privacy regulations and industry standards.
• Collaboration: Collaborate with cross-functional teams, including data analysts, data scientists, and business stakeholders, to understand data requirements and deliver comprehensive solutions.
• Cloud Infrastructure: Work closely with cloud infrastructure teams to ensure the Snowflake environment is properly configured, monitored, and scaled to meet performance and availability requirements.
• Continuous Improvement: Stay up-to-date with the latest advancements in Snowflake and cloud technologies. Propose and implement improvements to enhance the overall data architecture and development processes.

Experience Requirements

• 15+ years of Technology industry experience; bachelor’s degree in IT or related fields.
• Proven experience as a Snowflake Architect or similar role, with hands-on experience in architecting and implementing data solutions on the Snowflake cloud data platform.
• Strong proficiency in SQL, data modeling, and database design principles.
• Solid understanding of data warehousing concepts, ETL/ELT processes, and data integration methodologies.
• Experience in leading and managing a team of developers and data engineers.
• Familiarity with cloud platforms like AWS, Azure, or GCP, with specific expertise in Snowflake's integration with cloud services.
• Excellent problem-solving skills and the ability to troubleshoot and resolve complex data-related issues.
• Strong communication and interpersonal skills to collaborate effectively with various stakeholders.