Senior Snowflake Data Engineer - DBT & Data Quality Expert

Cloud Analytics Technologies, LLC; Dallas (TX); In loco; USD 89.000 - 126.000; Tempo pieno

Descrizione del lavoro

Cloud Analytics Technologies, LLC is seeking an experienced Senior Snowflake DBT Developer in Dallas to design scalable data models and optimize data pipelines. The role requires strong SQL, hands-on DBT with advanced materializations, and Snowflake warehouse optimization, with Python experience and data quality testing.

The candidate will translate business requirements into robust data solutions, review code, and collaborate across business, product, QA, and engineering teams to ensure

Competenze

• Strong SQL expertise including CTEs, joins, analytic and window functions.
• Hands-on DBT experience with macros, packages and custom materializations.
• Snowflake expertise and warehouse optimization experience.
• Python experience at an intermediate level or higher.
• Experience with data quality testing and validation.

Mansioni

• Design scalable data models and pipelines aligned with business needs.
• Develop complex DBT models using macros, packages and custom materializations.
• Translate business requirements into effective technical data solutions.
• Identify and resolve Snowflake query and DBT model performance bottlenecks.
• 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 tech teams to ensure delivery.

Conoscenze

SQL

DBT

Snowflake

Python

Data profiling

Data quality testing

CI/CD

Communication

Descrizione del lavoro

Cloud Analytics Technologies, LLC is seeking an experienced Senior Snowflake DBT Developer in Dallas to design scalable data models and optimize data pipelines. The role requires strong SQL, hands-on DBT with advanced materializations, and Snowflake warehouse optimization, with Python experience and data quality testing.

The candidate will translate business requirements into robust data solutions, review code, and collaborate across business, product, QA, and engineering teams to ensure