Senior Data Engineer - AWS

The ideal candidate for the Senior Data Engineer - AWS role will have expert-level SQL skills, extensive experience with AWS data technologies, and a strong background in data architecture and enterprise data warehousing. Known for their commitment to innovation, performance, and exceptional customer experiences, the company fosters a collaborative, learning-focused culture where technology plays a critical role in driving business growth.

Client Overview:
Our client is a well-established, high-growth lifestyle and wellness organization with a strong presence in New York City and across major global markets. Known for their commitment to innovation, performance, and exceptional customer experiences, the company fosters a collaborative, learning-focused culture where technology plays a critical role in driving business growth. We are seeking an experienced Senior Data Engineer - AWS to join our client's growing Technology team in New York City.

Salary/Hourly Rate:
$145k - $185k Annually

Position Overview:
This is a hands-on opportunity to take ownership of enterprise data pipelines, build scalable cloud-based data architecture, and optimize a modern AWS data environment. The ideal candidate for the Senior Data Engineer - AWS role will have expert-level SQL skills, extensive experience with AWS data technologies, and a strong background in data architecture and enterprise data warehousing. This individual will work closely with Data Science, Analytics, and business stakeholders to deliver reliable, scalable data solutions while contributing to a collaborative Engineering team.

Responsibilities of the Senior Data Engineer - AWS:

• Design, develop, and maintain scalable data pipelines and enterprise data warehouse architecture within AWS.
• Build and optimize complex SQL queries, ETL/ELT processes, and data models.
• Leverage AWS services including Glue, Lambda, S3, Athena, EMR, and Redshift.
• Develop and maintain data schemas, dimensional models, and warehouse structures.
• Monitor, troubleshoot, and optimize data pipelines for performance and reliability.
• Implement data quality checks, validation rules, and automated monitoring processes.
• Collaborate with Data Science, Analytics, and Business teams to support enterprise data initiatives.
• Maintain technical documentation, data lineage, and engineering best practices.
• Participate in Agile ceremonies, code reviews, and technical planning.
• Mentor junior engineers and collaborate with offshore team members.

Required Experience/Skills for the Senior Data Engineer - AWS:

• 5+ years of professional experience in Data Engineering or a related technical field.
• Expert-level SQL skills, including complex querying, optimization, and performance tuning.
• Strong hands-on AWS data engineering experience, particularly with Glue, Lambda, S3, Athena, EMR, and Redshift.
• Proven experience designing and implementing scalable data architectures and enterprise data warehouses.
• Strong understanding of ETL/ELT pipelines, data modeling, and data integration.
• Experience troubleshooting production data pipelines and ensuring data quality.
• Ability to independently own technical projects from design through deployment.
• Strong communication, analytical, and problem-solving skills.
• Must be authorized to work in the United States without current or future employer sponsorship. Visa sponsorship is not available.
• Must be able to work on-site in NYC four days per week.

Preferred Experience/Skills for the Senior Data Engineer - AWS:

• Experience with dbt (data build tool) and modern analytics engineering practices.
• Python or PySpark proficiency.
• Experience with dimensional modeling, star schemas, and data warehouse optimization.
• Previous experience mentoring junior engineers or working with offshore teams.
• Familiarity with data governance, observability, and automated data quality frameworks.

Education Requirements:

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

Benefits:

• Comprehensive benefits information will be provided during the interview process.

Job Wrapping ID: #LI-AJ3

About Atrium:What you do matters. Guided by our Applicant-Centric™ approach, we foster an environment of collaboration, high performance, and innovation where your talents are valued, and your achievements are celebrated. Join us and become part of an inclusive team committed to your growth and success. By applying to this job, you agree to receive calls, AI-generated calls, text messages, and/or emails from Atrium and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to opt out on any message you receive. For more details, please review our Terms of Use and Privacy Policy . As a woman-owned firm, we value diversity. We are an equal opportunity and affirmative action employer and will consider all applications without regard to race, sex (including gender, pregnancy, sexual orientation and gender identity), age, color, religion or creed, national origin or ancestry, veteran status, disability (physical or mental), genetic information, citizenship or any other characteristic protected by law. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Candidates who apply for roles through the Atrium website will be added to our candidate pool and may be considered for additional roles of a similar title. Please contact us to request an accommodation.
EOE/M/F/D/V/SO

Position ID: 411436