Sr Data Engineer with Snowflake

Quantum Technologies. LLC; Dallas (TX); Presencial; USD 89.000 - 126.000; Jornada completa

Descripción de la vacante

Quantum Technologies LLC in Dallas, Texas is seeking an experienced Senior Snowflake DBT Developer to lead design and optimization of data models and pipelines. You will implement data quality frameworks, optimize Snowflake warehouses, and build reusable DBT components.

Strong SQL, Snowflake, and DBT experience are required to translate business needs into scalable data solutions. You will collaborate with product, QA, and analytics teams, review PRs from junior developers, and ensure reliable

Formación

• Strong SQL expertise including CTEs, joins, analytic and window functions.
• Hands-on experience with DBT, macros, packages, and custom materializations.
• Real-world Snowflake experience and warehouse optimization.
• Python experience at an intermediate level or higher.
• Data profiling: keys, cardinality, data types, precision, scale, data skew.
• Data quality testing and validation.
• Understanding of CI/CD pipelines and DBT deployment processes.
• Strong communication, problem-solving, and analytical skills.
• Ability to take ownership and work independently to achieve goals.
• Equal opportunity employer statement included in ad.

Responsabilidades

• Design and implement scalable data models and pipelines aligned with business requirements.
• Develop complex DBT models using macros, packages, and custom materializations.
• Translate business requirements into effective technical data 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.
• Develop reusable DBT packages and macros for team-wide use.
• Review and approve pull requests from junior developers.
• Troubleshoot production issues and implement long-term solutions.
• Document architectural decisions and data lineage.
• Collaborate with business, product, QA, and technical teams to ensure successful delivery.

Conocimientos

SQL

Python

Data modeling

Data profiling

Communication

Problem-solving

Independent work

Herramientas

DBT

Snowflake

Git

Descripción del empleo

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: Sr Data Engineer with Snowflake
Location: Dallas,TX
Duration: 12 Months + Extension
Bill Rate: 78/hour
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US-Citizen, H-1B, OPT-EAD, GC-EAD

Job Description

We are seeking an experienced Senior Snowflake DBT Developer with strong SQL skills and hands-on experience in Snowflake and DBT. The ideal candidate will be responsible for developing scalable data models, optimizing data pipelines, implementing data quality frameworks, and managing DBT deployments. The candidate should have strong analytical and communication skills and the ability to work independently with business, product, and QA teams.

Key Responsibilities:

Design and implement scalable data models and pipelines aligned with business requirements.

Develop complex DBT models using macros, packages, and custom materializations.

Translate business requirements into effective technical data 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.

Develop reusable DBT packages and macros for team-wide use.

Review and approve pull requests from junior developers.

Troubleshoot production issues and implement long-term solutions.

Document architectural decisions and data lineage.

Collaborate with business, product, QA, and technical teams to ensure successful delivery.

Required Skills & Qualifications:

Strong SQL expertise, including CTEs, complex joins, analytic functions, and window functions.

Hands-on experience with DBT, including advanced features such as macros, packages, and custom materializations.

Real-world experience with Snowflake and warehouse optimization.

Python experience, preferably at an intermediate level or higher.

Strong data profiling skills, including identifying primary and unique keys, cardinality, data types, precision, scale, and data skew.

Experience with data quality testing and validation.

Understanding of CI/CD pipelines and DBT deployment processes.

Strong communication, problem-solving, and analytical skills.

Ability to take ownership, work independently, and proactively achieve project goals.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.