Senior Data Engineer - Snowflake & AWS Pipelines

Tata Consultancy Services Limited; Detroit (MI); On-site; USD 70,000 - 110,000; Full time

Job summary

Tata Consultancy Services Limited in Detroit, MI is seeking an experienced Data Engineer to design, develop, and maintain robust data pipelines for ingestion, transformation, and loading. You will build data models and workflows with DBT and manage ETL/ELT processes using enterprise tools.

Responsibilities include implementing data warehousing with Snowflake, leveraging AWS S3 and Lambda, and creating data integration workflows with AWS Glue.

Qualifications

• Bachelor's degree or higher in a related field.
• 5+ years of experience in Data Engineering or related roles.
• Hands-on experience with Snowflake, DBT, ETL/ELT tools, scheduling/orchestration tools, AWS S3, AWS Glue, AWS Lambda.

Responsibilities

• Design, develop, and maintain robust and scalable data pipelines for data ingestion, transformation, and loading.
• Build and optimize data models and transformation workflows using DBT.
• Develop and support ETL/ELT processes using enterprise ETL tools.
• Implement and manage data warehousing solutions using Snowflake.
• Utilize AWS S3 for data storage and data lake architectures.

Skills

Snowflake

DBT

ETL/ELT tools

Scheduling/Orchestration

AWS S3

AWS Glue

AWS Lambda

SQL

Data warehousing

Data modeling

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, or related field

Tools

Airflow

Control-M

Autosys

Job description

Tata Consultancy Services Limited in Detroit, MI is seeking an experienced Data Engineer to design, develop, and maintain robust data pipelines for ingestion, transformation, and loading. You will build data models and workflows with DBT and manage ETL/ELT processes using enterprise tools.

Responsibilities include implementing data warehousing with Snowflake, leveraging AWS S3 and Lambda, and creating data integration workflows with AWS Glue.