Experiance Level - 5-15 years (SSE/AM/Manager/Senior Manager)
Role & 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.
- 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 DevOps to create more software faster.
- Excellent communication, working in Agile Methodology/Scrum