Position title

Snowflake Sr. Developer

Description

Minimum of 7 years' experience in successively progressive positions in database development using Snowflake and Microsoft SQL Server (or equivalent)
Demonstrated experience (3+ Years) in the development using Snowflake Cloud Data warehouse and utilizing Snowflake utilities such as Snow Pipe and Streams
Data integration utilizing AWS S3 bucket
Exposure to Time travel, Snow Tasks and data movement between Snowflake and other RDMS
Demonstrated experience (3+ Years) in cloud ETL tools; preferably Snaplogic
Strong experience in migration of relational databases to Snowflake
Strong knowledge, understanding and experience related to database modeling, design, and complex report development
Experience in implementation of control and reconciliation reports
Proficiency with Microsoft Office tools (Access, Excel, PowerPoint and Visio)
Strong understanding of various data formats including JSON & XML and experience with REST API consumption
Ability to analyze and comprehend complex data
Solid time management skills with the ability to organize and prioritize multiple tasks at the same time

Responsibilities

This includes documenting application source system databases, data requirements, development of database objects and partnering with IT to promote objects and ETL processes to the production environment
The resource will also be responsible for providing oversight and technical guidance to the Data Management team as well as other areas within Corporate Analytics
Write and modify complex Snow SQL queries, stored procedures, views, and triggers in addition to the development of other Snowflake database objects to support overall corporate objectives
Develop data models to ensure that the data objects provided are completely and accurately represented
Perform ad-hoc data queries in response to critical business needs
Create and maintain documentation related to applications, data sources, and ETL movement within the Corporate Analytics data environment
Maintain and regularly update database coding standards, ETL processes and procedures
Provide guidance, training and mentoring to all the development team members on coding standards and best practices
Reviews and identifies opportunities to optimize SQL queries for optimal performance
Enforce, follow, and improve Application Change Management procedures
Design, develop, manage, and support all existing job processes to ensure service levels are met
Implement automation of routine processes with appropriate monitoring controls
Develop, implement and maintain change control / testing processes for migration of database Objects across environments
Migration of database objects from the Microsoft SQL Server to Snowflake