Back to Jobs
Recently postedTechnology

Data Engineer Lead AWS, Snowflake, Advanced SQL

Avis Global IT Solutions IncAtlanta, GA🇺🇸United States

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

Work modeHybrid
LocationAtlanta, GA, United States
SQLAWSETLSnowflakeAirflowHIPAAPythonRedshiftdbtAgile

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