Data Engineer

Tata Consultancy Services; Richardson (TX); On-site; USD 130,000 - 145,000; Full time

Job summary

Tata Consultancy Services seeks a Data Engineer to design, develop, and optimize scalable ELT/ETL pipelines using Snowflake, dbt, SQL, Python, and AWS. You will build enterprise-grade data models, implement data quality controls, and contribute to data modernization initiatives.

You'll collaborate with architects, analytics teams, and stakeholders to deliver trusted data products while leveraging Snowflake CoCo capabilities and CI/CD practices for data pipelines in a cloud-first environment.

Qualifications

• Strong experience designing, developing, and optimizing ELT/ETL pipelines.
• Proficient in Snowflake, dbt, SQL, Python, and AWS.
• Experience with Snowflake CoCo and cloud data engineering best practices.
• Ability to implement data quality controls and CI/CD for data pipelines.

Responsibilities

• Design, develop, and maintain scalable ELT/ETL pipelines using Snowflake and dbt.
• Build enterprise-grade data models supporting analytics, reporting, and AI initiatives.
• Perform source-to-target mapping and implement data transformation frameworks.
• Develop and optimize Snowflake databases, schemas, and data pipelines.
• Leverage Snowflake CoCo capabilities to accelerate data engineering activities.
• Implement data quality controls, reconciliation processes, and monitoring frameworks.
• Collaborate with architects, business stakeholders, and analytics teams to deliver trusted data products.
• Support DataOps and CI/CD practices for data engineering solutions.
• Ensure compliance with security, governance, and data management standards.

Skills

ELT/ETL

Data Modeling

Data Quality

CI/CD

DataOps

Education

Bachelor of Computer Science

Tools

Snowflake

dbt

SQL

Python

AWS

Snowflake CoCo

S3

Lambda

Job description

Job Description

Roles & Responsibilities

We are seeking a highly skilled Data Engineer with strong expertise in Snowflake, dbt, SQL, Python, and AWS to support enterprise data modernization initiatives. The ideal candidate will be responsible for designing, developing, and optimizing scalable data pipelines, data models, and reusable data products. Experience with Snowflake CoCo and modern cloud data engineering practices is highly desirable.

• Design, develop, and maintain scalable ELT/ETL pipelines using Snowflake and dbt.
• Build enterprise-grade data models supporting analytics, reporting, and AI initiatives.
• Perform source-to-target mapping and implement data transformation frameworks.
• Develop and optimize Snowflake databases, schemas, and data pipelines.
• Leverage Snowflake CoCo capabilities to accelerate data engineering activities.
• Implement data quality controls, reconciliation processes, and monitoring frameworks.
• Optimize query performance, warehouse utilization, and overall platform efficiency.
• Collaborate with architects, business stakeholders, and analytics teams to deliver trusted data products.
• Support DataOps and CI/CD practices for data engineering solutions.
• Ensure compliance with security, governance, and data management standards.

Cloud Technologies

• AWS (Preferred)
• S3
• Lambda
• Cloud-native Data Services

Data Engineering

• Data Warehousing
• ETL / ELT Development
• Data Modeling
• Source-to-Target Mapping
• Data Quality & Reconciliation
• Performance Tuning

Snowflake Expertise

• Snowpipe
• Streams & Tasks
• Data Sharing
• Role-Based Security
• Query Optimization
• Warehouse Management

Salary Range: $130,000 to $145,000 per year

Qualifications

BACHELOR OF COMPUTER SCIENCE