Snowflake DBT SQL Data Engineer

Tata Consultancy Service Limited10 months ago
San Jose, CA, United States
Hybrid
Full-time
Junior Level (1-3 years)

Job Description

Position Overview

The candidate will be responsible for leveraging Snowflake cloud computing and SQL expertise to design, develop, and optimize data warehousing solutions. This role involves working collaboratively with cross-functional teams, providing technical guidance, and driving performance improvements in a cloud data platform environment.

Key Responsibilities

  • Collaborate with various cross-functional groups and tech leads to design and implement data solutions.
  • Mentor and guide team members on Snowflake best practices and technical initiatives.
  • Optimize query performance and cost efficiency on the cloud data platform.
  • Develop and maintain robust data warehousing and data modeling frameworks.

Required Qualifications

  • Proficient in SQL and experienced with Snowflake cloud computing environments.
  • Strong understanding of data warehousing concepts, metadata management, and data modeling, including multi-dimensional models and data dictionaries.
  • Hands-on experience with Snowflake features such as Time Travel and Zero-Copy Cloning.
  • Experience in query performance tuning and cost optimization in a cloud platform.
  • Working knowledge of PLSQL, DBT, and data pipeline development.
  • Excellent personal communication, leadership, and organizational skills.
  • Proven ability to work closely with teams and guide them both technically and functionally.

Preferred Qualifications

  • Familiarity with various design patterns.
  • Knowledge of SQL database systems is a plus.

Benefits & Perks

  • Compensation: $70,000 - $130,000 a year

Required Skills

DBT
PLSQL
Metadata management
Multi-dimensional modeling
Design patterns
SQL
Cost optimization
Data warehousing
Data dictionaries
Data lakes
Data modeling
Cross-functional teamwork
Zero-Copy Cloning
Snowflake
Leadership
Time Travel
Query performance tuning
Communication