Senior Data Architect

Location: Bengaluru

SNOWFLAKE ARCHITECT

Location:

Bengaluru, Pune, Gurugram, Kolkata, Chennai and Hyderabad
Primary

Roles and Responsibilities :

Working experience in Snowflake; use of Snow SQL CLI, Snow Pipe creation of custom functions and Snowflake stored producers, schema modelling, performance tuning etc.
Expertise in Snowflake data modelling, ELT using Snowflake SQL, Snowflake Task Orchestration implementing complex stored Procedures and standard DWH and ETL concepts
Extensive experience in DBT CLI, DBT Cloud, Git Hub version control and repository knowledge, and DBT scripting to design & develop SQL processes to perform complex ELT processes and data pipeline build.
Ability to independently envision and develop innovative ETL and reporting solutions and execute them through to completion.
Triage issues to find gaps in existing pipelines and fix the issues
Analyze the data quality, align the technical design to data governance, and address all the required non-business but operational requirements during the design and build of data pipelines
Develop and maintain data pipelines using DBT
Provide advice, guidance, and best practices around Snowflake
Provide guidance on moving data across different environments in Snowflake
Create relevant documentation around database objects
Troubleshoot production support issues post-deployment and come up with solutions as required
Good Understanding and knowledge of CI/CD process and Git Hub->DBT-> Snowflake integrations.
Advance SQL knowledge and hands-on experience in complex query writing using Analytical functions, Troubleshooting, problem-solving, and performance tuning of SQL queries accessing data warehouse as well as Strong knowledge of stored procedures.
Experience in Snowflake advanced concepts such as resource monitors, virtual warehouse sizing, query performance tuning, zero-copy clone, time travel and understanding how to use these features
Help joiner team members to resolve issues and technical challenges.
Drive technical discussions with client architect and team members
Good experience in developing scripts for data auditing and automating various database platform manual activities.
Understanding of the full software lifecycle and how development teams should work with Dev Ops to create more software faster.
Excellent communication, working in Agile Methodology/Scrum.

Skills and Qualifications :
Bachelor's and/or master's degree in computer science or equivalent experience.
Must have total 13+ yrs. of IT experience and 5+ years' experience in data Integration, ETL/ETL development, and database design or Data warehouse design
Deep understanding of Star and Snowflake dimensional modelling.
Strong knowledge of Data Management principles

Working experience in Snowflake; use of Snow SQL CLI, schema modelling, performance tuning etc.
Develop and maintain data pipelines using DBT

Experience with writing complex SQL queries, especially dynamic SQL
Expertise in Snowflake data modelling, ELT using Snowflake SQL, Snowflake Task Orchestration implementing complex stored Procedures and standard DWH and ETL concepts

Experience with performance tuning and optimization of SQL queries

Experience of working with Retail Data

Experience with data security and role-based access controls
Comfortable working in a dynamic, fast-paced, innovative environment with several ongoing concurrent projects
Should have experience working in Agile methodology
Strong verbal and written communication skills.
Strong analytical and problem-solving skills with high attention to detail.