Senior Snowflake Data Engineer: Scalable Pipelines & Cost

Sembridge Outsourcing Services; United States; Remote; USD 130,000 - 190,000; Full time

Job summary

BlueCloud is seeking a Senior Snowflake Data Engineer to design, build, and optimize scalable data solutions within enterprise environments. This hands-on role focuses on developing reliable data pipelines, improving Snowflake performance and cost efficiency, and modernizing existing data-processing workloads.

You will collaborate with data architects, analysts, DevOps engineers, and client stakeholders to deliver secure, maintainable, and high-performing data platforms.

Qualifications

• 7+ years of data engineering with significant Snowflake experience.
• Advanced SQL skills, including complex transformations and stored procedures.
• Strong Python for data processing and pipeline development.
• Hands-on with Snowpark and Snowflake-native capabilities (Dynamic Tables, Streams, Tasks).
• Proven experience designing scalable ELT/ETL pipelines in production.
• Understanding of Snowflake performance and cost optimization (warehouse sizing, clustering, workload mgmt).
• Experience with dbt and data modeling, incremental processing, and orchestration.
• Familiarity with AWS/Azure/GCP and Git, CI/CD, automated testing.
• Strong troubleshooting, analytical, and problem-solving skills.
• Effective written and verbal communication for collaboration with stakeholders.

Responsibilities

• Design, build, and maintain scalable data pipelines and transformations in Snowflake.
• Build and optimize ELT/ETL processes using SQL, Python, Snowpark, dbt, and Snowflake-native features.
• Modernize pipelines using set-based processing, incremental loading, and reusable patterns.
• Implement Snowflake-native data-processing with Dynamic Tables, Streams, and Tasks.
• Improve performance and cost with query tuning, warehouse sizing, clustering, and workload management.
• Develop orchestration, monitoring, error handling, retry, and recovery mechanisms.
• Design dimensional, relational, and domain-oriented data models.
• Implement data quality checks, observability, testing, lineage, and documentation.
• Integrate data from batch and real-time sources using Fivetran, Kafka, Airflow, or similar.
• Contribute to CI/CD, IaC, and automated deployment; collaborate with stakeholders to translate requirements.
• Participate in code reviews, technical design discussions, estimation, and Agile delivery.

Skills

Snowflake

SQL

Python

Data Engineering

ETL/ELT

Snowpark

dbt

AWS/Azure/GCP

Git

CI/CD

Tools

Snowflake

Snowpark

dbt

Airflow

Fivetran

Kafka

Git

Terraform

Job description

BlueCloud is seeking a Senior Snowflake Data Engineer to design, build, and optimize scalable data solutions within enterprise environments. This hands-on role focuses on developing reliable data pipelines, improving Snowflake performance and cost efficiency, and modernizing existing data-processing workloads.

You will collaborate with data architects, analysts, DevOps engineers, and client stakeholders to deliver secure, maintainable, and high-performing data platforms.