Senior AWS Data Engineer - Enterprise Pipelines & DW

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

Job summary

Atrium is seeking a Senior Data Engineer - AWS to own enterprise data pipelines and build scalable cloud data architecture. You will collaborate with Data Science, Analytics, and business stakeholders to deliver reliable, scalable data solutions while contributing to a collaborative Engineering team.

The ideal candidate has expert SQL and extensive AWS data engineering experience (Glue, Lambda, S3, Athena, EMR, Redshift) and can mentor junior engineers.

Qualifications

• 5+ years of experience in Data Engineering or a related field.
• Expert SQL skills with complex querying, optimization, and performance tuning.
• Strong AWS data engineering experience (Glue, Lambda, S3, Athena, EMR, Redshift).
• Ability to design scalable data architectures and enterprise data warehouses.
• Experience building and optimizing ETL/ELT pipelines and data models.

Responsibilities

• 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.

Skills

SQL

AWS

Data engineering

ETL/ELT

Data modeling

Data quality

Communication

Education

Bachelor's degree

Tools

AWS Glue

AWS Redshift

S3

Athena

EMR

Job description

Atrium is seeking a Senior Data Engineer - AWS to own enterprise data pipelines and build scalable cloud data architecture. You will collaborate with Data Science, Analytics, and business stakeholders to deliver reliable, scalable data solutions while contributing to a collaborative Engineering team.

The ideal candidate has expert SQL and extensive AWS data engineering experience (Glue, Lambda, S3, Athena, EMR, Redshift) and can mentor junior engineers.