About the role
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.