Data Engineer - snowflake to AWS (W2)

We are seeking an experienced Data Migration Engineer to support a Federal client in migrating enterprise data platforms from Snowflake to AWS Cloud services. The ideal candidate will have strong hands‑on experience with Snowflake data extraction, AWS data lake and analytics services, and secure data migration methodologies aligned with Federal compliance standards. Role : Data Engineer. Location : Remote. Note : Only USC and GC. Key Responsibilities Design and implement end‑to‑end data migration strategies from Snowflake to AWS cloud platforms Extract data from Snowflake using COPY INTO, Snowflake stages, and secure data sharing mechanisms Migrate data to AWS services including Amazon S3, Redshift, Athena, RDS/Aurora, and Glue Data Catalog Develop and optimize data pipelines using AWS Glue, Lambda, Step Functions, and Python Perform data validation, reconciliation, and quality checks post‑migration Convert Snowflake schemas, tables, views, and data types to AWS‑compatible formats Implement incremental and batch migration strategies using Snowflake Streams and Tasks Ensure compliance with Federal security and data governance standards (FedRAMP, FISMA, NIST) Optimize data formats (Parquet/ORC) for cost, performance, and scalability Collaborate with cloud architects, security teams, and stakeholders to meet project milestones Create technical documentation, migration runbooks, and operational guides Monitor migration jobs and resolve performance, data consistency, or failure issues Support post‑migration testing, optimization, and production cutover activities Technical Skills Strong hands‑on experience with Snowflake (data unloading, stages, file formats, performance tuning) Experience migrating data to AWS Cloud, including Amazon S3, Amazon Redshift, AWS Glue (ETL & Data Catalog), AWS Athena Proficiency in SQL and Python Experience with data formats: Parquet, ORC, CSV, JSON Knowledge of AWS IAM, roles, policies, and secure access patterns Experience with large‑scale data migration and data warehousing concepts Familiarity with CI/CD pipelines and automation for data workflows Compliance Requirements Experience working with Federal or Government clients Understanding of FedRAMP, FISMA, NIST 800-53 Knowledge of data encryption (at rest and in transit) and audit logging Ability to follow government change management and documentation standards Preferred Qualifications AWS Certified (Solutions Architect, Data Analytics, or Developer) Snowflake SnowPro Certification Experience with Terraform or CloudFormation Prior experience supporting data lake modernization projects Experience with PII/PHI data handling in regulated environments Education Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field Equivalent work experience may be considered Clearance Requirement Active or ability to obtain Federal clearance (Public Trust / Secret based on project needs) Nice‑to‑Have Skills AWS DMS (indirect Snowflake use cases) Apache Airflow or managed workflow services Data governance and metadata management tools #J-18808-Ljbffr