Snowflake Data Engineer — ETL, SQL & DBT Specialist

Tata Consultancy Services; Center Square (PA); On-site; USD 110,000 - 130,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Medical Coverage (Health, Dental & Vis

401K Plan

Job summary

Tata Consultancy Services is seeking a data engineer to join our Center Square, PA team. The role emphasizes Snowflake development, SQL expertise, and hands-on experience with ETL/ELT tools to build scalable data pipelines.

The successful candidate will collaborate with architects, analysts, and engineers to deliver high-quality data solutions, while following best practices in data modeling, data warehousing, and cloud platforms.

Qualifications

• 4 years of Snowflake development experience.
• 5 years of SQL experience with complex queries.
• 4 years with Talend or similar ETL/ELT tools.
• Knowledge of Python and dbt.
• Hands-on, self-driven engineer with limited supervision and good prioritization.
• Strong understanding of dimensional data modeling and data warehousing concepts.

Responsibilities

• Develop, maintain, document, monitor, and improve existing data warehouse and ETL/ELT solutions.
• Develop new data pipelines and onboard additional data sources.
• Monitor jobs, troubleshoot data issues, and optimize processes for reliability.
• Work with Shell scripting, Airflow, Git, CI/CD, and cloud platforms; consume data from APIs.
• Handle structured, semi-structured, and unstructured data sources.
• Perform data modeling and database design activities as needed.
• Ensure data accuracy, integrity, privacy, and compliance.
• Identify reusable components and automation opportunities for multiple workstreams.
• Coordinate with stakeholders to translate requirements into scalable data solutions.

Skills

Snowflake Development

SQL

ETL/ELT Tools

Python

dbt

Dimensional Modeling

Data Warehousing

SQL/NoSQL

Education

Bachelor of Computer Science

Tools

Talend

Informatica

Job description

Tata Consultancy Services is seeking a data engineer to join our Center Square, PA team. The role emphasizes Snowflake development, SQL expertise, and hands-on experience with ETL/ELT tools to build scalable data pipelines.

The successful candidate will collaborate with architects, analysts, and engineers to deliver high-quality data solutions, while following best practices in data modeling, data warehousing, and cloud platforms.