Data Engineer II, APM Insights
Job Description
Build reliable data infrastructure that helps teams across Amazon make better decisions faster. In this Data Engineer II role, you will design and operate scalable data solutions across the full data lifecycle, enabling dependable, high-quality datasets and self-service analytics. You will help strengthen stability, performance, and data governance while partnering with engineers, scientists, and analysts to deliver measurable business value.
What you’ll do
- Design, build, and maintain scalable ETL/ELT pipelines and data infrastructure, keeping stability, performance, and efficient resource usage front and center across large-scale datasets.
- Create coherent logical and physical data models aligned to business requirements, balancing flexibility with pragmatic design trade-offs.
- Collaborate with analysts, scientists, and engineering peers to gather requirements, define data architecture, and deliver usable datasets that drive business outcomes.
- Raise data quality, discoverability, and governance by building tools and processes for data lineage tracking, auditing, and automated management of data operations.
- Participate in code reviews and design discussions, support operational excellence initiatives, and mentor peers on data engineering standards.
Requirements
- 3+ years of data engineering experience.
- 1+ year developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes.
- 1+ year developing and operating large-scale data structures for business intelligence analytics using OLAP technologies.
- 1+ year developing and operating large-scale data structures for business intelligence analytics using data modeling.
- 1+ year developing and operating large-scale data structures for business intelligence analytics using SQL.
- 1+ year developing and operating large-scale data structures for business intelligence 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 business intelligence analytics using each of: ETL (Extract, Transform, Load) and 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 you’ll work with
SQL, ETL, ELT, OLAP, Oracle, AWS, Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, IAM, plus work spanning data modeling, data warehousing, and non-relational databases (object storage, document databases, key-value stores, graph databases, column-family databases). The role may also leverage generative AI tools to accelerate productivity.
Benefits
- Health insurance (medical, dental, vision, prescription, Basic Life & AD&D, and option for Supplemental life plans), EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, and Adoption and Surrogacy Reimbursement coverage
- 401(k) matching
- Paid time off
- Parental leave
- Sign-on payments
- Restricted stock units (RSUs)
A day in the life
- Review pipeline health and address data quality issues, then move into development on a new data model or pipeline enhancement.
- Pair with data scientists and participate in design reviews to refine feature engineering workflows and evaluate architecture proposals.
- Use SQL, scripting languages, and distributed systems technologies to solve real problems, leveraging generative AI tools where they can help.
- Expect a blend of hands-on engineering, collaboration with teammates, and decisions that align your solutions with the broader data ecosystem.
About the team
The team builds reliable, performant data infrastructure that supports faster decision-making across Amazon. Collaboration, technical craftsmanship, and a commitment to simplifying and improving accessibility of data solutions are core values. As the team grows, you’ll have opportunities to influence data architecture and how new challenges are approached, in an inclusive environment where every voice matters.
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 (object storage, document or key-value stores, graph databases, column-family databases).
- Knowledge of professional software engineering and 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.
Location: New York, NY (onsite)
Salary: USD 145,300 - 196,600 per year