Senior Data Engineer - Snowflake / dbt / AWS

Zapcom Group Inc
Raleigh, NC, United States
1 day ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours
Job source

Tech stack

Query Performance Amazon Web Services Amazon S3 Apache HTTP Server Cloud Computing Cloud Database Data Validation Information Engineering Data Governance Extract Transform Load (ETL) Data Systems Data Vault Modeling
+19 more
Data Warehousing IBM InfoSphere DataStage Identity and Access Management Jinja (Template Engine) Microsoft SQL Server Oracle (Applications) Performance Tuning Query Optimization SQL Databases Teradata SQL Enterprise Data Management Data Ingestion Sql Optimization Snowflake Servicebus Data Management Functional Programming Cloudwatch Data Pipelines

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., * 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.

Requirements

  • 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, * 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., 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…