Associate Manager

About Tredence

Tredence is a global analytics services and solutions company. We are one of the fastest growing private companies in the country for three straight years according to the Inc. 5000 and we continue to set ourselves apart from our competitors by attracting the greatest talent in the data analytics and data science space. Our capabilities range from Data Visualization, Data Management to Advanced analytics, Big Data and Machine Learning. Our uniqueness is in building Scalable Big Data Solutions on Onprem/GCP/Azure cloud in a very cost effective and easily scalable manner for our clients. We also come in with some strong IP and pre-built analytics solutions in data mining, BI and Big Data. 

Job Summary

Job Location

Roles & Responsibilities

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

Qualification & Experience

Why Join Tredence?

There is a reason we are one of the fastest growing private companies in the country! You will have the opportunity to work with some of the smartest and fun-loving people in the data analytics space. You will work with the latest technologies and interface directly with the key decision stakeholders at our clients, some of the largest and most innovative businesses in the world. Our people are our greatest asset and we value every one of them. Come see why we’re so successful in one of the most competitive and fastest growing industries in the world.