Senior Data Engineer, Snowflake

🔥 6 minutes ago

🇺🇸 United States – Remote

⏰ Full Time

🟠 Senior

🚰 Data Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

BlueCloud

WebsiteLinkedInAll Job Openings

501 - 1000 employees

Founded 2004

💼 Consulting

📣 Marketing

📦 Logistics

Consulting • Marketing • Logistics

BlueCloud is a global tech company that specializes in transforming businesses through data, analytics, and generative AI. Their services include data engineering, analytics, software design, DevOps, and data governance, leveraging revolutionary AI technology to enhance decision-making and efficiency. As a recognized Data Cloud Services Growth Partner, BlueCloud provides end-to-end cloud solutions that empower organizations to maximize their data potential and support digital transformation through scalable and high-performing global teams.

📋 Description

• 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, incremental loading, and reusable engineering patterns. • Implement Snowflake-native data-processing solutions using Dynamic Tables, Streams, Tasks, and stored procedures. • Improve platform performance and cost efficiency through query tuning, warehouse right-sizing, clustering strategies, workload isolation, and auto-suspend and auto-resume policies. • Develop reliable orchestration, dependency management, monitoring, error handling, retry, and recovery mechanisms. • Design and maintain dimensional, relational, and domain-oriented data models. • Implement data-quality checks, observability, testing, lineage, and documentation standards. • Integrate data from batch and real-time sources using tools such as Fivetran, Kafka, Airflow, or similar technologies. • Contribute to CI/CD pipelines, infrastructure-as-code practices, and automated deployment processes. • Work closely with architects and client stakeholders to translate business and technical requirements into production-ready solutions. • Participate in code reviews, technical design discussions, estimation, and Agile delivery activities.

🎯 Requirements

• 7+ years of experience in data engineering, including significant hands-on experience with Snowflake. • Advanced SQL skills, including complex transformations, query optimization, and stored procedure development. • Strong Python development experience for data processing, automation, and pipeline development. • Hands-on experience with Snowpark and Snowflake-native capabilities such as Dynamic Tables, Streams, and Tasks. • Proven experience designing and supporting scalable ELT/ETL pipelines in production environments. • Strong understanding of Snowflake performance and cost optimization, including warehouse sizing, query profiling, clustering, and workload management. • Experience with data modeling, incremental processing, pipeline orchestration, and dependency management. • Experience with dbt or a comparable data transformation framework. • Familiarity with at least one major cloud platform: AWS, Azure, or GCP. • Experience with Git, CI/CD, automated testing, and modern software delivery practices. • Strong troubleshooting, analytical, and problem-solving skills. • Effective written and verbal communication skills, including the ability to collaborate directly with technical and business stakeholders.