Senior Data Engineer - Snowflake & DBT Pipelines

Artifintech; Houston (TX); On-site; USD 84,000 - 120,000; Full time

Job summary

Artifintech in Houston is seeking a Sr Data Engineer with Snowflake to design scalable data models and robust pipelines. You will develop advanced DBT models, optimize Snowflake performance, and collaborate with business leaders to translate complex requirements into technical solutions.

The role emphasizes data quality, production issue resolution, and mentoring junior engineers. Strong SQL, Python, and communication skills are required. This is a contract role in a data-driven environment.

Qualifications

• Proficient in SQL with complex queries and window functions.
• Experience with DBT modeling and data pipelines.
• Strong communication across teams.

Responsibilities

• Design and implement scalable data models and pipelines that align with business objectives.
• Develop complex DBT models using advanced features (macros, packages, custom materializations).
• Collaborate with business leaders to translate requirements into technical solutions.
• Identify and resolve performance bottlenecks in Snowflake queries and DBT models.
• Optimize Snowflake warehouse configurations and query performance.
• Design and implement data quality frameworks and testing strategies.
• Create reusable DBT packages and macros for team-wide use.
• Review and approve pull requests from junior team members.
• Troubleshoot production issues and implement long-term solutions.
• Document architectural decisions and data lineage.

Skills

SQL

CTEs and Joins

Python

Snowflake

Data Profiling

Communication

Product & QA Understanding

Tools

DBT

Snowflake

Job description

Artifintech in Houston is seeking a Sr Data Engineer with Snowflake to design scalable data models and robust pipelines. You will develop advanced DBT models, optimize Snowflake performance, and collaborate with business leaders to translate complex requirements into technical solutions.

The role emphasizes data quality, production issue resolution, and mentoring junior engineers. Strong SQL, Python, and communication skills are required. This is a contract role in a data-driven environment.