Apply on Employer Site

LTIMindtree · 1 month ago

Snowflake DBT Engineer

Irvine - California - USA

Full-time

Onsite

Senior Level, Lead/Staff

8+ years exp

LTIMindtree is seeking a Snowflake DBT Engineer to design, develop, and maintain ELT pipelines using Snowflake and DBT. The role involves optimizing data models, implementing SQL transformations, and collaborating with stakeholders to translate requirements into technical solutions.

ConsultingEnterpriseInformation TechnologySoftware

H1B Sponsor Likely

Responsibilities

Design develop and maintain ELT pipelines using Snowflake and DBT

Build and optimize data models in Snowflake to support analytics and reporting

Implement modular testable SQL transformations using DBT

Integrate DBT workflows into CICD pipelines and manage infrastructure as code using Terraform

Collaborate with data scientists analysts and business stakeholders to translate requirements into technical solutions

Optimize Snowflake performance through clustering partitioning indexing and materialized views

Automate data ingestion and transformation workflows using Airflow or similar orchestration tools

Ensure data quality governance and security across pipelines

Troubleshoot and resolve performance bottlenecks and data issues

Maintain documentation for data architecture pipelines and operational procedures

Qualification

SnowflakeDBTSQLPythonCloud platformsGitCICDInfrastructure as CodeData modeling

Required

Bachelors or Masters degree in Computer Science Data Engineering or related field

7 years of experience in data engineering with at least 2 years focused on Snowflake and DBT

Strong proficiency in SQL and Python

Experience with cloud platforms AWS GCP or Azure

Familiarity with Git CICD and Infrastructure as Code tools Terraform CloudFormation

Knowledge of data modeling star schema normalization and ELT best practices

Benefits

Comprehensive Medical Plan Covering Medical, Dental, Vision

Short Term and Long-Term Disability Coverage

401(k) Plan with Company match

Life Insurance

Vacation Time, Sick Leave, Paid Holidays

Paid Paternity and Maternity Leave

Company

LTIMindtree

Glassdoor3.6

LTIMindtree is a worldwide technology consulting and digital solutions company that empowers businesses in a variety of sectors.

Founded in 1996

Mumbai, Maharashtra, IND

10001+ employees

https://www.ltimindtree.com

H1B Sponsorship

LTIMindtree has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (2651)

2024 (2855)

2023 (2267)