Associate Manager - Snowflake

Date: Sep 8, 2022

Location: San jose, United States

Company: Tredence

About Tredence


Recognized as a Leader in Customer Analytics by Forrester Research, 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 On-prem/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 Location

San Jose, CA

Roles & Responsibilities

Manage end to end delivery by Investigating problem areas, working cross-functionally with product manager & other stakeholders. 

Follow the Agile development methodology; think strategically and execute methodically. 

Provides information to client and leadership by collecting, analyzing, and summarizing development and service issues. 

Develop and manage capacity and growth projection forecasts of the environment within budgets. 

Required to understand encounter and clinical data sets and the data flows from upstream & downstream systems to ensure the incentive engine is accurately implemented. 

You can independently figure out technical challenges, identify options and come up with innovative solutions. 

You can do Analysis, Design, Estimation and Development of the database components. 

Create and maintain optimal data pipeline architecture, assemble large, complex data sets that meet functional / non-functional business requirements.

Qualification & Experience

4 -8 years of relevant experience. 

At least 3 years’ experience on Snowflake Data warehouse. 

Strong experience and hands on with Python, Airflow. 

Strong technical experience in Migrating data from Legacy databases like Oracle, SQL Server to Snowflake. 

Strong understanding of Structured and Semi-structured formats data loading - Hands on experience on Data warehouse & ETL/ELT development with at least 1 Snowflake implementations. 

Hands on Snowflake experience with Snowflake utilities & features such as SnowSQL, Snowpipe, Tasks, Streams, Time Travel, Cloning, Optimizer, data sharing , JavaScript stored procedure and UDF. 

Good understanding on roles, stages, RBAC, Views and database change management. 

Architecture Design Experience for Cloud and Non-cloud platforms. 

Expertise on AWS Services.