Senior Snowflake DBT Developer role focused on scalable data modeling, pipeline performance, data quality, and DBT deployment.

Design and build scalable data models and pipelines based on business requirements.
Develop advanced DBT models using macros, packages, and custom materializations.
Convert business requirements into practical technical data solutions.
Detect and fix performance bottlenecks in Snowflake queries and DBT models.
Optimize Snowflake warehouse configuration and improve query performance.
Create and implement data quality frameworks, including testing strategies and validation approaches.
Build reusable DBT packages and macros to support team-wide development.
Own and manage CI/CD pipelines for DBT deployments.
Review and approve pull requests submitted by junior developers.
Troubleshoot production issues and implement long-term corrective solutions.
Document architectural decisions and maintain data lineage records.
Collaborate with business, product, QA, and technical teams to ensure successful delivery.

Strong SQL skills, including CTEs, complex joins, analytic functions, and window functions.
Hands-on experience with DBT, including advanced features: macros, packages, and custom materializations.
Real-world experience working with Snowflake and driving warehouse optimization.
Python experience, preferably at an intermediate level or higher.
Strong data profiling capability, including identifying primary and unique keys, cardinality, data types, precision, scale, and data skew.
Experience implementing data quality testing and validation.
Knowledge of CI/CD pipelines and DBT deployment processes.
Strong communication, analytical, and problem-solving skills.
Ability to take ownership, work independently, and proactively drive project goals.

Location: Dallas, TX (onsite)
Compensation: USD 78 per hour
Job ID: J53904
Duration: 12 Months + Extension; 9 Months + Extension
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Domain Exposure: Oil & Gas
Work Authorization: US-Citizen; H-1B; OPT-EAD; GC-EAD; US Citizen; Green Card; OPT-EAD; CPT; H-1B; H4-EAD; L2-EAD; GC-EAD
Bill Rate: 78/hour

Sr Data Engineer with Snowflake

Job Description