Senior Data Architect

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, GitHub 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 GitHub->

DBT->

Snowflake integrations.

Excellent communication, working in Agile Methodology / Scrum.

Skills and Qualifications :

Strong analytical and problem-solving skills with high attention to detail.