Snowflake & dbt Data Engineer - ELT Pipelines

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

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.