Snowflake Data engineer with Redshift

Position: Snowflake  Data Engineer with Redshift 

Work Setup: Remote (Richmond, VA)

Job Type: Contract

Experience Level: 8+ Years (Mid–Senior)

Role Overview

We are seeking an experienced Senior Data Engineer to design, construct, and scale high-performance cloud data architectures across Snowflake and AWS Redshift. This role focuses on large-scale dimensional modeling, robust ETL/ELT pipeline automation, and query performance tuning.

Key Responsibilities

Warehouse Architecture: Architect and maintain scalable cloud data warehouses leveraging Snowflake and Amazon Redshift.

Pipeline Engineering: Build fault-tolerant real-time and batch pipelines ingesting data from transactional databases, event streams, and APIs.

Query & Performance Tuning: Optimize Redshift distribution/sort keys, concurrency scaling, and WLM configuration; manage Snowflake clustering keys, virtual warehouse sizing, and caching layers.

Data Modeling: Design dimensional models (Star/Snowflake schemas), operational data marts, and Data Vault architectures.

Data Integration & Migration: Execute seamless synchronization and data migration strategies between Redshift and Snowflake environments.

Workflow Automation: Deploy orchestration workflows via Apache Airflow, dbt, or Prefect with CI/CD database practices.

Required Skills & Qualifications

8+ years of total IT experience, with 4+ dedicated years in data engineering and distributed processing.

Snowflake Expertise: Hands-on with Snowpipe, Streams, Tasks, Zero-Copy Cloning, and Time Travel.

AWS Redshift Mastery: Deep knowledge of Redshift Spectrum, concurrency scaling, and distribution key optimization.

Languages: Advanced SQL (complex CTEs, window functions) and Python (pandas, PySpark, custom pipeline frameworks).

Data Tools: Hands-on experience with dbt and Apache Airflow.

Cloud Ecosystem: Strong core AWS background (S3, Glue, Lambda, IAM, CloudWatch).

Nice to Have

Prior experience with Redshift-to-Snowflake migrations.

Streaming tools familiarity (Kafka, AWS Kinesis).

Infrastructure as Code (Terraform or CloudFormation).

Relevant certifications: SnowPro Core/Advanced, AWS Certified Data Engineer, or AWS Solutions Architect.

To Apply:

Submit your updated resume along with your current availability and contact details to [] or apply directly via this posting.