Senior Data Engineer – Snowflake / dbt / AWS


Zapcom Group
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Snowflake
- DBT
- Medallion
Summary
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.
- Dice Id: 91095132
- Position Id: 9144004
- Posted 2 hours ago
Company Info
Zapcom bridges the gap between imagination and realization. With precision product engineering, we shape ideas into tangible solutions, driving your aspirations forward with every innovation.
We are passionate about building digital products and platforms that can bend revenue and cost curves. We design, build, operate and optimize technology for our clients by leading their digital transformation journey.


