Tata Consultancy Services ยท 3 hours ago
Technical Lead
Los Angeles, CA
Full-time
Onsite
Senior Level, Lead/Staff
$130K/yr - $140K/yrTata Consultancy Services is seeking a highly skilled DBT Data Engineer / Developer to design, develop, and optimize scalable ELT pipelines and data models. The role involves ensuring data quality, driving architectural decisions, and enabling analytics through well-managed data transformations.
Business Information SystemsConsultingInformation TechnologyIT Management
Responsibilities
Design, develop, and optimize modular DBT data models (staging, intermediate, marts) using SQL and Jinja
Build and maintain ELT pipelines using DBT and other ingestion tools
Collaborate with data engineers, analysts, and business stakeholders to translate requirements into data transformations
Implement and maintain automated testing, documentation, and version control for DBT projects
Optimize Snowflake data warehouse performance for both storage and query cost efficiency
Drive data modeling and architecture decisions using best practices and reusable design patterns
Troubleshoot and resolve issues in DBT models and data pipelines
Maintain up-to-date and well-organized DBT Docs and metadata
Ensure data governance and lineage visibility through structured development
Participate in agile ceremonies, sprint planning, and backlog grooming
Support continuous integration and deployment using CI/CD pipelines for DBT projects
Stay informed about modern data stack trends and contribute to innovation
Qualification
Required
Hands-on experience with DBT (Data Build Tool) in a production environment
Strong SQL skills with advanced knowledge of joins, CTEs, window functions, and optimization
Experience working with Snowflake (or similar cloud data warehouse platforms)
Understanding of ELT/ETL pipelines, data transformation, and data modeling principles
Familiarity with Jinja macros, DBT configurations, and best practices for modular data design
Knowledge of version control systems like Git
Experience working in agile teams and cross-functional collaboration
Strong analytical thinking, problem-solving abilities, and communication skills
Preferred
Experience with orchestration tools such as Apache Airflow, Dagster, or Prefect
Exposure to Fivetran, Stitch, or other data ingestion tools
Familiarity with data governance, data lineage, and metadata management frameworks
Hands-on with CI/CD tools (e.g., GitHub Actions, GitLab CI, Jenkins) for DBT deployment automation
Experience with BI tools (e.g., Looker, Tableau, Power BI) and understanding of analytics needs
Knowledge of data contracts, observability, and monitoring tools
Understanding of data security, access controls, and compliance in a cloud environment
Company
Tata Consultancy Services
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.
Founded in 1968
10001+ employees
H1B Sponsorship
Tata Consultancy Services 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 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)
Funding
Current Stage
Public CompanyTotal Funding
unknown2004-08-25IPO
Leadership Team
K. Krithivasan
Chief Executive Officer & Managing Director
Aarthi Subramanian
President and Chief Operating Officer
Recent News
Business Standard India
2026-01-14
2026-01-14
2026-01-14
Company data provided by crunchbase