Senior Snowflake Data Engineer

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.