Lead DBT & Snowflake Engineer

Tata Consultancy Services Limited; Los Angeles (CA); On-site; USD 110,000 - 140,000; Full time

Job summary

Tata Consultancy Services Limited in Woodland Hills, CA seeks a Lead DBT Developer to design, develop, and optimize data models and ELT pipelines using DBT in an agile environment.

The role requires expert Snowflake and SQL skills, mentoring engineers, leading code reviews, and collaborating with product stakeholders. Salary range is $110,000–$140,000 per year.

Strong problem solving and communication are essential to ensure data quality and scalable data architectures.

Qualifications

• Hands-on experience with DBT and Snowflake
• Strong SQL proficiency and data modeling
• Experience with CI/CD and version control
• Ability to mentor and lead reviews

Responsibilities

• Design, develop, and optimize data models and transformations using DBT
• Build and manage ELT pipelines using DBT and other tools
• Ensure data quality and integrity through testing and validation
• Collaborate with data engineers, analysts, and other stakeholders
• Optimize Snowflake performance and cost
• Drive data architecture decisions and implement best practices
• Develop and maintain documentation for DBT models and processes
• Stay updated with emerging data technologies and trends
• Troubleshoot data pipeline issues and provide support
• Potentially manage version control and CI/CD pipelines for DBT projects

Skills

DBT

Snowflake

SQL

Jinja macros

ETL/ELT

Data modeling

CI/CD

Git

Cloud platforms

Agile environment

Job description

Tata Consultancy Services Limited in Woodland Hills, CA seeks a Lead DBT Developer to design, develop, and optimize data models and ELT pipelines using DBT in an agile environment.

The role requires expert Snowflake and SQL skills, mentoring engineers, leading code reviews, and collaborating with product stakeholders. Salary range is $110,000–$140,000 per year.

Strong problem solving and communication are essential to ensure data quality and scalable data architectures.