Why this role stands out
This hands-on lead role offers a significant opportunity to shape a data modernization program using AWS and Snowflake, with the potential for long-term impact. You'll thrive here if you possess advanced SQL and Snowflake expertise, enjoy guiding a small team, and value a hybrid work environment that fosters collaboration and growth. Apply now to leverage your skills in this exciting, extended-term contract position.
Quick overview
Job description
Data Engineer Lead – AWS, Snowflake, Advanced SQL
Location: Richmond, VA or Atlanta, GA Type: Contract (W2 / 1099) – through December 2027 Employment: No C2C / No third-party vendors Openings: 3 Interview: Immediate
About the Role seeking Data Engineer Leads with advanced SQL and Snowflake skills to join a long-term data modernization program for a healthcare client. This is a hands-on lead role: you will build and optimize pipelines yourself while guiding a small pod of engineers.
Responsibilities
- Design, develop, and maintain ELT/ETL pipelines into Snowflake using AWS-native services
- Write, tune, and review complex SQL (CTEs, window functions, semi-structured/JSON, performance optimization)
- Build reusable data models and transformation layers to support analytics and reporting
- Implement data quality checks, monitoring, and alerting
- Lead a small team of engineers: task breakdown, code reviews, and technical guidance
- Collaborate with architects, analysts, and QA in an Agile environment
Required Skills
- 7+ years in data engineering, including 2+ years leading engineers or workstreams
- Advanced SQL – must be able to demonstrate in a technical interview
- Strong hands-on Snowflake experience (warehouses, streams, tasks, Snowpipe, RBAC, performance tuning)
- AWS data services (S3, Glue, Lambda, Redshift, Kinesis, or similar)
- Python for data processing and automation
- Experience with dbt, Airflow, or comparable orchestration/transformation tooling
Nice to Have
- Healthcare data experience (claims, membership, clinical, HIPAA-regulated environments) is a plus
- Snowflake SnowPro certification
Please apply only if your experience closely matches the required skills above.
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- CG
Sr. Data Engineer with Security ClearanceRecently posted
Contact Government Services, LLC · Albany, NY · Hybrid · Posted 21 Nov 2026 🇺🇸
SQLShellGit+10Technology$144.8k - $209.1k/yr - CG
Discovery Database Administrator (DBA) (Top Secret Clearance Req with Security ClearanceRecently posted
Contact Government Services, LLC · New York, NY · Hybrid · Posted 21 Nov 2026 🇺🇸
SQLSQL ServerTechnology$142.1k - $192.8k/yr - CG
Senior Database Administrator with Security ClearanceRecently posted
Contact Government Services, LLC · Boston, MA · Hybrid · Posted 19 Nov 2026 🇺🇸
SQLAWSVMware+4Technology$89.3k - $121.2k/yr - IN
Data/Lead Data EngineerRecently posted
InfoCepts · Coopersburg, Pennsylvania · On-site · Posted 21 Nov 2026 🇺🇸
Stakeholder ManagementSQLApache Spark+3TechnologySalary not listed - HI
Deployment Strategist - DatabricksRecently posted Auto Apply
Hiflylabs · Jersey City, NJ · On-site · Posted 20 Nov 2026 🇺🇸
DatabricksAgileData AnalysisTechnologySalary not listed - OR

Senior Data Engineer- Fusion Experience Auto Apply
Oracle · Cleveland · Hybrid · Posted 5 Nov 2026 🇺🇸
OnboardingOracleETLTechnology$95.6k - $209.5k/yr - HA

Data EngineerRecently posted
Harris Corporation · Salt Lake City, UT · Hybrid · Posted 18 Nov 2026 🇺🇸
DockerMySQLSQL+21TechnologySalary not listed - CA

Senior Data Engineer - DatabricksRecently posted
Capgemini America, Inc. · United States · Hybrid · Posted 21 Nov 2026 🇺🇸
SQLApache SparkAWS+10Technology$133k - $153k/yr - CA

Data Migration EngineerRecently posted
Capgemini America, Inc. · United States · Hybrid · Posted 19 Nov 2026 🇺🇸
Generative AIEngineering$80.4k - $106.0k/yr - WY
Database Engineer 2 with Security ClearanceRecently posted
Wyetech · Linthicum Heights, MD · Hybrid · Posted 20 Nov 2026 🇺🇸
DjangoDockerFlask+14TechnologySalary not listed - CG
Senior Database Administrator with Security ClearanceRecently posted
Contact Government Services, LLC · New York, NY · Hybrid · Posted 21 Nov 2026 🇺🇸
SQLAWSVMware+4Technology$89.3k - $121.2k/yr - NF

Principal Data Engineer
Navy Federal Credit Union · Vienna, VA · Hybrid 🇺🇸
SQLETLTableau+10TechnologySalary not listed