Senior Snowflake Data Engineer Build Scalable ELT Pipelines

BlueCloud; United States; Remote; USD 120,000 - 170,000; Full time

Job summary

BlueCloud is seeking a senior data engineer to design, build, and maintain scalable Snowflake-based data pipelines and ELT/ETL workflows. You will optimize performance, implement Snowflake-native features, and collaborate across teams to deliver reliable data products.

You will advance data modeling, observability, testing, and CI/CD for data platforms, using SQL, Python, Snowpark, and dbt, with hands-on AWS/Azure/GCP experience.

Qualifications

• 7+ years of data engineering with significant Snowflake experience.
• Advanced SQL skills including complex transformations and query optimization.
• Strong Python development experience for data processing and automation.
• Hands-on experience with Snowpark and Snowflake-native capabilities.
• Proven experience designing and supporting scalable ELT/ETL pipelines.
• Expertise in Snowflake performance and cost optimization.
• Experience with data modeling and pipeline orchestration.
• Experience with dbt or comparable transformation frameworks.

Responsibilities

• Design, develop, and maintain scalable data pipelines and transformation workflows within Snowflake.
• Build and optimize ELT/ETL processes using SQL, Python, Snowpark, dbt, and Snowflake-native capabilities.
• Modernize existing Python and stored-procedure-based pipelines using set-based processing and incremental loading.
• Implement Snowflake-native solutions using Dynamic Tables, Streams, Tasks, and stored procedures.
• Improve platform performance and cost efficiency through query tuning and warehouse right-sizing.
• Develop orchestration, monitoring, error handling, and recovery mechanisms.
• Design and maintain dimensional, relational, and domain-oriented data models.
• Implement data-quality checks, observability, testing, and lineage standards.
• Integrate data from batch and real-time sources using tools like Fivetran, Kafka, or Airflow.
• Contribute to CI/CD pipelines and infrastructure-as-code practices.

Skills

SQL

Python

Snowflake

Snowpark

dbt

Tools

dbt

Airflow

Git

Terraform

Job description

BlueCloud is seeking a senior data engineer to design, build, and maintain scalable Snowflake-based data pipelines and ELT/ETL workflows. You will optimize performance, implement Snowflake-native features, and collaborate across teams to deliver reliable data products.

You will advance data modeling, observability, testing, and CI/CD for data platforms, using SQL, Python, Snowpark, and dbt, with hands-on AWS/Azure/GCP experience.