Senior Data Engineer | Snowflake & DBT Expert

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 for an 8-month engagement with possible extension. You will design scalable data models and complex DBT pipelines, optimize Snowflake performance, and implement data quality and CI/CD processes.

Collaboration with business stakeholders to translate requirements is essential, as is strong communication across teams.

Qualifications

• SQL skills including CTEs, complex joins and analytic/windowing functions.
• Python experience (intermediate or higher).
• Snowflake experience in real-world contexts.
• Data profiling to identify keys, cardinality, data types, precision and skew.
• Effective communication within teams and across teams.
• Product and QA understanding driving initiative.

Responsibilities

• Design scalable data models and pipelines aligned with business goals.
• Develop DBT models with macros, packages and custom materializations.
• Translate complex requirements with business leaders into technical solutions.
• Identify and resolve Snowflake query and DBT model performance bottlenecks.
• Optimize Snowflake warehouse configurations and query performance.
• Create data quality frameworks and testing strategies.
• Create reusable DBT packages/macros for team reuse.
• Manage CI/CD pipelines for DBT deployments and PR reviews.
• 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

Job description

MACHINE LEARNING TECHNOLOGIES LLC is seeking a Sr Data Engineer with Snowflake in Houston, TX for an 8-month engagement with possible extension. You will design scalable data models and complex DBT pipelines, optimize Snowflake performance, and implement data quality and CI/CD processes.

Collaboration with business stakeholders to translate requirements is essential, as is strong communication across teams.