Data Analytics - Snowflake Technical Engineering Lead, AVP

Who we are looking for Why this role is important to usWe are looking for a Data Analytics (Snowflake) Technical Engineering Lead, AVP to join our Data Platform Engineering team, whose mission is to engineer and deliver self-service, performant and resilient data services platform to enable world class product development.

Why this role is important to usWe are looking for an experienced Snowflake technical engineering leader who will be responsible for planning, designing, developing and maintaining the data architecture, data models and best practices standards for various Data Analytics & Integration projects in Snowflake. What you will be responsible forYou will be responsible to incorporate new features and ensure all subject areas are modelled to integrate with existing structures.

You will be expected to create & continuously enhance documentation of the deployments & best practices pertaining to implementation of data architectures, data flows and data models in the platform. You will work within a global team to develop and maintain automation that enable self-service & management capabilities of the platform as part of the operating model. This role requires a broad range of skills and the ability to step into different roles depending on the size and scope of the projects.

What we value

These skills will help you succeed in this role

The candidate must exhibit ability to lead and successfully complete multiple, complex technical projects and create high-level design and architecture of the solution - includes design & deployment infrastructure  a self-starter and take ownership of technical solutions from design and architecture perspective for projects, help navigate complex use-cases to provide guidance on fit-for-platform

Deliver using an Onshore/Offshore model in a matrix org structure Gather end user requirements and writing technical documentation

Provide innovative solutions based on new technologies and latest product features.

Work closely with application development team to understand the business, capture requirements, identify pain areas, accordingly, propose an ideal solution to grow business.

Managing pipelines using Terraform scripts to deploy resources

Provide engineering analysis and support for creating Snowflake accounts and onboarding new projects – ensuring enterprise security/compliance standards are strictly enforced.

Provide Administrative support closely working with vendor for any environment issues.

Understand the needs of automation and put forth options for solutions.

Work with production management and cloud teams to analyze and provide solutions for database related automation and solution

Education and preferred qualifications

Candidate must have experience working with Snowflake and 5+ years of experience in Data Analytics, & Integration projects.

Must have prior experience with end to end implementation of Snowflake cloud data warehouse – on AWS & Azure, optionally on GCP.

Skills & experience must include deep expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel, cost governance, and be able to provide guidance on how to use these features

Should be well versed in in Snowflake - data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts

Experience in development and management of CI/CD pipelines using GIT repositories and Dev Ops for Infrastructure-as-Code deployments (terraform, ansible, python, etc.)Hands-on experience with Snowflake utilities, SnowSQL, Snow Pipe, other bigdata migration techniques using scripting (python, etc.) or industry standards tools (golden gate…