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. Strictly no third parties.