Snowflake / Big Data / Cloud Tech Lead

Job Description

Job Description

Role : Snowflake / Big Data / Cloud Tech Lead

Location : NYC, NY

Duration : 3 6 Months

Very good at Programming in Python and Pyspark, Java, Notebook development using VSCode and performance improvement practices

Job description Snowflake Applications Senior developer Jefferies :

Description :

• 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.
• 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.
• 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.
• Good Data Engineering skills and thorough knowledge on Data sharing using Snowflake platform.
• Often leading teams to develop data-driven applications while collaborating closely with other stakeholders to achieve business objectives.
• Good knowledge of Snowflake SQL / PL SQL and Snowpark functions development with data warehousing principles.
• Good understanding of Snowflake organization / Account / History tables / views for capturing History information, Query tuning, Caching and etc.

Skills & Responsibilities include :

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

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

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

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

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.

Identifying and resolving performance bottlenecks in Snowflake queries and data pipelines

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

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

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

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

Familiarity with cloud infrastructure (AWS, Azure, GCP) and how it integrates with Snowflake. Building web applications on AWS Containers and able to expose through Endpoints.

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

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