Snowflake Data Engineer, DBT & Pipelines

Valiant Technologies LLC; Austin (TX); In loco; USD 120.000 - 170.000; Tempo pieno

Descrizione del lavoro

Valiant Technologies LLC in Austin, TX, is seeking a data engineer to design scalable data models and pipelines, and to develop complex DBT models with advanced features. The role emphasizes optimizing Snowflake configurations and ensuring data quality through testing strategies.

Ideal candidates will have strong SQL, CTEs/complex joins, and some Python experience, plus familiarity with Snowflake and data profiling. Collaboration across teams and initiative in QA are valued.

Competenze

• Strong SQL skills with advanced query design.
• Familiar with CTEs, complex joins, and analytic/window functions.
• Some Python experience; intermediate or higher preferred.
• Snowflake experience preferred.
• Data profiling to identify keys, cardinality, data types, precision and skew.
• Effective communication within and across teams.
• Product and QA understanding; takes initiative to meet goals.

Mansioni

• Design scalable data models and pipelines aligned with business objectives.
• Develop complex DBT models using macros, packages, and custom materializations.
• Collaborate with leaders to translate requirements into technical solutions.
• Identify and resolve Snowflake performance bottlenecks and DBT model issues.
• Optimize Snowflake warehouse configurations and query performance.
• Create reusable DBT packages and macros for team use.
• Review PRs from junior team members.
• Troubleshoot production issues and implement long-term fixes.
• Document architectural decisions and data lineage.

Conoscenze

SQL

CTEs & Joins

Python

Snowflake

Data profiling

Communication

Product & QA understanding

Strumenti

DBT

Descrizione del lavoro

Valiant Technologies LLC in Austin, TX, is seeking a data engineer to design scalable data models and pipelines, and to develop complex DBT models with advanced features. The role emphasizes optimizing Snowflake configurations and ensuring data quality through testing strategies.

Ideal candidates will have strong SQL, CTEs/complex joins, and some Python experience, plus familiarity with Snowflake and data profiling. Collaboration across teams and initiative in QA are valued.