Snowflake Data Engineer Job at CloudHive, New York, NY

  • CloudHive
  • New York, NY

Job Description

About the Role:

We're seeking a skilled Snowflake Data Engineer to support our team with critical data engineering and data strategy initiatives. In this role, you'll develop and enhance reliable data pipelines, data modeling frameworks, and AI-ready data foundations that power analytics, reporting, and AI applications across the organization. Your work will directly improve the accessibility, reliability, and usability of data for stakeholders and downstream systems.

Key Responsibilities:

Data Pipeline Development

  • Design, build, and maintain production-ready data pipelines that efficiently ingest, transform, and deliver data from multiple source systems. Focus on scalability, reliability, and performance to support growing data volumes and use cases.

Snowflake Data Engineering

  • Leverage Snowflake's capabilities to implement robust data architectures, optimize query performance, and manage data storage strategies. Build efficient data models that balance analytical flexibility with performance.

Data Modeling & Transformation

  • Develop reusable data models using dbt that serve multiple analytics and AI use cases. Implement dimensional modeling, data normalization/denormalization, and transformation logic that maintains data integrity throughout the pipeline.

Data Quality & Validation

  • Establish and enforce data quality standards through automated validation, testing, and monitoring. Proactively identify and resolve data quality issues to ensure downstream consumers have confidence in the data.

Source System Integration

  • Integrate data from diverse source systems, managing complexities around data formats, schemas, incremental loading patterns, and change data capture requirements.

Documentation & Metadata

  • Create comprehensive documentation and metadata for datasets, pipelines, and data models. Ensure data lineage is clear and data assets are discoverable and understandable by technical and non-technical stakeholders.

AI-Ready Data Foundations

  • Support AI initiatives by ensuring data is properly structured, cleaned, and accessible for machine learning and AI applications. Collaborate with data scientists and AI engineers to understand requirements and optimize data for their use cases.

Collaboration & Support

  • Work closely with Growth analytics teams, data scientists, and business stakeholders to understand requirements and provide engineering support for analytics and AI use cases.

Required Skills & Experience:

  • Strong experience with Snowflake data engineering, including data warehousing, SQL optimization, and cloud data architecture
  • Advanced SQL proficiency for complex data transformations and analysis
  • Python development experience for data engineering workflows and automation
  • Hands-on experience with dbt for data transformation and modeling
  • Proficiency with Git/GitHub for version control and collaborative development
  • Strong understanding of data modeling principles, including dimensional modeling and normalization techniques
  • Experience with source system integration and ETL/ELT patterns
  • Self-starter who can work independently while collaborating effectively with cross-functional teams

Job Tags

Full time

Similar Jobs

Association Office

YMCA Internships - Unpaid Job at Association Office

 ...Explore Future Opportunities: Unpaid Internship Interest Submission YMCA of Greater Boston Location: Greater Boston Area Internship Type: Unpaid Department: Varies Are you passionate about making a difference in your community? Interested in gaining hands-on experience... 

XPO Logistics

Truck Driver - Home Daily - CDL A Job at XPO Logistics

 ...CDL ARequisition Id: 390005 Business Unit: LTL Location: Upper Sandusky, OH, US, 43351What you'll need to succeed as a Truck Driver at XPO Minimum qualifications: Be at least 21 years of age Valid Class A commercial driver's license Safe driving record and history... 

Frasco Inc

Hybrid Investigator Job at Frasco Inc

Description: Department: Surveillance Prep Investigator/Surveillance Location: Hybrid (Remote & Field-Based), Lincoln, NE and surrounding...  ...during the report editing process. Update and annotate corporate case management system with investigative notes and upload/... 

Arhaus

Director of Corporate Security & Loss Prevention Job at Arhaus

 ...creating beautiful, heirloom-quality pieces that can be usedand lovedfor generations. The Director of Corporate Security & Loss Prevention will be responsible for developing, implementing, and overseeing enterprise-wide strategies to mitigate inventory loss,... 

Royal Caribbean Cruises, Inc.

SECURITY BOAT CAPTAIN Job at Royal Caribbean Cruises, Inc.

SECURITY BOAT CAPTAINThe Security Boat Captain is responsible for driving the Security Boat for any security and safety operation needs: clearing the channel of any local fishing boats which may obstruct the ship prior to scheduled arrival alongsideand departure.This...