Snowflake DBT Engineer

Centraprise; Dallas (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

Centraprise in Dallas, TX seeks a Data Engineer to design, build, and maintain scalable ELT pipelines using Snowflake and dbt. You will work with SQL-heavy transformations, data modeling, and production support to deliver reliable data products.

The role requires hands-on Snowflake and dbt experience, strong coding skills, and collaboration with analysts and architects to ensure data quality and performance.

Qualifications

• 5+ years of overall Data Engineering experience.
• 3+ years of hands-on Snowflake development experience in production environments.
• 2+ years of hands-on dbt Core or dbt Cloud development experience.
• Strong hands-on experience with Advanced SQL, ELT/ETL pipelines, data modeling, performance tuning, and production support.
• Recent coding and development experience is mandatory; architecture-focused profiles are not suitable.
• Design, develop, test, deploy and support ELT pipelines using Snowflake and dbt.

Responsibilities

• Build dbt models across staging, intermediate, and mart layers using reusable and maintainable development standards.
• Create and manage dbt incremental models, snapshots, tests, documentation, sources, seeds, macros, and packages.
• Develop Snowflake objects including databases, schemas, tables, views, secure views, streams, tasks, and Snowpipe pipelines.
• Write and optimize complex SQL queries, stored procedures, and transformation logic.
• Implement data quality checks, reconciliation controls, exception handling, and monitoring mechanisms.
• Troubleshoot production data issues, pipeline failures, performance bottlenecks, and data discrepancies.

Skills

Data Engineering

Snowflake

dbt

SQL

Python

Data Modeling

ELT/ETL

Production Support

Tools

dbt Core

dbt Cloud

Snowflake

Job description

Mandatory Technical skills - Snowflake, dbt, SQL, Python, Data Engineering, Data Modeling

• 5+ years of overall Data Engineering experience.
• 3+ years of hands-on Snowflake development experience in production environments.
• 2+ years of hands-on dbt Core or dbt Cloud development experience.
• Strong hands-on experience with Advanced SQL, ELT/ETL pipelines, data modeling, performance tuning, and production support.
• Recent coding and development experience is mandatory. Profiles that are mainly architecture-focused should not be considered.
• Design, develop, test, deploy, and support ELT pipelines using Snowflake and dbt.
• Build dbt models across staging, intermediate, and mart layers using reusable and maintainable development standards.
• Create and manage dbt incremental models, snapshots, tests, documentation, sources, seeds, macros, and packages.
• Develop Snowflake objects including databases, schemas, tables, views, secure views, streams, tasks, and Snow pipe pipelines.
• Write and optimize complex SQL queries, stored procedures, and transformation logic.
• Perform source-to-target mapping and implement transformation rules based on business and technical requirements.
• Build dimensional data models, data marts, facts, dimensions, and analytics-ready datasets.
• Implement data quality checks, reconciliation controls, exception handling, and monitoring mechanisms.
• Troubleshoot production data issues, pipeline failures, performance bottlenecks, and data discrepancies.
• Optimize Snowflake warehouse usage, query performance, clustering, and cost efficiency.
• Work with business analysts, data architects, application teams, and reporting teams to deliver trusted data products.
• Support CI/CD and DataOps practices for Snowflake and dbt deployments