Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Zapcom Group

NewBe an early applicant

Senior Data Engineer – Snowflake / dbt / AWS

Posted Updated

Description

Job Title: Senior Data Engineer – Snowflake / dbt / AWS
Experience: 7+ Years
Location: Remote ( Preferred Locations are Dallas, Raleigh, Phoenix)
Employment Type: Contract
Openings: Multiple

Job Description

We are looking for an experienced Senior Data Engineer with strong hands-on expertise in Snowflake, dbt, AWS, advanced SQL, and enterprise data engineering. The ideal candidate will have experience designing scalable data platforms, developing production-grade ELT pipelines, optimizing Snowflake workloads, and integrating modern cloud technologies with legacy data warehouse systems.

Key Responsibilities

  • Design, develop, and maintain scalable data engineering solutions using Snowflake.

  • Build and optimize production-grade ELT pipelines using dbt Cloud/Core, SQL, and Jinja.

  • Develop reusable dbt models, macros, and modular transformation workflows.

  • Implement data quality checks, schema validations, freshness checks, snapshots, and SCD implementations.

  • Design and optimize Snowflake objects, including virtual warehouses, Streams, Tasks, Materialized Views, External Tables, and Iceberg.

  • Perform Snowflake performance tuning using micro-partitioning, clustering keys, query optimization, and warehouse sizing.

  • Implement data ingestion and processing solutions using Snowpipe.

  • Develop scalable data models using Data Vault 2.0 and/or Medallion Architecture.

  • Build and maintain integrations with AWS services.

  • Work with legacy data warehouse and ETL platforms to support enterprise data migration and integration initiatives.

  • Collaborate with architects, analysts, and engineering teams to deliver reliable and high-quality data solutions.

Required Skills

  • 7+ years of experience in Data Engineering.

  • Strong hands-on experience with Snowflake architecture and platform engineering.

  • Advanced SQL development and query optimization skills.

  • Production experience with dbt Cloud/Core and Jinja.

  • Experience with dbt testing, snapshots, incremental models, and documentation.

  • Strong understanding of Data Vault 2.0 and/or Medallion Architecture.

  • Hands-on experience with AWS S3, IAM, Lambda, EventBridge, and CloudWatch.

  • Experience with Snowflake Streams, Tasks, Snowpipe, Materialized Views, and External Tables.

  • Knowledge of micro-partitioning, clustering keys, zero-copy cloning, and query performance optimization.

  • Experience with at least one legacy data warehouse or ETL technology:

    • Informatica

    • IBM DataStage

    • Teradata

    • SQL Server

    • Oracle

Preferred Qualifications

  • Banking or financial services domain experience.

  • Experience with large-scale enterprise data warehouse modernization.

  • Experience with Apache Iceberg and Snowflake integration.

  • Strong understanding of data governance, data quality, and data modeling.

Candidate Profile

We are looking for candidates who have strong hands-on development experience, can independently design and troubleshoot data pipelines, and have worked on enterprise-scale Snowflake and cloud data engineering projects.

Interested candidates can share their updated resumes along with their current location, work authorization status, and availability.

Skills

What Senior Data Engineering jobs ask for — and how much of it you have →
Apply

See also

Data Engineering jobs by country — openings, pay and top skills →