Data Engineer (Snowflake/dbt) — End-to-End ELT Lead

Cloudstaff; United States; Hybrid; USD 110,000 - 150,000; Full time

Job summary

Cloudstaff is seeking a Data Engineer to design, build, and maintain data solutions on modern cloud data platforms. The role focuses on Snowflake and dbt-driven pipelines, with hands-on work across modeling, validation, and rolling out new datasets for analytics and AI use cases.

In a client-facing environment, you will own workstreams end-to-end and collaborate with business stakeholders to understand the why behind the data, not just the what.

Qualifications

• Design and build ELT pipelines in Snowflake using dbt
• Refactor legacy SQL and dbt models for performance and readability
• Run data validation and reconciliation across source and target datasets
• Own warehouse sizing, role and access design, and cost control in Snowflake
• Partner with business stakeholders to translate requirements into data models

Responsibilities

• Design and build ELT pipelines in Snowflake using dbt as the transformation layer
• Refactor legacy SQL and dbt models for performance, readability, and testability
• Run data validation and reconciliation across source and target datasets
• Own warehouse sizing, role and access design, and cost control in Snowflake
• Partner with business stakeholders to translate requirements into data models, including pushing back when the request does not make sense
• Lead workstreams without heavy supervision and act as the go-to data engineer on the project

Job description

Cloudstaff is seeking a Data Engineer to design, build, and maintain data solutions on modern cloud data platforms. The role focuses on Snowflake and dbt-driven pipelines, with hands-on work across modeling, validation, and rolling out new datasets for analytics and AI use cases.

In a client-facing environment, you will own workstreams end-to-end and collaborate with business stakeholders to understand the why behind the data, not just the what.