Senior Data Engineer (Snowflake, AWS)

ECCO Select is hiring a Senior Data Engineer to design, build, and maintain data pipelines and a Snowflake data platform on AWS. This hybrid role supports analytics and business reporting by integrating data from multiple internal and external systems, while partnering closely with analysts, BI developers, application engineers, and stakeholders.

Based in Atlanta, this contract position is focused on production-grade data engineering across pipeline orchestration, Snowflake modeling, performance tuning, and governance. The ideal candidate brings hands-on Snowflake and AWS experience and can collaborate effectively across technical and business teams.

Role Summary

As a Senior Data Engineer, you will integrate data from application systems, SaaS platforms, and third-party sources, then transform and deliver trusted datasets through a clean, well-modeled Snowflake environment. You will help ensure reliability with monitoring, data quality checks, and security controls, while documenting flows and contributing to code reviews.

Responsibilities

• Design and build batch and near-real-time data pipelines on AWS using S3, Glue, Lambda, and Step Functions.
• Develop and maintain Snowflake data models across raw, staging, and reporting layers for analytics and business reporting.
• Load and transform data in Snowflake using Snowpipe, Streams and Tasks, and external stages.
• Integrate data from internal applications, SaaS platforms, and third-party sources via APIs and file-based feeds.
• Tune Snowflake for performance and cost using warehouse sizing, query optimization, and usage monitoring.
• Implement data quality checks, monitoring, and alerting to identify pipeline failures and data issues early.
• Apply data security and governance standards, including role-based access control and data masking.
• Partner with teams supporting .NET-based application systems to source data and support integrations.
• Document data flows, models, and processes, and participate in code reviews.

Required Qualifications

• 5-7+ years of data engineering experience.
• Hands-on Snowflake experience, including data modeling, SQL development, and performance tuning.
• Production experience with AWS data services including S3, Glue, Lambda, and Step Functions.
• Advanced SQL and a strong understanding of data warehousing concepts such as dimensional modeling and ELT patterns.
• Familiarity with C#/.NET sufficient to read, support, or build data integrations with .NET applications.
• Experience with Git and CI/CD practices.
• Strong communication skills and a collaborative approach with both technical and business teams.
• Bachelor’s degree in Computer Science or a related field, or equivalent experience.

Tech Stack

• Snowflake, AWS
• S3, Glue, Lambda, Step Functions
• SQL, dimensional modeling, ELT
• C#/.NET, Git, CI/CD
• Snowpipe, Streams and Tasks, external stages
• APIs, role-based access control, data masking

Contract Details

• Duration: 6 month+ contract to hire
• Schedule: Hybrid, onsite 2 days weekly
• Start date: November
• Work location: Hybrid remote in Atlanta, GA 30318

Benefits

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Vision insurance

Nice to Have

• Experience with dbt, Python, or Airflow.
• Infrastructure as code with Terraform or CloudFormation.
• Experience with Power BI, Tableau, or other BI tools that use Snowflake.
• Background in events, hospitality, or customer engagement data.
• SnowPro Core or AWS Data Engineer (Associate) certification.

Application Questions

• Are you based in the Atlanta region and willing to work a hybrid schedule coming onsite 2 days weekly?
• Can you work as a W2 employee of the agency without sponsorship or future visa transfer?
• Do you have 5 or more years of experience in data engineering?
• Do you have in-depth hands-on technical experience with the Snowflake platform?
• Do you design, build, and maintain data pipelines regularly?
• Are you proficient with AWS data services such as S3, Glue, Lambda, or Step Functions?