As part of the Last Mile Science & Technology organization youll partner closely with Product Managers Data Scientists and Software Engineers to drive improvements in Amazons Last Mile delivery network. You will leverage data and analytics to generate insights that accelerate the scale efficiency and quality of the routes we build for our drivers through our endtoend last mile planning systems. You will develop complex data engineering solutions using AWS technology stack (S3 Glue IAM Redshift Athena). You should have deep expertise and passion in working with large data sets building complex data processes performance tuning bringing data from disparate data stores and programmatically identifying patterns. You will work with business owners to develop and define key business questions and requirements. You will provide guidance and support for other engineers with industry best practices and direction. Analytical ingenuity and leadership business acumen effective communication capabilities and the ability to work effectively with crossfunctional teams in a fastpaced environment are critical skills for this role.
Key job responsibilities
Design implement and support data warehouse / data lake infrastructure using AWS big data stack Python Redshift Quicksight Glue/lake formation EMR/Spark/Scala Athena etc.
Extract huge volumes of structured and unstructured data from various sources (Relational /Nonrelational/NoSQL database) and message streams and construct complex analyses.
Develop and manage ETLs to source data from various systems and create unified data model for analytics and reporting
Perform detailed sourcesystem analysis sourcetotarget data analysis and transformation analysis
Participate in the full development cycle for ETL: design implementation validation documentation and maintenance.
3 years of data engineering experience
4 years of SQL experience
Experience with data modeling warehousing and building ETL pipelines
Experience in at least one modern scripting or programming language such as Python Java Scala or NodeJS
Experience as a data engineer or related specialty (e.g. software engineer business intelligence engineer data scientist) with a track record of manipulating processing and extracting value from large datasets
Experience with AWS technologies like Redshift S3 AWS Glue EMR Kinesis FireHose Lambda and IAM roles and permissions
Experience with nonrelational databases / data stores (object storage document or keyvalue stores graph databases columnfamily databases)
Experience building/operating highly available distributed systems of data extraction ingestion and processing of large data sets
Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process including support for the interview or onboarding process please visit
for more information. If the country/region youre applying in isnt listed please contact your Recruiting Partner.