Job Type: Contract

Job Category: IT

Job Description

A Snowflake Lead/Architect is a senior data professional who designs and oversees the implementation of enterprise-grade data platforms using the Snowflake Data Cloud. This role combines technical leadership with deep hands-on expertise to build scalable, secure, and high-performance data solutions that support analytics, data science, and business intelligence initiatives.

Role and responsibilities

• Architect and design solutions: Lead the design and implementation of end-to-end data warehousing and analytics solutions on the Snowflake platform. This includes defining architectural standards, data models, and ETL/ELT pipeline designs.
• Technical leadership: Act as a subject matter expert and provide technical guidance to data engineering teams. Drive best practices for code reviews, testing, documentation, and overall quality assurance.
• Data pipeline development: Oversee the development and optimization of robust data pipelines using Snowflake, Snowpipe, Snowpark, and tools like DBT, Python, and Airflow.
• Performance optimization: Monitor and tune Snowflake performance to ensure scalability, reliability, and cost-effectiveness. This involves managing virtual warehouses, storage layers, and optimizing queries.
• Data governance and security: Define and enforce standards for data governance, security, and compliance within Snowflake. Implement features like object tagging, data masking, row-level security, and data clean rooms.
• Stakeholder collaboration: Work closely with business stakeholders, data analysts, and other technical teams to translate business requirements into technical solutions.
• Innovation and evangelism: Stay current with Snowflake features and industry trends. Advocate for and guide the adoption of new capabilities, potentially acting as a technical evangelist for the platform.
• Migration strategy: For migrations, the architect designs and leads the strategy to move data from legacy platforms to Snowflake.

Essential skills and qualifications

• Experience:
• Significant experience (typically 8–10+ years) in data warehousing, data engineering, and solution architecture, with a minimum of 3–5 years focused specifically on Snowflake.
• Experience in a technical leadership or mentoring role.
• Technical expertise:
• Deep knowledge of Snowflake's architecture, including virtual warehouses, data storage, and security features.
• Proficiency in Snowflake SQL, scripting, and stored procedures.
• Extensive experience with ETL/ELT processes and tools like DBT, Airflow, and Python.
• Familiarity with major cloud platforms (AWS, Azure, GCP) and how Snowflake integrates with their services.
• Strong understanding of data modeling techniques (e.g., star schema, data vault).
• Soft skills:
• Excellent communication and presentation skills to effectively interact with both technical and non-technical audiences.
• Strong analytical and problem-solving abilities.
• Demonstrated ability to lead projects and collaborate with cross-functional teams.
• Education and certifications:
• A bachelor's degree in Computer Science, Information Technology, or a related field is typically required.
• Relevant Snowflake certifications, such as the SnowPro Advanced: Architect Certification, are often preferred.

Required Skills