Senior Data Engineer - Snowflake / dbt / AWS
Zapcom Group Inc
Raleigh, NC, United States
1 day ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
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
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦