Data Engineer (Snowflake and dbt) | WFH

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

As a Data Engineer you will design, build, and maintain data solutions on modern cloud data platforms for our clients. The current engagement is Snowflake and dbt led, with hands-on work across pipeline development, dbt model refactoring, data validation, and rolling out new datasets for downstream analytics and AI use cases.

You will operate in a client-facing environment, take ownership of workstreams end-to-end, and work directly with business stakeholders to understand the why behind the data, not just the what.

What you will do

• 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 operate as the go-to data engineer on your project

Nice to haveFivetran or other ingestion tooling experience, Power BI or other BI tooling exposure, Data Vault modelling alongside dimensional modelling, Exposure to a second modern data platform such as Databricks or Azure Synapse, Experience in consulting or professional services environments