Senior SQL Developer (Snowflake)

Description

This position is fully Remote

The Senior Developer within the Corporate Analytics division reports directly to the Vice President of Data Management & Reporting and is responsible for the design, development, testing and promotion of database objects to support the Corporate Analytics initiatives

The Senior SQL Developer will be responsible for creating new database objects, maintaining existing objects and producing comprehensive documentation of all developed objects and repositories

The Senior SQL Developer will be responsible for identifying, documenting and consuming new data sources within the Corporate Analytics data environment.  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 

ESSENTIAL DUTIES AND RESPONSIBILITIES

•  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
• Migration of ETL packages from SSIS to Snaplogic

DESIRED SKILLS AND EXPERIENCE

• Development of use cases, test scripts and documentation to support database development
• Strong communication, interpersonal and presentation skills
• Demonstrated ability to work in teams and build collaborative relationships
• Experience operating in a complex and changing environment
• Experience with Cloud ETL tools such as Snaplogic ETL or equivalent
• Advanced analytical skills in the realm of modeling, data normalization, data mining, data manipulation and visualization

MINIMUM QUALIFICATIONS

• 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 Datawarehouse 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)
• Experience with SAS/ Python software products and Snowpark a plus
• 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