Snowflake Data Engineer

CloudHive is your North America and LATAM Snowflake-focused staffing partner. We help accelerate Snowflake adoption and maximize the value of the Snowflake AI Data Cloud by delivering experienced, on-demand Snowflake contractors and specialized talent acquisition services.

You'll lead end-to-end data engineering to design, build, and optimize a multi-layer (Bronze/Silver/Gold) data warehouse for analytics and reporting. This role involves gathering requirements, creating production-ready schemas and pipelines, and delivering validated, secure, analytics-ready data—empowering the client with robust Snowflake solutions.

Key Responsibilities:

• Gather business requirements and design data models for a multi-layer Snowflake data warehouse.
• Build ingestion and ELT pipelines using Snowflake features (e.g., warehouses, Streams & Tasks, stages) and SQL for transformations and data quality checks.
• Implement data quality validations, performance tuning, and security measures to ensure reliable, analytics-ready data.
• Integrate with tools like DevOps Repos for Git-based version control and Power BI for reporting.
• Support production deployments, troubleshoot issues, and provide documentation for seamless handover.
• Collaborate with stakeholders to optimize pipelines and align with analytics goals.

Requirements:

• 4+ years of hands-on experience in Snowflake data engineering, including multi-layer warehouse design and ELT processes.
• Proficiency in Snowflake (warehouses, Streams & Tasks, stages), advanced SQL, Git-based version control (e.g., DevOps Repos), and Power BI integration.
• Strong skills in data modeling, ingestion, transformations, performance optimization, and data quality implementation.
• Experience with production deployments and secure, validated data pipelines.
• Snowflake certification (e.g., SnowPro Core) preferred.
• Excellent problem-solving and communication skills for cross-functional collaboration.

Please get in contact for more information.