Senior 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

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.