Snowflake Data Engineer / Technical Lead

Tror AI for everyone; Detroit (MI); On-site; USD 150,000 - 230,000; Full time

Job summary

Tror AI for everyone is seeking an experienced Snowflake Data Engineer / Technical Lead in Michigan, USA. The role requires hands-on expertise in Snowflake, DataStage, dbt, and a strong foundation in data warehousing, data modeling, ETL development, and modern data engineering.

The candidate will lead data architecture discussions, drive customer-focused solutions, and collaborate with stakeholders to design scalable data platforms leveraging AWS data services and Oracle-based integrations.

Qualifications

• 10+ years of experience in data engineering or related roles.
• Strong hands-on experience with Snowflake, DataStage, dbt and data warehousing.
• Ability to interact with customers to design solutions and lead technical discussions.

Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL/ELT solutions.
• Develop and optimize data solutions using Snowflake, DataStage, and dbt.
• Design data warehouses, models, schemas, and transformation processes.
• Build and maintain complex SQL queries, stored procedures, and data transformations.
• Work with AWS data services including Aurora, RDS, DMS, and DynamoDB.
• Develop and support data integration involving Oracle, PL/SQL, and SQL.
• Perform data migration, integration, transformation, and validation.
• Collaborate with stakeholders to understand data requirements.
• Lead requirement gathering, solution design, technical discussions, and estimations.
• Provide technical guidance to data engineering teams and review solutions.
• Troubleshoot data pipelines, ETL, databases, and production issues.
• Ensure data quality, reliability, security, and performance across platforms.
• Participate in architecture discussions and recommend data engineering solutions.

Skills

Snowflake

DataStage

dbt

Data warehousing

Data modeling

ETL development

SQL

Oracle

PL/SQL

AWS data services

Technical leadership

Architecture discussions

Data pipelines

Tools

Snowflake

DataStage

dbt

Job description

Role: Snowflake Data Engineer / Technical Lead
Location: Michigan, USA
Experience: 10+ Years

Job Summary

We are looking for an experienced Snowflake Data Engineer / Technical Lead with strong hands‑on experience in Snowflake, DataStage, and dbt. The candidate should have a strong background in data warehousing, data modeling, ETL development, and modern data engineering.

The ideal candidate will also have experience with
AWS data services, Oracle, PL/SQL, and SQL, along with the ability to work directly with customers to understand requirements, design solutions, and provide technical leadership.

Key Responsibilities

• Design, develop, and maintain scalable
  data pipelines and ETL/ELT solutions.
• Develop and optimize data solutions using
  Snowflake, DataStage, and dbt.
• Design
  data warehouses, data models, schemas, and transformation processes.
• Build and maintain complex SQL queries, stored procedures, and data transformation logic.
• Work with
  AWS data services, including Aurora, RDS, DMS, and DynamoDB.
• Develop and support data integration solutions involving
  Oracle, PL/SQL, and SQL.
• Perform data migration, integration, transformation, and validation activities.
• Optimize Snowflake queries, workloads, and data processing for performance and scalability.
• Collaborate with business and technical stakeholders to understand data requirements.
• Lead
  requirement gathering, solution design, technical discussions, and estimations.
• Provide technical guidance to data engineering teams and review technical solutions.
• Troubleshoot data pipeline, ETL, database, and production issues.
• Ensure data quality, reliability, security, and performance across data platforms.
• Participate in architecture discussions and recommend appropriate data engineering solutions.