Snowflake Data Engineer Lead - ELT, dbt & CI/CD

Talentify; San Antonio (TX); On-site; USD 120,000 - 170,000; Full time

Job summary

Diverse Lynx LLC is seeking a Technical Lead for Data Engineering with hands-on Snowflake-based data warehousing and modern ELT development using dbt. You will design scalable pipelines, enforce data quality, and lead architecture reviews while mentoring both on-site and offshore team members.

Proficiency in SQL, CI/CD for dbt, and cloud security is required, along with strong leadership and DevOps deployment experience. Onsite collaboration is expected to drive delivery.

Qualifications

• Hands-on expertise in Snowflake-based cloud data warehousing and ELT development using dbt (Core or Cloud).
• Advanced SQL skills with emphasis on incremental and snapshot strategies, performance tuning and cost optimization.
• Experience implementing CI/CD for dbt, integrating orchestration tools, and enforcing data quality through automated tests and observability.
• Strong understanding of cloud security, version control (Git), and DevOps deployment practices.
• Proven ability to lead technical design reviews and mentor data engineering teams, including offshore members.

Responsibilities

• Design scalable, production-grade ELT pipelines using Snowflake and dbt.
• Lead and participate in technical design reviews and code reviews.
• Implement CI/CD pipelines for dbt projects and orchestrate data workflows.
• Mentor and coordinate on-site and offshore data engineering teams to drive delivery.

Skills

Leadership

Mentoring

Data governance

Performance tuning

Tools

Snowflake

dbt

SQL

Git

Airflow

CI/CD

Cloud platforms

Job description

Diverse Lynx LLC is seeking a Technical Lead for Data Engineering with hands-on Snowflake-based data warehousing and modern ELT development using dbt. You will design scalable pipelines, enforce data quality, and lead architecture reviews while mentoring both on-site and offshore team members.

Proficiency in SQL, CI/CD for dbt, and cloud security is required, along with strong leadership and DevOps deployment experience. Onsite collaboration is expected to drive delivery.