Senior AWS Data Engineer

Atrium Staffing; New York (NY); On-site; USD 145,000 - 160,000; Full time

Benefits offered by this job

Complimentary fitness club membership

Employee perks across company products

Wellness offerings (PT, Pilates, Spa,/

Job summary

Atrium Staffing is seeking a Senior AWS Data Engineer for their New York City team. This hands-on role focuses on ownership of scalable data pipelines and architecture, collaborating with analytics, data science, and business units.

The ideal candidate has strong AWS/SQL experience, a background in data modeling and warehousing, and will work on design through deployment in a fast-growing environment. Onsite 4 days/week in NYC is required.

Qualifications

• 5+ years of professional Data Engineering experience.
• Expert-level SQL skills with complex queries and performance tuning.
• Strong hands-on AWS data ecosystem experience (S3, Glue, Lambda, Athena, EMR).
• Experience with Redshift and enterprise data warehousing.
• Ability to own solutions from design to deployment.
• Onsite in NYC 4 days per week.
• Authorized to work in the U.S. without sponsorship.

Responsibilities

• Design, build, and maintain scalable data pipelines and data architecture within AWS.
• Build and manage data models and schemas for a data warehouse.
• Develop reusable data solutions using AWS services (S3, Glue, Lambda, Athena, EMR, Redshift).
• Write and optimize complex SQL queries across large datasets.
• Monitor and troubleshoot data jobs, pipelines, and platform performance.
• Implement data quality checks, validation, monitoring, and alerting.
• Support dimensional modeling and star schemas for enterprise warehousing.
• Partner with Data Science, Analytics, Engineering, and business teams on data requirements.
• Improve data lineage, documentation, governance, and reusable engineering practices.
• Participate in code reviews, sprint planning, and Agile development.
• Mentor junior engineers and collaborate with offshore teams.

Skills

Advanced SQL

AWS data services

Data architecture

ETL/ELT pipelines

Data warehousing

Leadership mentoring

Education

Bachelor's degree or equivalent experience

Tools

S3

Glue

Lambda

Athena

EMR

Redshift

Job description

Client Overview:

Our client is a well-known lifestyle and wellness organization based in New York City, seeking an experienced Senior AWS Data Engineer to join their Technology team. This is a hands-on opportunity to take ownership of data pipelines and architecture while working within a collaborative, growth-focused environment.

Salary/Hourly Rate:

$145k - $160k

Position Overview:

Our client is seeking a Senior AWS Data Engineer with strong hands-on AWS and SQL experience to help build, structure, and continuously improve an enterprise data environment. This person will take ownership of scalable data pipelines, architecture, data modeling, and warehouse quality while partnering closely with analytics, data science, and business teams. This is a hands-on engineering position for someone who is comfortable building solutions from the ground up and taking ownership from design through deployment. Candidates must be authorized to work in the United States without current or future sponsorship. This position is unable to provide visa sponsorship or relocation assistance.

Responsibilities of the Senior AWS Data Engineer:

• Design, build, and maintain scalable data pipelines and data architecture within AWS.
• Build and manage data models and schemas supporting an enterprise data warehouse.
• Develop reusable data solutions using AWS services including S3, Glue, Lambda, Athena, EMR, and Redshift.
• Write and optimize complex SQL queries across large datasets.
• Monitor and troubleshoot data jobs, pipelines, and overall platform performance.
• Implement data quality checks, validation, monitoring, and alerting.
• Support dimensional modeling, including star schemas and enterprise warehouse design.
• Partner with Data Science, Analytics, Engineering, and business teams on data requirements.
• Improve data lineage, documentation, governance, and reusable engineering practices.
• Participate in code reviews, sprint planning, and Agile development.
• Mentor Junior Engineers and collaborate with offshore team members.

Required Experience/Skills for the Senior AWS Data Engineer:

• 5+ years of professional Data Engineering experience.
• Expert-level SQL skills with experience writing complex queries and optimizing performance.
• Strong hands-on experience within the AWS data ecosystem.
• Hands-on experience with S3, Glue, Lambda, Athena, and EMR.
• Experience with Redshift and enterprise data warehousing.
• Strong data architecture and data modeling experience.
• Experience building scalable ETL/ELT pipelines from scratch.
• Ability to take ownership of solutions from design through deployment.
• Must be able to work onsite in New York City 4 days per week.
• Must be authorized to work in the U.S. without current or future sponsorship.

Preferred Experience/Skills for the Senior AWS Data Engineer:

• dbt Labs experience.
• Python experience.
• Experience with dimensional modeling and star schemas.
• Experience mentoring junior engineers and/or working with offshore teams.
• Experience with data governance, quality, lineage, and observability.

Education Requirements:

• Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Science, or a related field is preferred, or equivalent professional experience.

Benefits:

• Competitive salary and comprehensive benefits package.
• Complimentary fitness club membership.
• Employee perks and incentives across company products and services.
• Access to wellness offerings including Personal Training, Pilates, Spa, and retail/shop discounts.
• Opportunity to join a collaborative, high-performance culture with an emphasis on learning and professional growth.

Job Wrapping ID: #LI-AJ3