Senior Data Engineer (Snowflake, AWS)
Senior
Amazon Web Services
AWS
Aws Data Engineer
Aws Data Engineering
Aws Data Lake
Aws Glue
Cloud
Cloud Computing
Cloud Data Engineering
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Engineering
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Data Warehousing
Database
Databases
ETL
Informatica
IT Services
Reporting and Analytics
Snowflake
Snowflake Database
Snowpipe
SQL
Job Description
Senior Data Engineer role focused on building AWS-based data pipelines and a Snowflake data platform for analytics and reporting.
Responsibilities
- Design and implement 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 detect pipeline failures and data issues early
- Apply data security and governance, including role-based access control and data masking
- Collaborate with teams using .NET-based systems to support data sourcing and integrations
- Document data flows, models, and processes; participate in code reviews
Requirements
- 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: S3, Glue, Lambda, Step Functions
- Advanced SQL and strong data warehousing concepts, including dimensional modeling and ELT patterns
- Familiarity with C#/.NET sufficient to read, support, or build data integrations
- Experience with Git and CI/CD practices
- Strong communication skills and a collaborative approach with technical and business teams
- Bachelor’s degree in Computer Science or related field, or equivalent experience
Technologies
- Snowflake, AWS
- S3, Glue, Lambda, Step Functions
- SQL, dimensional modeling, ELT
- C#/.NET, .NET, Git
- CI/CD
- Snowpipe, Streams and Tasks, external stages
- APIs
- Role-based access control, data masking
Benefits
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Vision insurance
Nice to Have
- 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
Contract Details
- Job type: contract
- Duration: 6 month+ contract to hire
- Start date: November
- Schedule: Hybrid (onsite 2-days weekly)
- Location: Atlanta, GA
- Work location: Hybrid remote in Atlanta, GA 30318
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 our 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?