About the job

We are seeking an experienced Snowflake Lead to oversee the design, development, and implementation of data solutions on the Snowflake Data Cloud platform. The ideal candidate will have deep technical expertise in Snowflake, strong data architecture skills, and the ability to lead teams in delivering scalable and efficient data solutions. This role requires collaboration with business and technical teams to ensure the successful deployment of data solutions that align with organizational goals.

Responsibilities:

1. Data Architecture and Solution Design:

   • Design and implement robust data architecture on the Snowflake platform to meet business and analytical requirements.
   • Define standards for Snowflake usage, including security, performance optimization, and scalability.
   • Develop data models and optimize database design to enhance query performance.

2. Leadership and Collaboration:

   • Lead and mentor a team of developers, ensuring best practices in Snowflake development and deployment.
   • Collaborate with cross-functional teams, including data engineering, analytics, and business stakeholders, to deliver high-quality solutions.
   • Provide technical leadership in troubleshooting and resolving Snowflake-related issues.

3. Development and Deployment:

   • Implement ETL/ELT pipelines using Snowflake’s capabilities and integration with tools like DBT, Matillion, or Informatica.
   • Design and implement secure data-sharing models within Snowflake.
   • Automate data ingestion, transformation, and processing workflows for structured and semi-structured data.

4. Performance Tuning and Optimization:

   • Monitor and optimize Snowflake performance, including query tuning and storage management.
   • Analyze and resolve performance bottlenecks, ensuring high system reliability and efficiency.

5. Security and Compliance:

   • Ensure data security and compliance with organizational and regulatory standards.
   • Implement robust access controls, data masking, and encryption as needed.

6. Documentation and Knowledge Sharing:

   • Create and maintain comprehensive documentation for Snowflake solutions, including architecture diagrams, data pipelines, and operational processes.
   • Conduct training sessions and knowledge-sharing initiatives to upskill team members.

Qualifications:

Required Skills:

• Extensive hands-on experience with Snowflake, including architecture, administration, and development.
• Proficiency in SQL and experience with ETL/ELT processes and tools.
• Strong understanding of data modeling techniques, including star and snowflake schemas.
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Familiarity with integration tools like DBT, Matillion, or Informatica.
• Knowledge of data security, access control, and compliance practices.

Preferred Skills:

• Experience with programming languages such as Python or Java for data processing.
• Familiarity with DevOps practices and CI/CD pipelines.
• Exposure to data visualization tools like Tableau, Power BI, or Looker.

Required Skill Set