Data Engineer II, APM Insights
Artificial Intelligence
Aws Data Engineer
Aws Data Engineering
Big Data
Cloud Data Engineering
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Engineering
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Database
Databases
Enterprise Data Engineering
ETL
Informatica
SQL
Job Description
Amazon.com Services LLC is hiring a Data Engineer II to design and build scalable data solutions across the full data lifecycle. The role focuses on reliable, high-quality datasets and self-service analytics by delivering ETL/ELT pipelines, data models, and governance capabilities.
Role Overview
In this onsite position in New York, NY, you will partner with engineering peers, analysts, and scientists to translate business needs into data architecture. You will build and operate data infrastructure, improve data quality and lineage visibility, and contribute to operational excellence through reviews, design discussions, and mentoring.
Responsibilities
- Design, build, and maintain scalable ETL/ELT pipelines and data infrastructure, ensuring stability, performance, and efficient resource usage across large-scale datasets.
- Create coherent logical and physical data models that accurately reflect business requirements, implementing solutions that balance flexibility with practical design trade-offs.
- Collaborate with analysts, scientists, and engineers to gather requirements, define data architecture, and deliver datasets that provide measurable business value.
- Enhance data quality, discoverability, and governance by building tools and processes for data lineage tracking, auditing, and automated management of data operations.
- Participate actively in code reviews, design discussions, and operational excellence initiatives, supporting team best practices and mentoring peers on data engineering standards.
Requirements
- 3+ years of data engineering experience.
- 1+ year developing and operating large-scale data structures for BI analytics using ETL/ELT processes.
- 1+ year developing and operating large-scale data structures for BI analytics using OLAP technologies.
- 1+ year developing and operating large-scale data structures for BI analytics using data modeling experience.
- 1+ year developing and operating large-scale data structures for BI analytics using SQL.
- 1+ year developing and operating large-scale data structures for BI analytics using Oracle.
- 3+ years of experience in the job offered or a related occupation.
- 1+ year developing and operating large-scale data structures for BI analytics using each of the following: ETL (Extract, Transform, Load) / ELT (Extract, Load, Transform).
- Bachelor’s degree or foreign equivalent in Computer Science, Engineering, Information Systems, Mathematics, or a related field.
- Experience with data modeling, data warehousing, and building ETL pipelines.
Technologies
- SQL, ETL, ELT, OLAP, Oracle
- AWS, including Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, IAM
- Data modeling, data warehousing
- Non-relational databases and data stores (object storage, document databases, key-value stores, graph databases, column-family databases)
- Generative AI
Compensation
USD 145,300 - 196,600 per year.
A Day in the Life
- Review pipeline health and resolve data quality issues before working on new data model development or pipeline improvements.
- Pair with data scientists to refine feature engineering workflows, and join design reviews to evaluate architecture proposals.
- Use SQL, scripting languages, and distributed systems technologies to address complex problems, leveraging generative AI tools where they can accelerate productivity.
- Contribute through hands-on coding, collaborative problem-solving, and strategic input on how data solutions fit into the broader ecosystem.
Team Focus
- Build reliable, high-performing data infrastructure that helps Amazon teams make better decisions faster.
- Emphasize collaboration, technical craftsmanship, and making data solutions simpler and more accessible over time.
- As the team grows, you will have opportunities to shape data architecture and influence approaches to new challenges.
- Maintain an inclusive environment where every voice matters and contributions support Amazon’s mission to be the most customer-centric company on Earth.
Preferred Qualifications
- Experience with AWS technologies such as Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions.
- Experience with non-relational databases/data stores including object storage, document or key-value stores, graph databases, and column-family databases.
- Knowledge of professional software engineering best practices across the full software development life cycle, including coding standards, software architectures, code reviews, source control management, continuous deployments, testing, and operational excellence.
Benefits
- Health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance, and option for Supplemental life plans), EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage
- 401(k) matching
- Paid time off
- Parental leave
- Sign-on payments
- Restricted stock units (RSUs)
Similar Jobs
C