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
Qualifications
Master's Degree/Bachelor's Degree
Contacts
Hiring organization
Employment Type
Contractor
Industry
Software
Job Location
United States
Date posted
December 2, 2022
PDF Export
