What are the responsibilities and job description for the Sr. Snowflake Application Developer position at Up2date Technologies?
Job Details
Role: Sr. Snowflake Application Developer
Location: NYC, NY(On-Site)
Duration: 6 Months Contract
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
