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.
Never miss an opportunity! Create an alert based on the job you applied for.
