Tata Consultancy Services · 14 hours ago
Lead Data Engineer
Raleigh, NC
Full-time
Onsite
Senior Level, Lead/Staff
$100K/yr - $110K/yrTata Consultancy Services is seeking a Lead Data Engineer with expertise in Snowflake, DBT, and Qlik. The role involves designing and maintaining data transformation pipelines, collaborating with stakeholders to understand data requirements, and ensuring data quality and governance throughout the transformation process.
Business Information SystemsConsultingInformation TechnologyIT Management
Responsibilities
Design, develop, and maintain robust and scalable data transformation pipelines using dbt on the Snowflake platform
DBT Macro Development to Create and utilize Jinja-based DBT macros to promote code reusability, modularity, and dynamic SQL generation within DBT projects
Data Transformation & Orchestration to Implement and manage data transformation pipelines using DBT, integrating with various data sources and ensuring efficient data flow
Utilize advanced dbt concepts, including macros, materializations (e.g., incremental, view, table), snapshots, and configurations to build efficient data models
Write highly optimized and complex SQL queries for data manipulation, cleaning, aggregation, and transformation within dbt models
Implement and enforce best practices for dbt project structure, version control (Git), documentation, and testing
Collaborate with data analysts, engineers, and business stakeholders to understand data requirements and translate them into effective data models (e.g., star schema, snowflake schema)
Design and implement logical and physical data models within dbt to support analytical and reporting needs
Leverage Snowflake features and functionalities for performance optimization, including virtual warehouses, clustering, caching, and query optimization
Manage and optimize data ingestion and integration processes from various sources into Snowflake
Ensure data quality, integrity, and lineage throughout the data transformation process
Implement and maintain DBT tests to ensure data quality, integrity, and adherence to business rules
Implement and maintain data governance policies and procedures within the dbt environment
Develop and execute automated tests for dbt models to ensure data accuracy and reliability
Qualification
Required
Proven hands-on experience with dbt in a production environment, including extensive use of macros and advanced modeling techniques
Expert-level proficiency in SQL for data querying, manipulation, and transformation
Strong experience with Snowflake, including performance tuning and optimization
Solid understanding of data warehousing concepts and ETL/ELT processes
Experience with version control systems, particularly Git
Familiarity with data modeling principles (star schema, snowflake schema)
BACHELOR OF COMPUTER SCIENCE
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
2026-01-24
2026-01-23
Trak.in - Indian Business of Tech, Mobile & Startups
2026-01-22
Company data provided by crunchbase