Snowrelic Inc · 2 weeks ago
Senior Data Engineer - snowflake to AWS (Direct Client Hire (FTE))
Snowrelic Inc is seeking a Senior Data Engineer to lead complex data engineering efforts for Treasury’s migration from legacy SAS platforms to Snowflake on AWS. The role involves designing and optimizing data pipelines while ensuring compliance with federal standards.
Cloud ComputingInformation TechnologySoftware Engineering
Responsibilities
Design and implement scalable SAS to Snowflake data migration pipelines
Lead ingestion into Snowflake using optimized staging, partitioning, and file formats
Develop ETL workflows using AWS Glue, Python, and SQL
Optimize Snowflake performance, cost, and storage
Implement incremental and batch processing strategies
Perform data profiling, reconciliation, and migration validation
Enforce security controls aligned with FedRAMP, FISMA, and NIST 800-53
Review code, mentor Data Engineers, and enforce best practices
Collaborate with Data Architects, security teams, and stakeholders
Qualification
Required
Strong experience migrating SAS-based platforms to Snowflake or cloud data warehouses
Advanced hands-on experience with Snowflake
Strong AWS experience including S3, Glue, IAM, and Lambda
Expertise in SQL and Python
Experience with large-scale enterprise data migrations
Familiarity with CI/CD and automation
Preferred
Prior experience supporting Treasury or Federal programs
AWS Certification preferred (AWS Data Analytics, Solutions Architect, or Developer)
Experience with Terraform or CloudFormation
Knowledge of Parquet and ORC data formats
Snowflake SnowPro certification a plus
Active Public Trust clearance is plus, however client will sponsor clearance for qualified candidates