Snowflake Consultant-4

Job Type: Contract Job Category: IT 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 SNOWFLAKE