Tech Lead (Snowflake)

Description:

1. Candidate with 10 years of experience and having good hands-on Snowflake Senior Developer specializing in the Snowflake cloud-based data warehousing platform on AWS/Azure cloud.
2. Responsible for designing, implementing, and managing complex data solutions within Snowflake, including data modeling, optimizing data pipelines, ensuring data integrity, and providing strategic guidance for complex data challenges.
3. Very good at building custom web applications using Python/Java and programmatically connecting to Snowflake databases, Data Exchanges and Snowflake Internal marketplace objects and able to expose the data on UI pages built on Python UI or Streamlit Libraries.
4. Good Data Engineering skills and thorough knowledge on Data sharing using Snowflake platform.
5. Often leading teams to develop data-driven applications while collaborating closely with other stakeholders to achieve business objectives.
6. Good knowledge of Snowflake SQL/PL SQL and Snowpark functions development with data warehousing principles.
7. Good understanding of Snowflake organization/Account/History tables/views for capturing History information, Query tuning, Caching and etc.

Skills & Responsibilities include:

• Solution design implementation skills:

Designing scalable data models and schemas within Snowflake, considering data access patterns and performance optimization.

• Data Pipeline Development:

Building and managing efficient data ingestion pipelines using Snowflake's data loading capabilities to integrate data from various sources.

• Deep Snowflake Knowledge:

Thorough understanding of Snowflake features like data warehousing concepts, storage options, data sharing, and security mechanisms

• SQL/PL SQL Optimization:

Writing and optimizing complex SQL queries to ensure efficient data retrieval and analysis within the Snowflake environment.

• Custom Web/native applications with Snowflake:

Developing Python or Java web applications deployable on to AWS, with good CI/CD skills specifically on Snowflake CI/CD and Integrating with Snowflake tables/views/objects across various accounts. Integrating Snowflake with other data processing tools and applications through Snowflake SQL/REST APIs and connectors.

• Performance Tuning:

Identifying and resolving performance bottlenecks in Snowflake queries and data pipelines

• Team Leadership:

Mentoring junior developers, providing technical guidance, and leading data projects

• Proficient in SQL specifically with Snowflake database:

Extensive experience writing complex SQL queries, including advanced functions and optimization techniques

• Data Modeling:

Ability to design efficient data models and schemas for optimal data access and analysis

• Data Engineering Skills:

Experience building data pipelines and ETL processes using Snowflake's data loading capabilities

• Cloud Computing Understanding:

Familiarity with cloud infrastructure (AWS, Azure, Google Cloud Platform) and how it integrates with Snowflake. Building web applications on AWS Containers and able to expose through End-points.

• Programming Skills (Python/Java):

Proficiency in Python or other scripting languages for data manipulation and automation.

Good experience using IDEs like VSCode/Anaconda and Integrating with Cloud tools from AWS/Azure

• Communication and Collaboration:

Excellent communication skills to collaborate effectively with data analysts, business users, and other technical teams