Yochana · 7 hours ago
Data Engineer Snowflake Developer
Franklin, TN
Contract
Onsite
Senior Level, Lead/Staff
10+ years expYochana is seeking a Snowflake Developer to design and implement Snowflake schemas and build data ingestion pipelines. The role involves automating data processing, integrating with cloud storage and BI tools, and optimizing data management strategies.
Business Information SystemsInformation and Communications Technology (ICT)Information ServicesInformation TechnologySoftwareStaffing Agency
Responsibilities
Design and implement Snowflake schemas (star, snowflake, data vault) optimized with micro-partitioning, clustering keys, materialized views, and search optimization services
Build real-time and batch ingestion pipelines into Snowflake using Snowpipe, Kafka Connect, Fivetran, Matillion, Informatica, or dbt
Automate incremental data processing with Streams & Tasks to support CDC (Change Data Capture)
Use Zero-Copy Cloning for environment management, testing, and sandboxing
Apply Time Travel and Fail-safe features for data recovery and auditing
Develop data transformation logic in Snowpark for Python/SQL/Scala to push compute directly into Snowflake
Design integrations with cloud storage (S3, Azure ADLS, GCS) for staging and external tables
Implement data sharing and data marketplace solutions via Snowflake Secure Data Sharing and Snowflake Marketplace
Enable semi-structured data handling (JSON, Avro, Parquet, ORC, XML) using VARIANT columns and lateral flattening
Integrate Snowflake with BI tools (Power BI, Tableau) via live connections and semantic layers
Implement RBAC (Role-Based Access Control), Row Access Policies, and Dynamic Data Masking for data security
Optimize compute usage with multi-cluster warehouses, resource monitors, and query performance tuning
Manage cost optimization strategies (warehouse auto-suspend, query profiling, storage/compute separation)
Integrate with data catalog & governance platforms (Collibra, Alation, Informatica CDGC) using Snowflake metadata and APIs
Work with domain teams to deliver data products leveraging Snowflake’s data mesh-friendly features
Collaborate with architects to design a Snowflake-centric data fabric integrated with ETL/ELT and API layers
Support CI/CD automation for Snowflake code deployment using GitHub Actions, Azure DevOps, or dbt Cloud
Qualification
Required
Bachelor's or Master's in Computer Science, Data Engineering, or related field
10+ years of data engineering experience, with 5+ years in Snowflake Data Cloud
Expertise in SQL optimization and Snowflake performance tuning
Hands-on with Snowpipe, Streams & Tasks, Snowpark, Zero-Copy Cloning, and Secure Data Sharing
Proficiency in Python, Scala, or Java for Snowpark development
Experience integrating with cloud platforms like AWS
Exposure to ETL/ELT tools (Informatica, Matillion, Fivetran)
Familiarity with CI/CD, Git, DevOps practices for data operations
Preferred
SnowPro Core Certification
Company
Yochana
Yochana: Your Trusted Workforce Partner Across North America & Beyond For over 16 years, Yochana has been a leading talent acquisition firm, connecting businesses with top professionals across industries.
201-500 employees
H1B Sponsorship
Yochana has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (21)
2024 (11)
2023 (3)
Funding
Current Stage
Growth StageLeadership Team
Anusha Sharath
Global Talent Acquisition Lead / HR-BP
Recent News
Company data provided by crunchbase