Hi everyone,
Hope you're all doing well. It's nice to connect with you all
We are looking for Sr Snowflake Data Engineer (Remote). Please share your resume to if you are interested.
Job Title: Sr Snowflake Data Engineer
Location: Remote ( preferred in Dallas, Raleigh, Phoneix)
This position is responsible for implementing and managing Snowflake data platform with multiple accounts. Modernize its enterprise data platforms using Snowflake, dbt, and scalable data modeling architectures such as Medallion / Data Vault 2.0. The role requires a deep knowledge of snowflake platform design, security, data warehouses, objects & access management, and features required for development of sophisticated data pipelines in an agile environment and collaboration with technical partners, stakeholders to drive data-driven decision-making.
Core Technical Requirements
- Snowflake Architecture & Engineering: Deep experience creating performant Snowflake objects (virtual warehouses, streams, tasks, materialized views, external tables/Iceberg). Proficiency in micro-partitioning, query optimization, clustering keys, zero-copy cloning, and ingestion via Snowpipe.
- Transformation & Modeling with dbt: Extensive production experience building modular ELT pipelines using dbt (Cloud or Core) with SQL and Jinja. Implementing automated testing (generic/singular tests, schema validations, data freshness), snapshots for slowly changing dimensions (SCDs), and documentation.
- Data Modeling (Data Vault / Medallion): Designing structured enterprise analytical models:
- Data Vault 2.0: Constructing Raw Vault and Business Vault layers (Hubs, Links, Satellites, Point-in-Time/Bridge tables) for full auditability, historical tracking, and multi-source integration.
- Medallion Architecture: Organizing processing into Bronze (raw ingestion/CDC), Silver (cleansed/conformed Data Vault), and Gold (star-schema marts, reporting aggregations).
- Languages & Scripting: Advanced SQL (window functions, CTEs, complex analytical queries)
- Cloud Infrastructure (AWS): Hands-on experience integrating Snowflake with cloud services (AWS S3, IAM roles/policies, Lambda, EventBridge, CloudWatch).
- Must Have Legacy Experience: Should have prior experience in data warehouse tools and RTL tools. (Informatica or Datastage or Terradata or strong SQL server or Oracle platforms)