Lead DBT Developer

Tata Consultancy Services; Los Angeles (CA); Presencial; USD 110.000 - 140.000; Jornada completa

Descripción de la vacante

Tata Consultancy Services in Los Angeles seeks a Lead DBT Developer to design, develop, and optimize data models using DBT and manage ELT pipelines. You will ensure data quality, collaborate with engineers and stakeholders, and drive best practices in a modern data stack.

The role requires strong Snowflake expertise, SQL mastery, and experience across AWS/Azure/GCP. You will mentor engineers, participate in design reviews, and contribute to the data program roadmap in an agile environment.

Formación

• Hands-on DBT development and maintenance required.
• Strong SQL proficiency and data modeling skills.
• Experience with Snowflake architecture and query optimization.
• Proficiency with AWS/Azure/GCP and version control (Git).
• Familiarity with CI/CD pipelines and workflow tools.

Responsabilidades

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

Conocimientos

DBT

Snowflake

SQL

Cloud Platforms

Git

CI/CD

Data Modeling

ELT/ETL

Herramientas

Git

CI/CD Tools

Snowflake

Descripción del empleo

Job Description

Lead DBT Developer

Must Have Technical/Functional Skills

• Experience in data engineering, specifically Snowflake and DBT.


• Key skills required are strong hands-on experience with DBT


• Expertise in building and managing data models using DBT commands, Jinja macros, and configurations, and proficiency in developing and managing DBT projects, testing, and documentation.


• Strong SQL proficiency, including advanced concepts, is essential.


• Experience with Snowflake's architecture and optimizing SQL queries for the platform is also necessary.


• A solid understanding of data warehousing architectures and ETL/ELT processes, data transformation, and quality is expected.


• Proficiency with cloud platforms like AWS, Azure, or GCP and experience with version control systems like Git are often required.


• Familiarity with CI/CD pipelines and workflow management tools is also beneficial.


• Excellent problem-solving, communication, and collaboration skills are vital, as is the ability to work in an agile environment


• Mentor engineers, lead design/code reviews, manage technical risks/dependencies, collaborate with product/business stakeholders, and drive roadmap

Roles & Responsibilities

• Design, develop, and optimize data models and transformations using DBT


• Build and manage ELT (Extract, Load, Transform) 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 (or other data warehouse) 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

Nice To Have

• P&C Insurance experience


• Coaching & Facilitation

Salary Range- $110,000-$140,000 a year