Senior Data Engineer - Snowflake & DBT Pipelines

Machine Learning Technologies, LLC; Houston (TX); On-site; USD 84,000 - 120,000; Full time

Job summary

Machine Learning Technologies, LLC is seeking a Sr Data Engineer with Snowflake in Houston, TX. The role focuses on designing scalable data models and pipelines that align with business objectives, and on optimizing Snowflake performance.

The candidate will develop complex DBT models, create reusable packages, and ensure data quality through testing. Collaboration with stakeholders and teammates is essential for success in this 8-month engagement.

Qualifications

• SQL proficiency with complex queries.
• Experience with CTEs, joins, and analytic/window functions.
• Python experience at least intermediate.
• Hands-on Snowflake experience.
• Data profiling to identify keys, cardinality, data types.
• Strong communication within teams and with QA/product.
• Ability to translate requirements into technical solutions.

Responsibilities

• Design scalable data models and pipelines aligned with business goals.
• Develop complex DBT models with macros and custom materializations.
• Optimize Snowflake warehouses and query performance.
• Create data quality frameworks and testing strategies.
• Build reusable DBT packages and macros for the team.
• Review pull requests from junior engineers.
• Troubleshoot production issues and implement long-term fixes.
• Document architectural decisions and data lineage.

Skills

SQL

CTEs & Joins

Window Functions

Python

Snowflake

Data Profiling

Communication

Product Understanding

QA Understanding

Job description

Machine Learning Technologies, LLC is seeking a Sr Data Engineer with Snowflake in Houston, TX. The role focuses on designing scalable data models and pipelines that align with business objectives, and on optimizing Snowflake performance.

The candidate will develop complex DBT models, create reusable packages, and ensure data quality through testing. Collaboration with stakeholders and teammates is essential for success in this 8-month engagement.