Senior Snowflake Data Engineer

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

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

Requirements

• 7+ years of experience in 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
• Familiarity with AWS, Azure, or GCP
• Experience with Git, CI/CD, and automated testing

Preferred Qualifications

• Experience with Fivetran, Kafka, or Airflow
• Familiarity with Terraform or other IaC platforms
• Experience with Snowflake Iceberg Tables or lakehouse architectures
• Exposure to Snowflake Cortex functions
• SnowPro Core or SnowPro Advanced certification

About the Company

BlueCloud is a Snowflake Elite Partner helping enterprise organizations move to unified, AI-ready Snowflake platforms through data migration, engineering, governance, and AI/ML solutions.