Lead Snowflake Data Architect

Job Responsibilities

· Design, Develop, Unit Test and Implement Snowflake Datawarehouse artifacts by analyzing the requirements

· Work directly with System architects to understand the business needs, develop and deliver optimized snowflake data models

· Develop Integrations with third party ETL Tools (C2C- Cloud to Cloud ,OP2C – On-premise to Cloud) and Manage pipelines

· Manage and Maintain GitHub and ADO pipelines with code using CI/CD approach.

Must Have skill sets:

· Hands on experience with Snowflake data warehousing platform, architecture, processing and administration

· Experience with Azure or other cloud platforms

· Hands on Experience with Enterprise level Data warehousing models and concepts

· Hands on Experience with SQL performance measuring, query tuning and database tuning

· Able to Innovate, develop and follow best coding practices

· Develop Snowflake Integration with third-party tools and able to manage and maintain pipelines

· Hands on Experience with ADF and Integration with Third party tools and snowflake

· Hands on Experience with Snowflake modeling including but not limited to roles, databases, schemas, Store Procedures ,UDf’s,snowpipe,Shares and streams etc.

· Root cause analysis of models with solutions

· Time management skills to be able to execute multiple work items

· Ability to communicate well with customers to drive iterative feedback and requirements gathering

· Hands on Experience to manage and maintain GitHub ,ADO pipelines and code . Familiarize with CI/CD concepts .

· Strong analytical and problem-solving skills

· Advanced/Fluent in both written and verbal English

· Extensive knowledge of SQL

Nice to Have skill sets

· Working experience with large Data Analytics projects

· Experience with Power BI, Tableau and other visualization tools

· Programming languages like Python, Java, JavaScript

· Knowledge of the Agile Methodology

· Critical and out-of-the-box thinking

· Testing and test case preparation abilities