Snowflake Data Engineer

About Tredence:

Tredence is a global data science solutions provider founded in 2013 by Shub Bhowmick, Sumit Mehra, and Shashank Dubey focused on solving the last-mile problem in AI. Headquartered in San Jose, California, the company embraces a vertical-first approach and an outcome-driven mindset to help clients win and accelerate value realization from their analytics investments. The aim is to bridge the gap between insight delivery and value realization by providing customers with a differentiated approach to data and analytics through tailor-made solutions. Tredence is 3500-plus employees strong with offices in San Jose, Foster City, Chicago, London, Toronto, and Bangalore, with the largest companies in retail, CPG, hi-tech, telecom, healthcare, travel, and industrials as clients.

We’re focused on bridging the gap between insights delivery and value realization, partnering with our clients to help them cross the last mile gap in analytics. This DNA pushes our ecosystem to go beyond possible, helping our clients re-think their limitations and overcome their norms of ‘possible’.

As we complete 12 years of Tredence this year, we are on the cusp of an ambitious and exciting phase of expansion and growth.

• Tredence recently closed a USD 175 million Series B funding, which will help us build on growth momentum, strengthen vertical capabilities, and reach a broader customer base.
• 3,500 data scientists - Every person at Tredence brings their whole self to work and helps us create a culture of curiosity and innovation
• 10+ global delivery centres - Enabling user-driven analytics for some of the world’s largest Fortune 50 companies
• 75+ global customers - Trust us to help them create sustainable impact by systematizing the last mile adoption of analytics
• Unprecedented operational excellence- with AI and self-service to solve complex problems across the enterprise value chain
• One enterprise AI studio- offering a co-innovation platform and market place for AI and advanced analytics solutions to move innovation from experimentation to value realization
• Acquired Further Advisory to Accelerate Banking & Financial Services Transformation
• Was Awarded 2025 Google Cloud Industry Solutions Partner of the Year for CPG
• At Tredence, nothing is impossible; we believe in pushing ourselves to limitless possibilities and staying true to our tagline, Beyond Possible

Primary Roles and Responsibilities:

● Developing Modern Data Warehouse solutions using Snowflake, Databricks and ADF.

● Ability to provide solutions that are forward-thinking in data engineering and analytics space

● Collaborate with DW/BI leads to understand new ETL pipeline development requirements.

● Triage issues to find gaps in existing pipelines and fix the issues

● Work with business to understand the need in the reporting layer and develop a data model to fulfill reporting needs

● Help joiner team members to resolve issues and technical challenges.

● Drive technical discussions with client architect and team members

● Orchestrate the data pipelines in the scheduler via Airflow Skills and Qualifications:

● Bachelor's and/or master’s degree in computer science or equivalent experience.

● Must have total 6+ yrs. of IT experience and 3+ years' experience in Data warehouse/ETL projects.

● Expertise in Snowflake security, Snowflake SQL and designing/implementing other Snowflake objects.

● Hands-on experience with Snowflake utilities, SnowSQL, Snowpipe, Snowsight and Snowflake connectors.

● Deep understanding of Star and Snowflake dimensional modeling.

● Strong knowledge of Data Management principles

● Good understanding of Databricks Data & AI platform and Databricks Delta Lake Architecture

● Should have hands-on experience in SQL and Spark (PySpark)

● Experience in building ETL / data warehouse transformation processes

● Experience with Open Source non-relational / NoSQL data repositories (incl. MongoDB, Cassandra, Neo4J)

● Experience working with structured and unstructured data including imaging & geospatial data. ● Experience working in a Dev/Ops environment with tools such as Terraform, CircleCI, GIT.

● Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning, troubleshooting and Query Optimization.

● Databricks Certified Data Engineer Associate/Professional Certification (Desirable).

● 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 a high attention to detail.

Mandatory Skills